(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 serve resolution to allow remote connections