I have a question about multiple SQL Instances running on the same server.

I inherited a SQL Server that had been setup with two SQL Instances (Prod &
Dev).
Both instances are setup to use the default port (1433). There is an
application
server that needs to connect to the DEV instance via ODBC, but they are unable
to connect and only connect to the Prod instance.

Is there a way to have them both answer on 1433? I thought that was why you
have a named instance (One is DBSRV1\DBSRV1_PROD and the other is
DBSRV1\DBSRV1_DEV). I know it works if I change the port of the DEV instance,
but that would involve a lot of firewall changes that the client is not
happy about
performing.

It would be best if we can have both instances working on the same port.

Any pointers would be appreciated.

Only one instance can use a port at a time. So if they are both configured
to use port 1433, you cannot use both databases at once.
Probably not what you want. Better change the DEV instance to something
else.
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Joe" <Joe@discussions.microsoft.com> wrote in message
news:C554AFD9-5AD9-4DF4-A6B7-FBAAA43CCDE7@microsoft.com...
>I have a question about multiple SQL Instances running on the same server.
>
> I inherited a SQL Server that had been setup with two SQL Instances (Prod
> &
> Dev).
> Both instances are setup to use the default port (1433). There is an
> application
> server that needs to connect to the DEV instance via ODBC, but they are
> unable
> to connect and only connect to the Prod instance.
>
> Is there a way to have them both answer on 1433? I thought that was why
> you
> have a named instance (One is DBSRV1\DBSRV1_PROD and the other is
> DBSRV1\DBSRV1_DEV). I know it works if I change the port of the DEV
> instance,
> but that would involve a lot of firewall changes that the client is not
> happy about
> performing.
>
> It would be best if we can have both instances working on the same port.
>
> Any pointers would be appreciated.

You can have two different SQL Server instances running on the same server
and listening on the same port including 1433, when the server is in a
cluster and the two instances are clustered. It's possible because they'll be
using two different IP's.

Linchi

"Joe" wrote:

> I have a question about multiple SQL Instances running on the same server.
>
> I inherited a SQL Server that had been setup with two SQL Instances (Prod &
> Dev).
> Both instances are setup to use the default port (1433). There is an
> application
> server that needs to connect to the DEV instance via ODBC, but they are unable
> to connect and only connect to the Prod instance.
>
> Is there a way to have them both answer on 1433? I thought that was why you
> have a named instance (One is DBSRV1\DBSRV1_PROD and the other is
> DBSRV1\DBSRV1_DEV). I know it works if I change the port of the DEV instance,
> but that would involve a lot of firewall changes that the client is not
> happy about
> performing.
>
> It would be best if we can have both instances working on the same port.
>
> Any pointers would be appreciated.