SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Default instance vs Named instances - best practice?


Default instance vs Named instances - best practice?

Author
Message
SO-462683
SO-462683
SSC-Enthusiastic
SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)

Group: General Forum Members
Points: 149 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!
GSquared
GSquared
SSC Guru
SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)

Group: General Forum Members
Points: 58183 Visits: 9730
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search