SQL Server 2008 does not connect remotely to servers

Source: Internet
Author: User
Tags sql 2008 mssqlserver management studio sql server management sql server management studio

When users use the SQL Server 2008 Remote link, the following dialog box may appear: A network link error or a specific instance error occurred while linking the SQL Server. The SQL Server does not exist or the link is unsuccessful. Verify that the user name is correct or that the SQL Server has the Remote link feature configured. (Error Discovery Party: Named pipe provider.) Error code:---cannot be linked to SQL Server)

How to deal with this problem?
If the user finds this error alert, it needs to check the configuration of three aspects and make the relevant changes. (The configuration measures shown below are in the SQL 2008 Server template)
(a) The first thing a user needs to do is to check whether a remote link is allowed in the SQL database server. This check can be done in SQL 2008 server by opening the SQL Server 2008 management project (SQL Server Management Studio). The specific actions are:
(1) Right-click the SQL Server 2008 option and select SQL Server Management Studio:

(2) Open Server properties (right-click Connection Name-Properties)

After you select the Allow users to remotely link to this server option, check to see if the issue is excluded. If the remote link is successful, the process is complete. If the user finds that the "Reminder error Dialog" Still pops up, then you need to do the following:

(ii) Configure the appropriate protocol for Microsoft SQL Server (MSSQLServer).
At this point the user is to check the SQL network link configuration. Open the SQL Server Configuration Management option > Open the SQL Server network configuration options for this node > select the Microsoft SQL Server network Protocol option (or the option to configure the network protocol for the SQL Server in the user's SQL Server, different versions of the SQL name may differ):

Determining the TCP/IP protocol in the Microsoft SQL Server Network Options protocol is valid for the server. Check again to see if you can perform the remote link. If the Error alert dialog box still pops up, we need to check the SQL Server firewall option further.

(iii) Check SQL Server firewall settings (Quick steps-Direct firewall off (unsafe))
If the client computer still cannot be linked to the SQL Server remotely after the last two steps, the user needs to reconfigure the SQL Server firewall. When you do this, first locate the port on the SQL Server that supports the TCP/IP protocol. Users can click on "TCP/IP protocol" to select "Properties" when the SQL Server firewall is already running:

As we can see, the TCP/IP protocol supported on this SQL Server is port 1433. The next step is to allow 1433 ports to support the TCP/IP protocol in the configuration of the firewall. If the server is running a Windows 7 operating system with a configuration step (similar to the practice of other Microsoft operating systems), open the Control Panel and select the Windows Firewall option:

After you select Advanced Settings, in the right menu bar, find Windows Firewall with Advanced Security options and open it. When you open it, you will find the "inbound rules" option in the left menu bar. Inboud Open the option and select the new Rule option in the right-hand menu bar:

After opening the new Rule option, configure the internal binding protocol for port 1433 with the new built-in binding Rule Wizard to apply to the TCP/IP protocol. (provided that you need to complete all the steps previously described in this step), the 1433 port configuration for port 1433 is available according to the following diagram:

Complete the above three steps, and confirm that each step is correct, the user's SQL Server can support remote link, everything OK.
(Note: When you complete the second step, you must restart the SQL service before you can) (net stop mssqlserver net start MSSQLServer).

SQL Server 2008 does not connect remotely to servers

Related Article

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.