Solution: On the server side: Open SQL2005 SQL Server Management Studio program
(1) to connect to the database,
(2) trying to choose the registered under the menu Server
if there are no things out of the window, to update the local Server database engine right click on the select register
(3) on the local hope remote access database, right click on the select SQL Server configuration manager
(4) in the window, Select SQL Server 2005 network configuration in the left tree, select the appropriate database in the sub-set,
(5) and right click on TCP/IP in the right protocol to enable it
I followed this method to do first, and then found that it was still unable to connect to the server, finally use the following method to solve: start — “program –” Microsoft SQL Server 2005–& GT; SQL Server 2005 Peripheral Application Configurator select “Peripheral Application Configurator for Services and Connections” in this SQL server instance select Database Engine -& GT; For remote connections, select both TCP/IP and Named Pipes in the box on the right for local and remote connections
(1) to connect to the database,
(2) trying to choose the registered under the menu Server
if there are no things out of the window, to update the local Server database engine right click on the select register
(3) on the local hope remote access database, right click on the select SQL Server configuration manager
(4) in the window, Select SQL Server 2005 network configuration in the left tree, select the appropriate database in the sub-set,
(5) and right click on TCP/IP in the right protocol to enable it
I followed this method to do first, and then found that it was still unable to connect to the server, finally use the following method to solve: start — “program –” Microsoft SQL Server 2005–& GT; SQL Server 2005 Peripheral Application Configurator select “Peripheral Application Configurator for Services and Connections” in this SQL server instance select Database Engine -& GT; For remote connections, select both TCP/IP and Named Pipes in the box on the right for local and remote connections
Read More:
- SQL server remote computer refused network connection, error: 1225, specific solution steps.
- Navicat remote connection SQL Server 2014 express report 08001 error
- Provider: SQL network interfaces, error: 25 http://www.itsvse.com/thre
- java.sql.SQLException: The Network Adapter could not establish the connection
- The solution of PL / SQL can’t connect to the remote server after installing Oracle locally
- Java connection SQL error, network error IO Exception:Connection refused :connect
- Vscode remote connection server reports an error: could not establish connection to “XXXXXX” [resolved]
- JDBC connect to Sql Server to connect to the database–The TCP/IP connection to the host localhost, port 1433 has failed
- Microsoft OLE DB Provider for SQL Server error & #x27;80040e4d & #x27;
- Java 11.0.11 SQL Server connection error
- SQL Server 2008 18456 error and SA unable to login solution
- Remote sshd prompt: server unexpectedly closed network connection
- SQL Server Error:233 and Error 18452
- SAP SQL error “SQL code: -10692“ occurred while accessing table “ZTXXXX“.
- SQL Server 2005, unable to log in, forget sa password, 15405 error!
- Solution to SQL Server Error: 4064
- install sql server 2016 Error code 0x84B20001
- Version problem of SQL Server
- Reporting Services Catalog Database File Existence” error during installing SQL Server 2008 R2
- Spring data JAP SQL error:17059 SQL State:99999