Change SQL SERVER 2005 from default instance to named instance?

Question

I have installed SQL Server 2005 and now have instance name as the default one:

SERVERNAME

I'd like to change to:

SERVERNAME\MyDB

Is this possible? If yes, how?

i think its possible .. have a look on my answer

anishMarokey
– anishMarokey

2009-11-21 13:55:50 +00:00
Commented Nov 21, 2009 at 13:55 — anishMarokey
– anishMarokey, Commented Nov 21, 2009 at 13:55

boydc7 · Accepted Answer · 2009-11-21 13:43:20Z

4

No, unfortunately it isn't possible to do this without a complete uninstall/reinstall of basically a new instance of Sql Server.

answered Nov 21, 2009 at 13:43

boydc7

4,64323 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Nitai Bezerra · Accepted Answer · 2009-11-21 16:45:25Z

-1

It depends on the problem you can set an alias for the default instance, is like a nickname for instance, so any customer can see your named instance as you wish.

You can do this using the SQL Server Configuration Manager one of the Configuration Tools from SQL Server 2005 and above.

answered Nov 21, 2009 at 16:45

Nitai Bezerra

4581 gold badge5 silver badges16 bronze badges

1 Comment

boydc7 Over a year ago

You would have to set the alias on every single machine that ever wanted to query your instance - aliases are a feature supported by the Sql Client libraries, they don't apply to the server in the sense that you set an alias once on the server and forget it.

Collectives™ on Stack Overflow

Change SQL SERVER 2005 from default instance to named instance?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related