I'm migrating several Access backends from SQL Server 2005 to SQL Server 2016. I have successfully gotten the ODBC connections to work and I can see and use the Access databases (on the network). However when the users open a 2016 copy of the backends to their Access databases they get an error "Connection failed, SQL State: ‘01000’, SQL Server Error: 53" AND "Connection failed, SQL State: ‘08001’, SQL Server Error: 17"
Here's what I have done so far: I made sure TCP/IP was enabled on SQL Server 2016, I made sure Port 1433 was open, SQL Server and Windows Authentication enabled, allow remote connections to the server.
The user's machine is using 64-bit Windows 7 and the 32-bit version of Office. I gave the user full rights to all schemas and membership. Is there a driver update needed? I don't see any online that is for SQL 2016 and compatible with the user machines. Any ideas? Thanks in advance!
I've used Access to view SQL Server 2016 tables, so this is possible. Can you install SSMS for one of the users and check their access from there?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.