I have installed SQL Server 2005 and now have instance name as the default one:
我已经安装了SQL Server 2005,现在将实例名称作为默认名称:
SERVERNAME
I'd like to change to:
我想改为:
SERVERNAME\MyDB
Is this possible? If yes, how?
这可能吗?如果有,怎么样?
2 个解决方案
#1
4
No, unfortunately it isn't possible to do this without a complete uninstall/reinstall of basically a new instance of Sql Server.
不,遗憾的是,如果没有完全卸载/重新安装基本上是Sql Server的新实例,就无法做到这一点。
#2
-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.
您可以使用SQL Server配置管理器SQL Server 2005及更高版本中的配置工具之一来执行此操作。
#1
4
No, unfortunately it isn't possible to do this without a complete uninstall/reinstall of basically a new instance of Sql Server.
不,遗憾的是,如果没有完全卸载/重新安装基本上是Sql Server的新实例,就无法做到这一点。
#2
-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.
您可以使用SQL Server配置管理器SQL Server 2005及更高版本中的配置工具之一来执行此操作。