Solution-SQL Server Remote connection failure, SQL Server

Solution-SQL Server Remote connection failure, SQL Server

When the charging system of the IDC is released remotely, you must ensure that the database can be remotely connected. However, an error is usually reported during connection:

 

To solve this problem, you must first check the settings of SqlServer. (These settings are generally system default items, but you 'd better take a look)

(1) Check whether SQL Server allows remote connection. Log in as SqlServer identity authentication. Logon account sa

 

 

(2) Open the Configuration Manager and check whether the TCP/IP protocol of Microsoft SQL Server is enabled.

 

Make sure that the preceding settings are correct and then configure the SQL Server firewall. (most of the problems are found here)

 

1. Firewall can be directly disabled, but this is not secure and is not recommended.

2. Find the TCP/IP protocol of Microsoft SQL Server. When the SQL Server firewall is running, click "TCP/IP protocol" and select Properties.

We can see that port 1433 supports the TCP/IP protocol on this SQL Server. The next step is to allow port 1433 to support the TCP/IP protocol in the firewall configuration. Open Control Panel and choose Windows Firewall> advanced settings ". Right-click the Inboud Rules option and select NewRule )":

Open the "new rule" option and use the "new inbound rule wizard" to configure "Internal binding protocol" for port 1433 to apply to the TCP/IP protocol.

Configuration process:

After completing the preceding steps, the SQL Server supports remote connections. Try it!

┏ 〓 ┓ 〓
Technical tips-Tips
┗ 〓 ┛ 〓

By default, SQL Server does not allow remote connection.

I just solved it today

Start> All Programs> sql2005> Configuration tool> SQL Server peripheral application configurator> Server and connected peripheral application configurator> remote connection select TCP/IP

Restart your computer... try again

--------------------------------------------------------------------

Of course, it is not feasible to install two such statements ..

You need to specify the Instance name to connect.

You change

Server = windows \ 2005; database = name; Integrated security = True;

So there will be no problems ..

Remote connection to SQL Server database failed

Remote connection, right!
You are looking for two places
I. Check whether the configuration in your client network utility is the same as that in the remote server: port number, IP address, server name, and Protocol pipeline.
Ii. Take a closer look at the TCP/IP protocol configuration for local connection of your network neighbor: IP address and default gateway (very important. If an error occurs in this area, you will never be able to connect to it. Please take a closer look ), whether the DNS server configuration is correct.