Solution-sql Server Remote connection failed

When the computer room charging system is released offsite, it is necessary to ensure that the database can be connected remotely, but usually the error occurs when connecting:

To solve this problem, you first need to check several settings for SQL Server. (These settings are usually system defaults, but it's best to look at them)

(a) Check whether SQL Server allows remote links. logged in as SQL Server authentication mode. Login account SA

( two ) Open Configuration Manager and check Microsoft SQL Server ( MSSQLServer ) of the TCP/IP Protocol whether to open .

Make sure the above settings are correct and make the final SQL Server firewall settings (most of the problems are here)

One, can directly shut down the firewall, but this is not safe, not recommended.

    II, find Microsoft sql server ( Span lang= "ZH-CN" style= "Font-family:tahoma" >mssqlserver ) tcp /IP protocol sql Server firewall is already running, click " tcp/ip Protocol" SELECT Properties

< Span lang= "ZH-CN" style= "Font-family:simsun" >          

from which we can see that this sql support on server TCP/IP The protocol is 1433 port. The next step is to allow 1433 tcp/ip protocol. Open Control Panel, select windows Firewall"--Advanced settings. Right click "Inbound rule (

when the new rule option is turned on, use the new built-in station The Rule Wizard is 1433 the port Configuration "internal binding protocol" is configured to apply to TCP/IP protocol.

Configuration process:

after you complete the steps above ,theSQL Server can support remote links . Give it a try!

  ┏〓〓┓┏〓〓┓     ┏〓〓┓┏〓〓┓┏〓〓┓
  ┃ technology ┃┃ share ┃ ---┃ accumulate ┃┃ point ┃┃ drop ┃
  ┗〓〓┛┗〓〓┛    ┗〓〓┛┗〓〓┛┗〓〓┛