July 1, 2008 at 3:06 pm
Hi,
I am looking at combining 3 physical SQL servers onto 1 physical box with 3 instances. Is there harm in not installing one of these "servers" as the default instance? I've installed the three instances and am not using a default instance at all. Does anyone know of any issues with this kind of set up? Thanks so much!
July 1, 2008 at 3:39 pm
The one problem I've had with something like that was when a lower-license version of SQL Server was installed on a machine with higher-license instances.
Specifically, it had an instance of Standard Edition, and an instance of Dev Edition, and they were working, but then a default instance was installed of Workgroup Edition. Workgroup Edition doesn't support SSIS, so suddenly all the SSIS packages on the server that did anything other than SQL data manipulation or backups, ceased working. The only way to get them to start working was to uninstall and then install a version that did have SSIS in it. It was very strange, and MS support wasn't sure why it did that, but it most certainly did.
Watch out for that kind of weirdness, and you should be fine.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply