CODEWITHSUNDEEP
sql-serverms-accessodbc
rachelm920
rachelm920

Reputation: 3

Connection Failed. SQL State 28000 Microsoft Access

The front end MS Access database I maintain was recently switched to a new server by our server department. Previously, if a user opened the DB they did not have to log on or anything. However now we receive this error message

Once clicking OK this pops up defaulting to the user's windows login ID with "use trusted connection" checked by default. Although I've gone through the DSN settings time and time again and changed it to the appropriate Login ID/Password for the server. It still keeps defaulting back to the same windows login info. If I uncheck the box and type in the correct login information it allows me to the table, form etc.

Without getting the server team involved again, is there any possible way I can fix this from my end? We have multiple users at multiple sites using the database which is why we put it online (SQL) to begin with. I want to roll out an update soon and would love to have this issue resolved.

Thanks in advance :)

Upvotes: 0

Views: 2624

Answers (1)

Gustav
Gustav

Reputation: 55806

Remove the mark at Trusted Connection (= Windows authentication) and provide the user credentials for SQL Server. If not known, get them from the DBA.

Upvotes: 1

Related Questions