SQL QUESTION

#31

if you have two instances of sql server installed on two different physical
server
then you can connect to sql server by server ip address (two server con't
have same ip address). but if you have installed two instances of sql server
on same physical machine then you can connect to default instance by ip
address and named instance by ip address\server name. also namaed instance
run on dynamic port (because 1433 is used by default instance) so, look for
your firewall also . the port must not be blocked by your firewall on which
sql server listens. (you can acutely check dynamic port number from sql
server configuration manager - network configuration - protocols - tcp/ip )

Manpreet Singh
DBA - SQL Server

"Chris" wrote:

Quote:

I have a problem trying to connect to sql server 2005 remotely. I have two
sql servers in my place of work in the same network. I'm trying to connect
to each one using the same public IP address but to a different ports, i don't
know if this is possible. My router is the Dlink 704-up. I can connect with
one of the servers assigning the public IP address to the 1433 port in the
router, but when I add the other server it does not allow me to connect.
Does anybody know how or has ever tried to do this?. Thanks for your help.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SQL QUESTION

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients

RE: SQL QUESTION - 08-21-2008 , 12:30 AM