[SQL] for "Unable to connect with TCP/IP protocol and remote SQL Server database" issue

server| Data | database | database connection | problem
For "Unable to connect with TCP/IP protocol and remote SQL Server database" issue


First, it is important to determine your version of SQL Server and what patches it has installed. If the patch is not installed or the latest servicepack is not installed, please install it first.

Then, you can try Telnet sqlservername 1433 to see if it can be connected. 1433 is the default port for SQL Server with the TCP/IP protocol. If you can't connect to this port, you should check the network configuration.

3rd, you get a description of the error is "[TCP/IP Sockets] General network Error", then if replaced by a named pipe connection, can you pass it?

4th, if your program uses a connection string to connect to the database, try the IP address of the database server and the Hostnetbios name.

Finally, what is the running identity of the program you used to perform connection to SQL Server on that exception server? Does this identity have access to remote resources? In addition, is your SQL Server machine running before or after your domain controller is started, can SQL Server successfully verify your identity? It is recommended that you restart your SQL Server to ensure that it is able to obtain domain account information from the domain controller. I used to have a SQL Server, because the power outage, which caused the domain controller not to start, but only the SQL Server machine startup, this time access to SQL Server, is extremely abnormal.