up vote 0 down vote favorite
share [g+] share [fb]

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.

link|improve this question
25% accept rate
feedback

1 Answer

up vote 0 down vote accepted

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

link|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
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.