Results 1 to 3 of 3
  1. #1
    trevor is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2018
    Location
    Orlando, FL, USA
    Posts
    10

    Question Access Not Prompting for SQL Login Credentials

    Heya everyone,



    I recently migrated my Access back end over to an Azure SQL Database. I relined the tables using the ODBC Driver 13 for SQL Server, I did not save the password.

    I expected Access to prompt for an SQL login however, the connection fails for other users. Windows authentication is currently not support on Azure SQL, they do support active directory. The server management tool allows for login with integrated active directory, does anyone know of something similar I can do to pass the active directory login info along with the connection?

    If not, I could make a form the prompts the user for their domain password and uses the as part of the connection string but I'm not overly familiar with opening a SQL connection in VBA.

    Would anyone be able to shed some insight on the best practice here?

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    7,898
    wouldn't this be an Azure SQL Database question, instead of Access?
    (on connecting Azure to SQL)

    can you just skip Azure and connect to the SQL with pass? (or without)

  3. #3
    NoellaG's Avatar
    NoellaG is offline Expert
    Windows 10 Access 2016
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    636
    Hi, just create a user group in the active directory and add this group to your SQL database security with the proper rights. Add all users that need access to your database to this group.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 11-21-2018, 04:42 PM
  2. Retrieve login credentials
    By vector39 in forum Database Design
    Replies: 3
    Last Post: 07-12-2017, 01:56 PM
  3. Programmatically changing login credentials on ODBC connections
    By Glenn_Suggs in forum Import/Export Data
    Replies: 2
    Last Post: 07-11-2016, 10:51 AM
  4. Replies: 2
    Last Post: 08-13-2015, 02:14 PM
  5. Replies: 3
    Last Post: 07-08-2014, 12:06 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums