Hi,
I am trying to connect to two different SQL Servers using my broadband internet connection.
Both servers are connected to a network which has one "visible" IP address.
Using the Enterprise Manager, I can connect successfully to one SQL Server, but cannot access the SQL Server on another of the network servers. Obviously in Enterprise Manager, I am supplying the IP address in order to connect to the SQL Servers, but how
do I differentiate between the two different SQL Servers at the other end and connect to both at the same IP address?
Many thanks,
Jonathan S
If the servers are on the same physical machine, then the default instance
listens on 1433 and the other "named instance" would listen on another
port. You'll need this info in order to connect. By default Named
Instances listen on dynamic ports. You'll want to change this to a fixed
port and only allow traffic to this specific port for the second instance.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment