Post reply

M2M logins IP based access restriction

  • August 26, 2014 at 8:59 am

    #289379

    I received a security policy for machine-2-machine logins that requires to restrict their access to database, only if

    logon is from specified IPs, this feature exists on Oracle and has been implemented, please can you confirm that

    SQL Server doesn't have this feature natively? I found custom solutions based on logon triggers, i'm looking for something based on product configuration.

    Thank you

  • September 5, 2014 at 1:02 am

    #1743413

    I imagine this means that this feature doesn't exist ......

  • September 5, 2014 at 6:32 am

    #1743497

    Logon triggers or setting up a firewall will be the only ways to do what you need to do.

  • September 5, 2014 at 10:06 am

    #1743565

    That's something I would expect to do in a firewall (either a software one on the machine restricting access, or a hardware one between the machine and the outside world). But it's more than a decade since I last did anything like that, so maybe some Sql features have arrived in teh meantime.

    Tom

  • September 10, 2014 at 6:29 am

    #1744405

    Thank you all!

Viewing 5 posts - 1 through 4 (of 4 total)

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