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, ho开发者_如何学Pythonw?

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

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.