Named or Default Instance

• miranda1866

  SSC-Addicted

  Points: 414

  More actions

  October 7, 2011 at 4:15 am

  #260123

  Hi good people,

  I am a new baby in SQL server but i love it am enjoying it every day now am expected to install SQL Server 2005 and SQL Server 2008 on a new machine so am a bit confused if i should go for a default instance or named instance

  Can anyone please advise.

  Thanks and Regards

  Miranda.

• vultar

  Hall of Fame

  Points: 3271

  More actions

  October 7, 2011 at 5:16 am

  #1391633

  Hi Miranda,

  Good to hear your enjoying your SQL server experience

  You can have 1 default instance, but multiple named instances on a single machine and you should install the oldest version 1st which gives you a couple of options;

  1. Install 1 2k5 default instance & 1 2k8 named instance

  2. Install 1 2k5 named instance & 1 2k8 named instance

  It's also worth thinking about setting the min & max memory settings to ensure 1 instance doesn't take all the memory.

  Cheers

  Vultar

• shivendrakumaryadav60

  SSC Eights!

  Points: 811

  More actions

  October 7, 2011 at 7:22 am

  #1391698

  I am agreed with @vultar.

  for more details follow this link

  http://msdn.microsoft.com/en-us/library/aa174516%28v=sql.80%29.aspx