英文:
Convert instance name in SQL Server 2022
问题
有没有办法将localhost\SQLEXPRESS转换为localhost？
英文:
I use a VM with a fresh installed SQL Server 2022 Express. Also installed latest SSMS 19.
Normally I can refer to local databases as localhost. But it is not available.
The only way to access local databases is through localhost\SQLEXPRESS.
This don't work as I am member in a team and we share same config-files in github for our local databases.
Is there a way to convert from localhost\SQLEXPRESS to localhost ?
答案1
得分: 1
如果您具有管理员特权，请打开SQL Server配置管理器，然后：
SQL Server网络配置 >
SQLEXPRESS的协议 >
右键单击TCP/IP，并确保在IP地址选项卡中，向下滚动至IPAll，并确保TCP端口为空。空端口表示默认端口（1433）> 重新启动SQL Server后，您可以连接到localhost而不是localhost\SQLEXPRESS。
英文:
If you have administrative privilege open the SQL Server Configuration Manager then:
SQL Server Network Configuration >
Protocols for SQLEXPRESS >
Right click o TCP/IP and make sure in IP Addresses tab , scroll down to IPAll and make sure the TCP port is empty. Empty port means default port (1433)> After restarting sql server, you can connect to localhost instead of localhost\SQLEXPRES
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论