How do you specify a different port number in SQL Management Studio?
我尝试连接到不在端口1433上的Microsoft SQL 2005服务器。如何在使用SQL Management Studio连接到服务器时指示不同的端口号？
127.0.0.1,6283
在IP和端口之间添加逗号
If you're connecting to a named instance and UDP is not available when connecting to it then you may need to specify the protocol as well.
Example:
tcp:192.168.1.21SQL2K5,1443
Another way is to setup an alias in Config Manager. Then simply type that alias name when you want to connect. This makes it much easier and is more prefereable when you have to manage several servers/instances and/or servers on multiple ports and/or multiple protocols. Give them friendly names and it becomes much easier to remember them.
链接地址: http://www.djcxy.com/p/25974.html