Friday, March 23, 2012

How to use SSMSE to connect to instance service directly (without going through Browser service)

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