Showing posts with label turned. Show all posts
Showing posts with label turned. Show all posts

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.