Monday, March 26, 2012

Named Instance into a IP Server

Hello,
May be my question its simple, but I don't know the answer, I need to
connect to a named instance into a Remote Server using an IP Address, how I
can do that ?
Thanks
Hi
The default instance normally listens on an IPAddress and Port 1433, so the
client resolves the name to <IPAddress>:1433
A named instance is the same, but just listens on a different port.
<IPAddress>:<configured port>
If you need to connect via an IP only, the named instance must be setup to
use a static port. Do this though enterprize manager.
e.g. In you connection string use: 192.168.10.1:5001 for a named instance on
192.168.10.1 with a static port of 5001.
Regards
Mike
"Ing. Mike" wrote:

> Hello,
> May be my question its simple, but I don't know the answer, I need to
> connect to a named instance into a Remote Server using an IP Address, how I
> can do that ?
>
> Thanks
>

No comments:

Post a Comment