Error in updating my SQL server 2005

Asked By Roy Macatimpag 0 points N/A Posted on - 10/05/2011

I encountered, this message when I updated MySQL Server 2005. I heard that it is better to update my table so I did it. After connecting to the SQL server 2005 instance via a DAC (dedicated administrator connections) this error appears. Any suggestions?

Microsoft SQL Server Management Studio

A connection was successfully established with the server, but then an error occurred during the login process. (Provider: TCP Provider, error: 0-An existing connection was forcibly closed by the remote host.) (Microsoft SQL Server , Error: 10054)

• Status: Open
• Question Views: 1475
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MySQL Server

Best Answer by bernard dross

Go To Solution

Best Answer

Best Answer

Answered By bernard dross 5 points N/A #86572

Error in updating my SQL server 2005

Hi,

This error normally occurs because of some certificate errors. Follow the given steps to get rid of this error:

Go to the command prompt and run this command : Certutil -store -v my –CertificateSerialNumber

Now in the result try to find a following. CERT_KEY_PROV_INFO_PROP_ID

Here you can find an option labeled as Keyspec.

Check what value is assigned to it. For accurate work, its value should be one, so change it to one and restart your computer.

Now you will not see this error again. Hope this issue is solved and you will not face this error again.

About bernard dross

Questions
0

Answers
36

Best Answers
14

• Vote Up 0 Vote Down

• Posted on - 10/05/2011
• Question Category: MySQL Server

Answered By Peteranderson 0 points N/A #86573

Error in updating my SQL server 2005

Hey Roy,

The problem seems to be with SQL registry. As you have updated the SQL server the registry key has not picked up the certificate.

Go to Start -> Run type “regedit” expand HKEY_LOCAL_MACHINE then SOFTWARE expand wow6432node click Microsoft and Microsoft SQL ServerMSSQL.xMSSQLServer click SuperSocketNetLib. In the right pane, open 'Certificate' ; remove the entries and keep it blank. Restart the SQL server and it will start successfully.

Start SQL server Agent now. You will be able to connect successfully.

About Peteranderson

Questions
0

Answers
50

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 10/06/2011
• Question Category: MySQL Server