Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Default instance vs Named instances - best practice? Expand / Collapse
Author
Message
Posted Tuesday, July 1, 2008 3:06 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, February 8, 2010 1:39 PM
Points: 75, Visits: 199
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!
Post #526915
Posted Tuesday, July 1, 2008 3:39 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Monday, November 17, 2014 12:50 PM
Points: 13,872, Visits: 9,598
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
Post #526935
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse