>>>Guide on - Running Remote Servers<<<

View previous topic View next topic Go down

>>>Guide on - Running Remote Servers<<<

Post by  on Sun Dec 23, 2007 11:25 am

Well, first of all I suggest you download Microsoft SQL.
If you are going to run remote, installing the client version of SQL is enough.

SERVER SIDE
1. On the server configure its Networking Configuration (right click server and properties in Enterprise Manager)
2. Enable TCP/IP and specify a port. (properties of TCP/IP) (REMEMBER THE PORT NUMBER)
3. Then click the Active Directory tab, Add the server to Active server directory.
4. Click to Security Tab - select SQL Server and Windows for Authentication
5. Make sure there is an "sa" account in the Users section. It is there by default, change the password to whatever you like.


CLIENT SIDE
1. Install the SQL Client
2. Open SQL Server Client Network Utility
3. Enable TCP/IP, in properties change the port to the one you specified on SERVER.
4. Go to Alias, click Add -
Server Alias (name for server) eg. MU
Server Name (server IP) eg. abc.no-ip.com
Port Number (should be the port you specified earlier)
5. Click OK and head on to Enterprise Manager
6. Add a new server, select the <Server name> you have made in Server Alias of the network utility.
7. Use SQL login and use the "sa" account with the password you have made.
It should connect successfully and it will show the database files.

Make the appropriate ODBCs to have server-client communication in other programs.
Theres another guide for adding ODBC so go search for it.

Once its done, if you want to use MU Editor REMOTELY
OPEN the DNS.ini file in the directory.
DNS = <ODBC NAME YOU MADE FOR MU SERVER> eg. MuOnline
User= sa
Password = <the one you made> eg. abcdefg

Save and close the file, MU Editor will now work!

If you want to run WEBSERVER REMOTELY (like my private server),
in conn/config files for the site, you may type in "MU" (or if you made
another name in Server Alias, use that) for server address ($dbhost).
It should locate the server automatically.


Favourite Game : MuOnline
Registration date : 1969-12-31

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum