SQL Server specify correct named instance

In SQL Server 2008 how do I  make sure that I am specifying correct instance name and that instance name actually exists on target server and is running.

Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
 
dbaSQLConnect With a Mentor Commented:
In SSMS, you can double click your server to open the Object Explorer, then right click and select Propties, General Tab.  Here you will see the sql server instance name.

You can also do this with a query by executing the following:

SELECT @@SEVERNAME
0
 
kamindaConnect With a Mentor Commented:
If this from your Application's perspective, you will get an error describing the situation of your server instance name, you can catch that. Also there are plenty of scripts on the web to get all the SQL instances available in your network,

This link will help you to do tihs
http://social.msdn.microsoft.com/forums/en-US/adodotnetdataproviders/thread/fda283ef-5a8b-424d-b549-074ccc19c8d7
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
thanks for the help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.