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 ?
ThanksHi
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
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment