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 |
|
nic
Posting Yak Master
209 Posts |
 Posted - 2006-08-23 : 18:55:59
|
| Hi,Is there any good way to switch default instances? Our current default instance is running sql2000 and we have a named instance running sql2005. We are looking to install MS Team Foundation Server which is the replacement of Visual Source Safe (appears to be a much better product). Unfortunately, the default instance needs to be sql2005. Is there anyway to switch around instances? I'd really like to keep the sql2000 instance but it can't be the default.Any help would be appreciated.Nic |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-23 : 19:07:57
|
| There is no way to do this easily. You must do an uninstall/reinstall plus restores.Tara Kizer |
 |
|
|
nic
Posting Yak Master
209 Posts |
Posted - 2006-08-23 : 19:51:21
|
| bummer, thanks for the reply. I think we might just use a different server.Nic |
|
|
|
|
|
|
changing default instances