Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Old Forums
 CLOSED - SQL Server 2005/Yukon
 Installing 2k5

Author  Topic 

Yak Posting Veteran

73 Posts

Posted - 2006-12-23 : 07:48:40
I have already SQL2k installed on my machine then I installed SQL2k5 on the same machine but it seems I have got only Management Stadio. None of 2k5 functionalities works and new syntaxes fails. What's wrong with? Had i miss anything during installation process.

Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-12-23 : 12:39:30
If you already installed SQL 2000 and you also want to install SQL 2005, you need to create SQL 2005 as named instance. Have you done that? Also which edition of SQL 2005 you are installing?

Harsh Athalye
Go to Top of Page

Master Smack Fu Yak Hacker

2886 Posts

Posted - 2006-12-23 : 21:04:01
if all you installed was SSMS, that's only the client tools (replacements for EM/QA/etc). You need to install the relational server to get the 2k5 features. and as harsh says, if your 2k instance is the default instance, you'll have to make the 2k5 instance a named instance.
Go to Top of Page

Yak Posting Veteran

73 Posts

Posted - 2006-12-25 : 04:35:46
I installed Enterprise Edition. It asked me if you want to install as default or name istance. I thought like SQL2k for the first installation I can install it as default. Is it wrong?
Go to Top of Page

Master Smack Fu Yak Hacker

1907 Posts

Posted - 2006-12-25 : 04:39:08
Yes, i guess its worng, if you are installing 2 servers on the same machine then you have give the second server as named instance... so that SQL SErver can rectify by the instance name and then connect to it.

Go to Top of Page

Posting Yak Master

130 Posts

Posted - 2006-12-26 : 23:55:25
you can't have two default instances of any version of SQL Server but you can have ten different installations of 2000 and 2005 as long as they are all named differently, they can co-exist happily.

its me monty
Go to Top of Page

- Advertisement -