SharePoint and SQLError 10054


Today I was trying to create a Shared Service Provider on a MOSS 2007 Farm inclusive new Web Applications für the SSP Admin site and the MySite. I run in this error while creating the SSP:

(from the SharePoint Log)

SqlError: ‘A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 – An existing connection was forcibly closed by the remote host.)’    Source: ‘.Net SqlClient Data Provider’ Number: 10054 State: 0 Class: 20 Procedure: ” LineNumber: 0 Server: ‘CCMCSSRV021’    
06/07/2010 09:49:25.19     w3wp.exe (0x0A8C)                           0x0E04    Windows SharePoint Services       Database                          5586    Critical    Unknown SQL Exception 10054 occured. Additional error information from SQL Server is included below.  A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 – An existing connection was forcibly closed by the remote host.)

There was obviously no problem with the SQL Server and the connection to it so I gave Google a try.

I found a hint here:

http://social.technet.microsoft.com/Forums/en/sharepointadmin/thread/1bb474b4-87d1-44b9-97c4-d018d9b35b75

And it worked: Disconnect cd-rom drives from your VMWare Client and all wents fine. I don’t know the relation and I am still wondering why this works.. but it did for me.

Advertisements

About binoeder

SharePoint and Project Server Consultant
This entry was posted in SharePoint and tagged , , . Bookmark the permalink.

2 Responses to SharePoint and SQLError 10054

  1. Thanks for the useful post. “Disconnect cd-rom drives” – do you mean REMOVE the devices or only disconnect?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s