SQLTeam.com | Weblogs | Forums

SQL data base error

sql2014

#1

Hi

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


#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/