|
Home > Archive > MS SQL Server > April 2005 > SQL Server with 2 NIC
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL Server with 2 NIC
|
|
| Fernando Berretta 2005-04-25, 11:23 am |
| Hi,
I´ve an SQL server installed using 2NIC, how should I configure the SQL
server in order to listen only over one of them ?
E.g. NIC1: 192.168.0.100 NIC2: 164.109.145.147
I only wont the sql server listening on the private IP address.
Best Regards,
Fernando
| |
| Mark Allison 2005-04-25, 11:23 am |
| Fernando,
You will need to do this using a firewall. SQL Server cannot be configured
to do this.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
"Fernando Berretta" wrote:
> Hi,
>
> I´ve an SQL server installed using 2NIC, how should I configure the SQL
> server in order to listen only over one of them ?
>
> E.g. NIC1: 192.168.0.100 NIC2: 164.109.145.147
>
> I only wont the sql server listening on the private IP address.
>
> Best Regards,
> Fernando
>
>
>
>
| |
| Fernando Berretta 2005-04-25, 11:23 am |
| Mark,
Thanks for your promt response,
Is not a good news, would be good SQL had this feature... but, anyway,
thanks for your help.
Regards,
Fernando
"Mark Allison" <marka@no.tinned.meat.mvps.org> wrote in message
news:69424E73-1DEF-4181-AE74- 696226CF1AC3@microso
ft.com...[color=darkred]
> Fernando,
>
> You will need to do this using a firewall. SQL Server cannot be configured
> to do this.
>
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
>
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
>
>
> "Fernando Berretta" wrote:
>
|
|
|
|
|