Shulou(Shulou.com)05/31 Report--

This article shows you how to remotely connect to the SQL Server database, the content is concise and easy to understand, it will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

First, you need to set up the client network utility.

Click start-programs, and select client Network Utilities from the Microsoft SQL Server menu. Click add in the aliases option. In the "server alias", fill in the domain name of your website, click "TCP/IP" in the "network library" area, cancel "dynamically determine port" in the "connection parameters" area, and specify the "port number" as 2433. When you are finished, click OK to save the configuration.

The second is the use of enterprise manager.

Click "start"-"programs" to open "Enterprise Manager" in the "Microsoft SQL Server" menu. In Enterprise Manager, right-click SQL Server Group and select New SQL Server Registration. The SQL Server properties window will appear, fill in the domain name of your website in "Server", select "use SQL Server Authentication", "login name" and "password" to fill in the user name and password in the host opening email, and then click "OK". After the connection is successful, you will see that there is an additional server named your website domain name in the SQL Server group. At this point, you can manage the Web site database as if you were working with the local SQL database.

Note:

If a timeout error occurs when connecting, change the timeout by clicking "tools"-"options". Select the Advanced tab in the properties window and set the value for logon timeout to 0.

The above content is how to connect to SQL Server database remotely. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.