I have configured an instance to use static port, say 1435, and I turned off the Browser service.
I would like to know if I can use SSMSE to connect to the instance database directly. The instance is listening at port 1435 and accepting connection requests from other methods.
What I need to put into the "Server name: " field?
Normally, it would be like: <serverIP>\<InstanceID> with Browser turned on.
Now how do I add the port information to it, I tried
<serverIP>:<portNumber>\<InstanceID>
<serverIP>\<InstanceID>:<portNumber>
<serverIP>\<InstanceID> <portNumber>
None of them worked.
Any suggestions?
Thanks.
Should be server name\instance name:port number.
Servername:port number may work as well.
|||Its Servername\IstanceName,Portnumber.HTH, Jens Suessmeyer,
http://www.sqlserver2005.de
|||Thank you, Jens, for the help.
No comments:
Post a Comment