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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 2k Instance

Author  Topic 

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2003-01-02 : 10:54:21
Is it possible to 'name' a default 2K instance.

I have a server with SQL 2k installed as the default instance. I need to run 7 and 2k on this box for some testing, so I assume I need to name the 2k instance so I can install a 7 default instance.

Advice?

Jay White
{0}

efelito
Constraint Violating Yak Guru

478 Posts

Posted - 2003-01-02 : 11:40:13
I'm pretty positive that there's no way to name or rename an instance. You'll probably have to install a named instance, move your databases, uninstall the default instance, and then install SQL 7.

Jeff Banschbach
Consultant, MCDBA
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-01-02 : 12:54:34
Don't you have to start with 7.0 first and then install 2k?

Go to Top of Page

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2003-01-02 : 14:47:55
Yeah, that's what I ended up doing ....

Jay White
{0}
Go to Top of Page

Wanderer
Master Smack Fu Yak Hacker

1168 Posts

Posted - 2003-01-03 : 03:36:46
From what I can see, the only way to name the default 2K instance is to do so during installation - no renaming seems possible. I'm fairly certain we did this somewhere (about a year or 2 ago)...

*#&#* *#&#* *#&#* *#&#*

Chaos, Disorder and Panic ... my work is done here!
Go to Top of Page
   

- Advertisement -