multiple instances behind a firewall

I know it is possible to have multiple instances of SQL Server on a single
machine but I would like to have multiple instances on different machines
behind a firewall. My firewall software designates an instance on one machine
as the database server. How can I address an instance on another box?
Probably port 1433 on your firewall redirects the input to the SQL IP
Address -port 1433... You would have to open a DIFFERENT Port on your
firewall and direct THAT port to a different SQL IP Address - port 1433...
Then anyone who wished to connect to the second instance would have to
specify the OTHER port number in their connection string.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"jjjjj" <jjjjj@.discussions.microsoft.com> wrote in message
news:6314165C-DFC6-4F6C-BD87-E3CE16718B10@.microsoft.com...
> I know it is possible to have multiple instances of SQL Server on a single
> machine but I would like to have multiple instances on different machines
> behind a firewall. My firewall software designates an instance on one
machine
> as the database server. How can I address an instance on another box?
|||Thanks Wayne. I'm beginning to get the picture. I can see how to connect to
the other database instance, but how would I create a SQL Server registration
for BOTH instances in Enterpries Manager when they both have the same IP
address?
"Wayne Snyder" wrote:

> Probably port 1433 on your firewall redirects the input to the SQL IP
> Address -port 1433... You would have to open a DIFFERENT Port on your
> firewall and direct THAT port to a different SQL IP Address - port 1433...
> Then anyone who wished to connect to the second instance would have to
> specify the OTHER port number in their connection string.
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "jjjjj" <jjjjj@.discussions.microsoft.com> wrote in message
> news:6314165C-DFC6-4F6C-BD87-E3CE16718B10@.microsoft.com...
> machine
>
>
|||Can you recommend a firewall port? I'm not very familiar
with all of the defaults that might be already in use.

>--Original Message--
>Probably port 1433 on your firewall redirects the input
to the SQL IP
>Address -port 1433... You would have to open a DIFFERENT
Port on your
>firewall and direct THAT port to a different SQL IP
Address - port 1433...
>Then anyone who wished to connect to the second instance
would have to
>specify the OTHER port number in their connection string.
>--
>Wayne Snyder, MCDBA, SQL Server MVP
>Mariner, Charlotte, NC
>www.mariner-usa.com
>(Please respond only to the newsgroups.)
>I support the Professional Association of SQL Server
(PASS) and it's[vbcol=seagreen]
>community of SQL Server professionals.
>www.sqlpass.org
>"jjjjj" <jjjjj@.discussions.microsoft.com> wrote in message
>news:6314165C-DFC6-4F6C-BD87-E3CE16718B10@.microsoft.com...
Server on a single[vbcol=seagreen]
different machines[vbcol=seagreen]
instance on one[vbcol=seagreen]
>machine
on another box?
>
>.
>