I. Setting up a client Network Utility
Click "Start"-"Programs" and choose Client Network Utility from the Microsoft SQL Server menu.
In the alias option, click Add.
In server alias, fill in your site domain name, click TCP/IP in the network library area, cancel dynamic decision port in the connection parameters area, and specify port number 2433. When completed, click "OK" button to save the configuration.
Two. The use of Enterprise Manager
Tap Start-Programs to open Enterprise Manager on the Microsoft SQL Server menu. In Enterprise Manager, right-click SQL Server group and select new SQL Server enrollment.
Select the Advanced tab in the Properties window to set the login timeout value to 0. According to the above, the remote database is already connected.
The SQL Server Properties window appears, the domain name of your site is populated in the server, the "Use SQL Server Authentication", "Login" and "password" are filled in with the username and password of the host-opened message, and then click OK.
Once the connection is successful, you will see a server with the name of your site in the SQL Server group. At this point, you can manage the site database just as you would a local SQL database.
Precautions:
If a timeout error occurs while connecting, change the timeout by clicking Tools-Options.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.