Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to create default instance after creating a named instance?

when installing SQLServer2005 developer edition (not express) I created a named instance:

MYSERVERNAME/MYINSTANCENAME

Is it possible to

1) change the name of my named instance to default:

MYSERVERNAME

OR

2) create a new default instance (MYSERVERNAME as above).

any help would be appreciated!

like image 703
JohnIdol Avatar asked Nov 05 '08 13:11

JohnIdol


1 Answers

Hm, when I use the "Change" button in Add/Remove Programs, SQL Server 2005 setup offers me the instance selection screen, and even allows me to list the existing instances. (I'm running XP SP2, by the way.)

I selected the "To install a new component, click here" link in the setup program, then selected SQL Server Database Services on the "Components to Install" screen to arrive at the instance selection screen that allows me to install a new default instance.

like image 101
Alan Avatar answered Oct 13 '22 00:10

Alan