CODEWITHSUNDEEP
sql-serversql-server-2005
Name123
Name123

Reputation: 25

Change SQL SERVER 2005 from default instance to named instance?

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?

Upvotes: 1

Views: 2069

Answers (2)

Nitai Bezerra
Nitai Bezerra

Reputation: 448

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.

Upvotes: -1

boydc7
boydc7

Reputation: 4633

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

Upvotes: 4

Related Questions