Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
daidaluus
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. |
|
harsh_athalye
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 AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
jezemine
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. www.elsasoft.org |
|
|
daidaluus
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? |
|
|
chiragkhabaria
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. Chiraghttp://chirikworld.blogspot.com/ |
|
|
monty
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 |
|
|
|
|
|