I am runing WSS3 in 2 frontend web server. They both runas a virtual machine. One of the server that with Search service enable always throw following SQL error in eventlog. It happen around every 2 to 3 hours. During it happen the VM is hang and seem the network connection is drop. Event Type:ErrorEvent Source:Windows SharePoint Services 3Event Category:Database Event ID:5586Date:7/17/2007Time:4:38:00 PMUser:N/AComputer:xxxxDescription: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.) For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.Event Type:ErrorEvent Source:Windows SharePoint Services 3Event Category:Timer Event ID:6398Date:7/17/2007Time:4:37:45 PMUser:N/AComputer:xxxxDescription:The Execute method of job definition Microsoft.SharePoint.Administration.SPConfigurationRefreshJobDefinition (ID ca1b8015-9b13-457c-91ef-7ca9ea90d269) threw an exception. More information is included below. A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.) For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.Event Type:ErrorEvent Source:Windows SharePoint Services 3Event Category:Database Event ID:5586Date:7/17/2007Time:4:37:45 PMUser:N/AComputer:xxxxDescription:Unknown SQL Exception 64 occured. Additional error information from SQL Server is included below. A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.) For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.Any idea?Thanks.

any one got the same problem??

This sounds like exactly what it states. Somehow your network is being dropped in the middle of your operations. Verify your network connectivity (possibly it's a bad network card, or switch...possibly its a bad cable).

I am gettingthe followingSQL error, with the same event ID as above, whenever'Profile Synchronization' and 'Quick Profile Synchronization' timer job definitions were enabled or disabled. EVENT LOG Application EVENT TYPE Error SOURCE Windows SharePoint Services 3 CATEGORY Database EVENT ID 5586 COMPUTERNAME MOSS2007 TIME 8/21/2007 5:41:10 PM MESSAGE Unknown SQL Exception 18452 occured. Additional error information from SQL Server is included below.Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection Any idea what could be causing this error?! Relevant thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2036607&SiteID=1

I am getting another error, but the root of the error seems to me the same. Event Type:ErrorEvent Source:Windows SharePoint Services 3Event Category:General Event ID:27745Date:8/24/2007Time:3:08:26 AMUser:N/AComputer:serverDescription:The description for Event ID ( 27745 ) in Source ( Windows SharePoint Services 3 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: #50071: Unable to connect to the database DATABASE_Config on SQLSERVER. Check the database connection information and make sure that the database server is running.. Event Type:ErrorEvent Source:Office SharePoint ServerEvent Category:Office Server General Event ID:7888Date:8/24/2007Time:3:08:42 AMUser:N/AComputer:PS-SPS3-SRVDescription:A runtime exception was detected. Details follow. Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Techinal Details:System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32 bytesExpected) at System.Data.SqlClient.TdsParserStateObject.ReadBuffer() at System.Data.SqlClient.TdsParserStateObject.ReadByte() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.Office.Server.Data.SqlSession.ExecuteNonQuery(SqlCommand command) at Microsoft.Office.Server.UserProfiles.WSSSynchSqlSession.SynchExecuteNonQuery(SqlCommand cmd, Boolean throwOnFail) at Microsoft.Office.Server.UserProfiles.WSSSynchSqlSession.SynchExecuteNonQuery(SqlCommand cmd) at Microsoft.Office.Server.UserProfiles.WSSSynchSqlSession.ExecuteBasicSynchNonQueryProc(EStoredProcs proc, SPContentDatabase cdb, SPSite site, SPWeb web, SPGroup group, SPUser user, SPChangeToken chtok, Object[] rgWeakTypedParams) at Microsoft.Office.Server.UserProfiles.WSSSweepSynch.WriteNextStartSweepToken(SPChangeToken tokLast) at Microsoft.Office.Server.UserProfiles.WSSSweepSynch.DoSweepSynch() at Microsoft.Office.Server.Diagnostics.FirstChanceHandler.ExceptionFilter(Boolean fRethrowException, TryBlock tryBlock, FilterBlock filter, CatchBlock catchBlock, FinallyBlock finallyBlock) For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. I've analysed the trace log and found that time out were then Quick Profile Synchronization Job runs the stored procedure profilesynch_sweep_GetDBToken.There is another procedure profilesynch_sweep_UpdateDBToken andseems that it locks table SweepSynchfor all following select. That's why the time out expired error occurs. Looking forward for SP1... Pavel.

My problem is the CD-ROM device in the host machine misfunctioning ( i am using VM to host the WSS3). After disable cd-rom in the VM, it work fine now.

Thanks, Jason. I'll try. But the same error Im getting on product server without VM. Anotherwaytofix thiserror "uncompressed all the compressed files in the 12 structure. " http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:239450 Looks like SharePoint trying to unzip some dll's from CDafter installation. Or... see my previous post... Pavel.

Event Type:ErrorEvent Source:Windows SharePoint Services 3Event Category:Database Event ID:5586Date:7/17/2007Time:4:38:00 PMUser:N/AComputer:xxxxDescription:Unknown SQL Exception 10054 occured. Additional error information from SQL Server is included below. I am writing in regards to the above message. I am receiving this in my event viewer once every few days and am not sure why. We are running WSS 3.0 but SQL is running on a separate server. Since I personally did not setup WSS I'm not sure if there is a connection issue between the two or if it was setup incorrectly. Could you please supply some troubleshooting tips? Thanks, Laura

In general, these errors are indication that the WSS web front end is unable to communicate with the SQL Server backend. Make sure all your credentials are up to date. Sometimes the farm account is a domain account who's password has expired or changed. To set curent credentials, see this post: http://blogs.msdn.com/joelo/archive/2006/08/22/712945.aspx

We had numerous 5586, 7888 and occassional 27745 errors (the 27745 errorscaused intermittent outages). We finally tracked it down to sql aliases wesetup for our nonstandard sql port back when we were running SP2003. It appears that MOSS does not like the sql alias.On all of our WFEs, we ran c:\WINDOWS\system32\cliconfg.exe and removed the Alias entries. Hope this helps someone solve their errors...

My problem is the CD-ROM device in the host machine misfunctioning ( i am using VM to host the WSS3). After disable cd-rom in the VM, it work fine now. Same configuration (2 VMs) and same resolution. Deleting the cd-roms from the VMs all work fine. Thank you

My problem is the CD-ROM device in the host machine misfunctioning ( i am using VM to host the WSS3). After disable cd-rom in the VM, it work fine now. Same configuration (2 VMs) and same resolution.Deleting the cd-roms from the VMs all work fine.Thank you How did you even come to find out that the cd-rom was the culprit? Was it in the event log?I am having the same issue by the way.

Using a sql alias with w2k8 R2 SP2, MOSS 2007 and sql 2008, when trying to start the windows sharepoint server search service, I got event id's 5586, 7034 and 3899 all in a row. Adding an entry to the hosts file of each server in the farm that pointed the sql alias name at the sql instance ip address resolved the issue for me. After adding the host entry, I am able to start the wss search service without error. I think it would be preferable to set it up in dns instead of having to manage hosts files, but have not yet confirmed whether or not that actually works yet.

I am also facing the same issue sometimes while browsing the site and getting the below error message. Value cannot be null. Parameter name: value at System.String.EndsWith(String value, StringComparison comparisonType) at Microsoft.SharePoint.ApplicationRuntime.SPRequestModule.PostAuthenticateRequestHandler(Object oSender, EventArgs ea) at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) I am using SQL alias to connect with SQL server. Any solution against this issue will be appretiated.

Nannu Ann - Do you get the error even with the entry to the hosts file on each server in the farm that points the sql alias name at the sql instance ip address?

I have the host entry done for all farm servers and still getting the error. We have 2 URLs for accessing the site with the same content database. One is for internal access and other is for external access. We are successful accessing the internal URL even the external URL is throwing the error message.