January 11, 2011 at 11:00 am
Hi All-
Last night below error occured and 31 jobs failed as MASH DB connection went down while run was attempting to initialize rungroup
RunGroupInitializer Log Snippet
Connecting to WPPROMASHSQL\MASH...
Exception of type 'System.Data.SqlClient.SqlException' was caught.
Message:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Stack trace:
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
I am able to connect MASH DB now.Does anyone have suggestions where to start from to isolate what happened last night resulting in below error. your suggestions are much appreciated
Thanks
Anita
January 11, 2011 at 11:15 am
Please check the SQL Server Error Log's and Event viewer's System Log enteries around that time to find the root cause of the issues.
This could be due to a unexpected server restart or shutdown or something like that.
Thank You,
Best Regards,
SQLBuddy
January 11, 2011 at 11:42 am
yes as indicated by sqlbuddy this may happen because abnormal restart of the system or the services are not running....make sure that the sql server instance is running...and if its a named instance the also make sure that the sql server browser is running....
hope this helps
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply