Error 17 on one Access Database

Question

Hello

I have 3 Access Databases that that use and connect to my SQL 2019 instance using ODBC After the move to a new personal computer, One of these databases is getting error 17 when I try to relink/connect to the Database

I have gone into ODBC manager and tested all of my connections - they all work fine
I have checked and double checked the passwords they are correct
I am not having any problems with the other Access databases using the same ODBC connections

Any thoughts or words of wisdom that can help me resolve this since I lost

Gary

Answer 1

The error means that you are not able to reach SQL Server. That is, the server name may be wrong, the instance name may be wrong, the instance may not be running, the instance may not be set up to accept remote connections, there could be a blocking firewall. On the other hand, passwords have nothing to do with it.

As this is a problem in your environment that we don't have access to, we can't say what is wrong, only give advice for troubleshooting. Here is a link to a troubleshooting document: https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/troubleshoot-connecting-to-the-sql-server-database-engine?view=sql-server-2017

Answer 2

Hi @Gary Henry ,

Are there any updates in this case?
In addition, what the authentication are you using to connect SQL Server in Data Source?
If you are using SQL Server Authentication, please make sure the user and password is correct, and mixed authentication must be enabled in SQL Server. And make sure your login account has access permission on the database.

Best Regards,
Amelia

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
What can I do if my transaction log is full?--- Hot issues November
How to convert Profiler trace into a SQL Server table -- Hot issues November

Answer 3

Hi

sorry for the late reply but it has been a crazy weekend. I was able to do a little more investigation and now I am more confused...

First, the Application that is trying to connect is Access 2019...

If I try to connect to SQL and relink all the tables I have no problem connecting and re-linking but as soon as I try to access to the linked tables from the application, I get this error.

I do not know where to start to troubleshooting this...

One thing I did notice is that after I re-linked the tables Access now gives me this error

When I press OK, I get the login dialog box thinking it is a trusted connection and I never set this up as a trusted connection. If I uncheck "trusted" and enter the credentials, I get error 17 again...

I am so confused....

• I proved that my ODBC connection is correct by re-linking the tables
• I have other access applications that can connect to the SQL in the same way from the same comptuer...

Anyone have any ideas

thanks again for the follow-up

Gary

Answer 4

Is the user Connection with Windows Authentication and if so, is the Windows account added as Login to SQL Server and do the Login have permissions to Access the database?

Are remote Connections enabled on the SQL Server? See http://social.technet.microsoft.com/wiki/contents/articles/how-to-enable-remote-connections-on-sql-server.aspx

Are the used ip ports unblocked in the Firewall, on Server and Client side? See http://technet.microsoft.com/en-us/library/cc646023.aspx