SQL data base error

1

Hi

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

20161214-yven-34kb.png1366×768 27.7 KB

2

Looking like u have given wrong instance name...

3

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

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

4

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).

5

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

Or

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

Or

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