Unable to connect to server '(local)'; SQLServerAgent cannot start
[Action]
Trying to connect to the SQL server using SQL server management studio.
SQL server 2005 9.00.4035 32 bit
Windows Server 2003 Standard Edition 64bit
[Result]
The SQL server connection fails with the below error.
A connection was successfully established with the server, but then an error
occurred during the pre-login handshake. (provider: TCP Provider, error: 0 -
An existing connection was forcibly closed by the remote host.) (Microsoft
SQL Server, Error: 10054)
We are trying to connect to the SQL Server 2005 using the IP address and
the port number.
Checked the protocols. All the protocols are fine and SQL server is
listening on the specified protocols.
Checked if Force Encryption is on. It is off.
We could see 4 certificates listed in the Configuration manager.
Performed the UDL test. Obtained the error that SSL configuration failed.
Obtained the thumbprints of all the certificates.
Opened mmc.exe, added the certificates snap in for computer account and
local computer store.
Deleted the four certificates in the personal store.
Now when we tried to restart the SQL server. It failed with the below
errors in the error log.
Error: 26014, Severity: 16, State: 1.
Unable to load user-specified certificate. The server will not accept a
connection. You should verify that the certificate is correctly installed.
See "Configuring Certificate for Use by SSL" in Books Online.
Error: 17182, Severity: 16, State: 1.
Worked
After deleting certificates in personal stores. I am able to login to sql server.
Trying to connect to the SQL server using SQL server management studio.
SQL server 2005 9.00.4035 32 bit
Windows Server 2003 Standard Edition 64bit
[Result]
The SQL server connection fails with the below error.
A connection was successfully established with the server, but then an error
occurred during the pre-login handshake. (provider: TCP Provider, error: 0 -
An existing connection was forcibly closed by the remote host.) (Microsoft
SQL Server, Error: 10054)
[Event Viewer]
SQLServerAgent could not be started (reason: Unable to connect to server '(local)'; SQLServerAgent
[Resolution]
We are trying to connect to the SQL Server 2005 using the IP address and
the port number.
Checked the protocols. All the protocols are fine and SQL server is
listening on the specified protocols.
Checked if Force Encryption is on. It is off.
We could see 4 certificates listed in the Configuration manager.
Performed the UDL test. Obtained the error that SSL configuration failed.
Obtained the thumbprints of all the certificates.
Opened mmc.exe, added the certificates snap in for computer account and
local computer store.
Deleted the four certificates in the personal store.
Now when we tried to restart the SQL server. It failed with the below
errors in the error log.
Error: 26014, Severity: 16, State: 1.
Unable to load user-specified certificate. The server will not accept a
connection. You should verify that the certificate is correctly installed.
See "Configuring Certificate for Use by SSL" in Books Online.
Error: 17182, Severity: 16, State: 1.
Worked
After deleting certificates in personal stores. I am able to login to sql server.
