Hi
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.......:)
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
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/