sql 2000 & sql 2005 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

sql 2000 & sql 2005

Is it possible to have sql 2000 and sql 2005 installed on the same machine. I noticed that I installed sql 2005 on a box that has sql 2000 already installed , and now I can only see the sql 2000 via Management Studio.
Is there a way around this? ___________________________________
Advertise your IT vacancies for free at –http://www.ITjobfeed.com
You can’t see 2000 using EM or QA?
Luis Martin
Moderator
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided “AS IS” with no warranties for accuracy.
I can see 2000 through EM , but when I log onto sql 2005 management studio all I can see is MYMACHINE as the server name , which then if I try and run a sql 2005 query such as SELECT * FROM sys.dm_os_wait_stats , it’s saying invalid object name , which leads me to think that I can’t see the 2005v db engine ___________________________________
Advertise your IT vacancies for free at –http://www.ITjobfeed.com
Try this: Run Management Studio with MYMACHINE server name.
Try open a new connection with 2005 name. Usually you have to see something like MYMACHINE/SQL2005. Luis Martin
Moderator
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided “AS IS” with no warranties for accuracy.
Interestingly , I can log onto Integration Services , it seems that by default it tries to attach the sql 2000 engine as opposed to the sql 2005 , I think I’ll just delete the sql 2000 , unless you know of a way to reassign db engines ___________________________________
Advertise your IT vacancies for free at –http://www.ITjobfeed.com
I have 2 sql 2000 instances and 1 sql 2005 instance in one server. I can reach any of them using Management Studio without problem. What are the instances name for both sqls?
Luis Martin
Moderator
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided “AS IS” with no warranties for accuracy.
I will look into this ,this is the problem, thanks for you help.
___________________________________
Advertise your IT vacancies for free at –http://www.ITjobfeed.com
Try to use PORT NUMBER along with instance to connect…and also try to connect using Query Analyzer… EX: SVR1INS1,PORTNUMBER MohammedU.
Moderator
SQL-Server-Performance.com
Thanks, that sorted the problem ___________________________________
Advertise your IT vacancies for free at –http://www.ITjobfeed.com
]]>