SQL2005 Remote Connectivity Problem Solving method _mssql2005

Source: Internet
Author: User
Tags microsoft sql server microsoft sql server 2005 mssql mssqlserver
First, enable remote connections for SQL

1. Click Start, point to Programs, Microsoft SQL Server 2005, and configure tools, and then click SQL Server Perimeter Application configurator.
2. On the SQL Server 2005 Perimeter Configuration page, click the perimeter application configurator for services and connections.
3. On the perimeter application configurator for services and Connections page, expand Database engine, click Remote Connections and then connect to local and remote connections, click the appropriate protocol for your environment, and then click Apply.

Note: Please click OK when you receive the following message:
Changes to connection settings do not take effect until the Database engine service is restarted.
4. On the perimeter application configurator for services and Connections page, expand Database engine, click Services and stop, wait for the MSSQLServer service to stop, and then click Start to restart the MSSQLServer service.

second, enable SQL Server Browser service

1. Click Start, point to Programs, Microsoft SQL Server 2005, and configure tools, and then click SQL Server Perimeter Application configurator.
2. On the SQL Server 2005 Perimeter Configuration page, click the perimeter application configurator for services and connections.
3. On the perimeter application configurator for services and Connections page, click SQL Server Browser, click the Automatic option in Startup type, and then click Apply.

Note: When you click the Auto option, the SQL Server Browser service is started automatically each time you start Microsoft Windows.
4. Click Start, and then click OK.

create an exception for SQL Server 2005 in Windows firewall

1. In Windows firewall, click the Exceptions tab, and then click Add Program.
2. In the Add Programs window, click Browse.
3. Click C:\Program Files\Microsoft SQL Server\mssql.1\mssql\binn\sqlservr.exe executable program, click Open, and then click OK.

Note: The above path may vary depending on the installation location of SQL Server 2005.

Iv. Creating an exception for the SQL Server Browser service in Windows firewall

1. In Windows firewall, click the Exceptions tab, and then click Add Program.
2. In the Add Programs window, click Browse.
3. Click C:\Program Files\Microsoft SQL Server\90\shared\sqlbrowser.exe executable program, click Open, and then click OK.

Note: The above path may vary depending on the installation location of SQL Server 2005.

v. Remote connection port settings (a critical step, many methods are only one to four steps, but not the fifth step)

1. Open SQL Server Configuration Manager on the server. Select the SQL Server Configuration Manager->sql Server 2005 Network Configuration->mssqlserver Protocol->TCP/IP, in the pop-up dialog box, select the IP address->ipall->tcp port, set to the available port. (If the default 1433 port is always not connected, you will be set to confirm that you have opened the port to try, such as 21 ports, etc.)

2. On the perimeter application configurator for services and Connections page, expand Database engine, click Services and stop, wait for the MSSQLServer service to stop, and then click Start to restart the MSSQLServer service.

Vi. Test Connection

1, open the SQL2005 login interface, enter the server IP and username and password.
Such as:
Server name: 192.168.1.200,21
User name: SA
Password: SA
Point connection, the result is a successful connection.
PS: In the server name above, the TCP port in the Ipall set in step 1th of the 21 fifth step of the 21

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.