I have installed SQL 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?
+2
A:
No, unfortunately it isn't possible to do this without a complete uninstall/reinstall of basically a new instance of Sql Server.
chadhoc
2009-11-21 13:43:20
That's bad. Thanks!
Name123
2009-11-21 13:52:41
A:
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.
Nitai Bezerra
2009-11-21 16:45:25
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.
chadhoc
2009-11-22 14:26:04