Post reply

Only allow a user to connect from a machine

  • April 21, 2009 at 7:37 am

    #220504

    Hi,

    I have a problemn, I have a user that connects from other servers to my database. So far so good... But my devolopers are using this account to log in from there computers to the production server.

    How can I arrange that this user only may connect when it is logged on to a specifict machine and not from a other machine? Is this possible for SQL-Users (not domain users)?

    Thanks for you reply in advance!

    Best regards,

    Mischa Hoogendoorn

    DBA

  • April 21, 2009 at 7:51 am

    #981435

    Mischa,

    Look for Logon Triggers. You can use this kind of trigger to perform an action as soon as a connection is made.

    hth,

    Robbert Hof

  • April 21, 2009 at 7:54 am

    #981441

    Also: http://www.sqlservercentral.com/articles/Security/66151/

  • April 22, 2009 at 5:58 am

    #982104

    Thanks! This was a big help for me! 🙂

    It works great now... I have made a table that holds the hostnames that are allowed to log in using this account...

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

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