How to find sql server instance?

Posted on


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.


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 *