May 18, 2011 at 3:38 pm
Is there any problem with having 2 or more NIC's with IP addresses on completely different networks on the same instance of SQL server 2008 but separate databases?
May 18, 2011 at 3:56 pm
david.richard (5/18/2011)
Is there any problem with having 2 or more NIC's with IP addresses on completely different networks on the same instance of SQL server 2008 but separate databases?
Why do you want to do this?
What are you attempting to accomplish?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 18, 2011 at 3:59 pm
2 different environments that need a SQL server.
May 18, 2011 at 4:01 pm
What is your plan to ensure that only one network can access one database and the other network can only access the other database?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 18, 2011 at 4:03 pm
Yes, that's the plan.
May 18, 2011 at 4:06 pm
No, how do you plan to enforce that?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 18, 2011 at 4:11 pm
I have one application for each database. Each application only wants it's own database.
May 18, 2011 at 4:16 pm
K so the enforcement would be done at the app level?
It really makes little difference to have two different networks attaching to that server - until you are looking to prevent network a from accessing database b and network b from accessing database a.
You can either do it that way (how you described), or have your network guys setup vlans at the router and then there is nothing for you to worry about at the SQL Server level (as far as network segregation). The use of VLANs and routing equipment to accomplish this would be preferred.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply