SQL QUESTION

#1

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.

#2

If these two SQL Server instances are running on the same server, they should
have the same IP address with different port numbers. If they are on
different servers, they must have different IP addresses. For SQL instances
running in a failover cluster, each instance must have its own IP address.

Linchi

"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.

#3

If these two SQL Server instances are running on the same server, they should
have the same IP address with different port numbers. If they are on
different servers, they must have different IP addresses. For SQL instances
running in a failover cluster, each instance must have its own IP address.

Linchi

"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.

#4

If these two SQL Server instances are running on the same server, they should
have the same IP address with different port numbers. If they are on
different servers, they must have different IP addresses. For SQL instances
running in a failover cluster, each instance must have its own IP address.

Linchi

"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.

#5

If these two SQL Server instances are running on the same server, they should
have the same IP address with different port numbers. If they are on
different servers, they must have different IP addresses. For SQL instances
running in a failover cluster, each instance must have its own IP address.

Linchi

"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.

#6

If these two SQL Server instances are running on the same server, they should
have the same IP address with different port numbers. If they are on
different servers, they must have different IP addresses. For SQL instances
running in a failover cluster, each instance must have its own IP address.

Linchi

"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.

#7

If these two SQL Server instances are running on the same server, they should
have the same IP address with different port numbers. If they are on
different servers, they must have different IP addresses. For SQL instances
running in a failover cluster, each instance must have its own IP address.

Linchi

"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.

#8

If these two SQL Server instances are running on the same server, they should
have the same IP address with different port numbers. If they are on
different servers, they must have different IP addresses. For SQL instances
running in a failover cluster, each instance must have its own IP address.

Linchi

"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.

#9

If these two SQL Server instances are running on the same server, they should
have the same IP address with different port numbers. If they are on
different servers, they must have different IP addresses. For SQL instances
running in a failover cluster, each instance must have its own IP address.

Linchi

"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.

#10

If these two SQL Server instances are running on the same server, they should
have the same IP address with different port numbers. If they are on
different servers, they must have different IP addresses. For SQL instances
running in a failover cluster, each instance must have its own IP address.

Linchi

"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.