| when setting up a private server, two servers are often used for load balancing. Some people often ask me how to do this, today, I will send out the method of this dual-host load for you to learn. 1. set the client network utility
click "start"-" Program ", select "client network utility" from the "microsoftsqlserver" menu ".
click "add" in the "alias" option ".
in "server alias", enter your website domain name, and click "TCP/IP" in the "Network Library" area ", in the "connection Parameters" area, cancel "dynamically determine port" and specify "port number" as 2433. After entering the information, click "OK" to save the configuration. 2. Use the Enterprise Manager
click "start"-"program" and open "Enterprise Manager" in the "microsoftsqlserver" menu ". In Enterprise Manager, right-click sqlserver group and choose create sqlserver registration ".
In the Properties window, select the "advanced" tab and set "Logon timeout" to 0. As mentioned above, the remote database is connected.
the sqlserver attribute window appears. Enter the domain name of your website in "server, select "use SQL
Server Authentication", "Login Name" and "password", fill in the user name and password in the host activation email respectively, and then click "OK ".
after the connection is successful, you will see a server named your website domain name in the sqlserver group. In this case, you can manage your website database just like you do with a local SQL database. |
