Re: multiple instances behind a firewall
From: jjjjj (jjjjj_at_discussions.microsoft.com)
Date: 09/09/04
- Next message: ChrisR: "More Materialized View questions"
- Previous message: Hasani \(remove nospam from address\): "Re: Perform aggregate functions on uniqueidentifiers"
- In reply to: Wayne Snyder: "Re: multiple instances behind a firewall"
- Next in thread: jjjjj_at_discussions.microsoft.com: "Re: multiple instances behind a firewall"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 9 Sep 2004 08:03:03 -0700
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...
> > 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?
>
>
>
- Next message: ChrisR: "More Materialized View questions"
- Previous message: Hasani \(remove nospam from address\): "Re: Perform aggregate functions on uniqueidentifiers"
- In reply to: Wayne Snyder: "Re: multiple instances behind a firewall"
- Next in thread: jjjjj_at_discussions.microsoft.com: "Re: multiple instances behind a firewall"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
