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 |
|
jpotucek
Constraint Violating Yak Guru
273 Posts |
 Posted - 2006-08-24 : 12:02:29
|
| I have SQL Server 2000 Standard Edition (sp3a) running on a windows 2003 (sp4) Server.It is a Production Server with 3 NAMED Instances and NO Default Instance.Does anyone know if I can rerun the SQL Server Install and add a DEFAULT Instance to this box without disrupting the other Named Instances??? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-24 : 13:59:42
|
| Yes you can. It sometimes needs a reboot though.Tara Kizer |
 |
|
|
jpotucek
Constraint Violating Yak Guru
273 Posts |
Posted - 2006-08-28 : 07:38:08
|
| Thanks Tara! Actually what I am trying to do is Change one of my Named Instances to be the Default Instance !!! AFTER installing a Named Instance for CRM and Reporting Services, found out that CRM CANNOT be a Named Instance.. or at least that's what my Application Guy says.. So.. sounds like I have to uninstall my Named CRM instance and reinstall as the Default Instance??? or is there an easier way ?????? :) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-28 : 13:09:05
|
| There is no easier way, unfortuneately. I can't imagine any application requires an instance to be the default. Can't you just fake it with an alias on the client?Tara Kizer |
|
|
|
|
|
|
Installing a Default SQL Server 2000 Instance