Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

Now instances were installed as Machine04 [2000] and other Machine04\SomeInstance [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.

share|improve this question
up vote 2 down vote accepted

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

share|improve this answer
    
Can we change the name of sql server instance which is installed? – Anil Namde Feb 19 '10 at 14:43
    
Yes, you can. See here: sqlserver-qa.net/blogs/tools/archive/2007/12/14/… – BBlake Feb 19 '10 at 15:41

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .