Post reply

Question about SQL connections from local VM's

  • October 3, 2011 at 10:05 am

    #244763

    Hello,

    I have a remote Win2008 server. I have SQL 2008R2 express installed on this machine. This machine also has virtual server installed hosting 2 Win2008 VM's.

    On those 2 VM's there is an application connecting to the SQL server.

    Here is an example of the connection String: Provider=SQLOLEDB;Persist Security Info=False;Initial Catalog=Somedatabase;Data Source=xxx.xxx.xxx.xxx.;user id=SomeUser;pwd=Somepassword;

    What configuration settings should i be looking at to only allow the 2 VM's to be able to connect to the SQL server. I dont want any connections that are not on the local network.

    I have searched and have found similar questions that were awnsered. I just want to verify before i setup Firewall rules or create a login trigger that their might a different solution when the computers connection to the SQL server are on the same VM network.

    Thanks

  • October 3, 2011 at 10:14 am

    #1389657

    Not sure I understand what you mean in your last sentence about connecting to 'this' SQL server.

    If you want to restrict access to your vm SQL servers, you can set the vm network setting to Host rather than Bridged.

    If you want to restrict access on your remote SQL server (not vm) to be connected to from ONLY your Vm's, then it'll likely need to be done with a firewall rule or a SQL login trigger. A non-vm SQL server is either available to all remote connections on that network/subnet, or only local connections. Nothing in between by default.

    Jim Murphy
    http://www.sqlwatchmen.com
    @SQLMurph

  • October 3, 2011 at 10:25 am

    #1389668

    Thanks Jim for your response.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply