SQLTeam.com | Weblogs | Forums

SQL data base error


when i'm open my sql server then i'm getting this error....on my server

Looking like u have given wrong instance name...

yes my sql agent service is off so i can't access my instance.

thanks for revert me back.......:):slight_smile:

SQL Agent being down wouldn't prevent you from connecting. Either the instance is down, the instance name is wrong, you have a networking issue or you the name of the server isn't being resolved to the IP of the SQL Server (I know, also a networking issue).

To fix the error message

  • Go to control panel.
  • search for services.
  • Open Local services window from your search results
  • Restart your MSSQLSERVER service.

Then try to connect


In SQL Server Configuration manager enable TCP/IP, VIA and Named Pipes


Take a look at this link http://www.sqlserverlogexplorer.com/fix-error-message-40/