Create User to access SQL Server DB/Using NT Authentication

Posted on 2011-05-12
Last Modified: 2012-08-14

We use MS access, SQL server 2005, NT Authentication.Looking to restrict users from going in via ODBC and want to create a username and password through the MSaccess GUI that will pass the credentials through ODBC and not have the user access the SQL server through Excel/Or other ODBC Applications...Whats the best way to accomplish this??
Question by:Atomicsteaks
    LVL 10

    Expert Comment

    The best way I know is to have SA set across all the tables.. OR
    Disable windows authentication... OR
    create passwords that are so strict, wontbe hackable...does this help?
    LVL 42

    Accepted Solution

    The best way is to disable all user access to tables.  Code up stored procs and give those procs access to tables. Give users execute access to procs to get the data.  I know... but you asked.

    Back on this planet, you may want to consider using DSN-less connect strings (Google it).  You can programmatically connect from Access using such a connection without storing the login credentials in the DSN.

    You can also store the DSN without login credentials and programmaticly append them to the connection string.  If a user tries to use that DSN through EXCEL or the like, ODBC will prompt for a userid/password.

    Author Closing Comment

    This is the best route for US..We haven't implemented it-But solves our problem.

    Thank you...Any other information would be greatly helped..

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now