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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Changing the default instance name

Author  Topic 

ssomanat
Starting Member

1 Post

Posted - 2009-07-13 : 05:51:41
Hi Experts,

I would like to change the default instance of my SQL server 2008 to a named instance ( I would like to specify a name of my choice) . Is that possible ?

Many thanks for all the help ..


RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2009-07-13 : 06:23:17
Yes, you can change this on Setup.
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-07-13 : 06:43:37
If the default instance is created already, see this
http://www.eggheadcafe.com/community/aspnet/13/10030422/can-we-change-default-ins.aspx



N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page

shah429
Yak Posting Veteran

52 Posts

Posted - 2009-08-05 : 18:30:54
You can't change the default instance to a named instance...
Go to Top of Page
   

- Advertisement -