CODEWITHSUNDEEP
sql-serverms-access
Barry Sweezey
Barry Sweezey

Reputation: 1

Allow use of Access application with tables linked to SQL Server without giving users server roles?

I have an Access 2013 application with tables linked to SQL Server 2008 R2. When testing with a user, I gave him db_datareader and db_datawriter roles for the database.

I got this error:

Connection failed: SQLState '28000' SQL Server Error: 18456 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'xxxxx'

When I added sysadmin server role, he was able to use the application.

How can I allow users to use the app without giving them server roles?

Upvotes: 0

Views: 93

Answers (1)

Barry Sweezey
Barry Sweezey

Reputation: 1

Thanks for the responses. It turns out that this issue is caused by the security setup for this server to adhere to DoD requirements.

Upvotes: -1

Related Questions