How to find sql server instance?

Posted on

QUESTION :

I have sql server 2000 and 2005 installed on my machine.

Now instances were installed as Machine04 [2000] and other Machine04SomeInstance [2005] (this some instance i don’t remember now) So is there any way i can find available instances.

Because of this now i am only able to connect to sql 2000 only and other way is to reinstall 2005 which is really not good.

ANSWER :

Look in Services.msc, it will be listed there as “SQL Server (Instance Name)”

Leave a Reply

Your email address will not be published. Required fields are marked *