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.
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 India. "The IMPOSSIBLE is often UNTRIED"
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.
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?
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.
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.
Installing 2k5
Forum Locked
Posted - 12/23/2006 : 07:48:40
