Post reply

Unable to connect DB

  • January 11, 2011 at 11:00 am

    #388603

    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

    #1271998

    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

    #1272013

    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