• saum70 (12/27/2014)


    Hello,

    Previously we used to store sql user logins in registry or xml for our applications(made in C#) to access the database. Now we are proposing that the application be logged on by the user with their windows loggin id(windows credentials) and in turn access the database. We do not want to store the loggin id and password in the database. Hence how do we implement the same.

    Also we want that only the applications created by us can get access to the database.

    For example

    User A, B and C have access to application and in turn access to the database. but these users should not be able access the database say using excel or any other third party application.

    Thanks for help

    I've used a logon trigger to achieve this and it works very well.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉