I have a server that has 2 NICS and each is connected to 2 different subnet. Is it possible to connect to this Sql server in each of the different subnet? If so, what special procedure do I have to do to configure the Sql Server? I am using sql server 2008. Thank you!
migrated from stackoverflow.com Feb 6 '12 at 18:19
By default SQL Server will bind listen to all addresses, so it will be visible from all subnets. You can also explicitly configure SQL Server to listen on only one or the other of the NICs, see
Long story short: you don't have to do anything.