Forum Discussion

admin1095's avatar
admin1095
Copper Contributor
Aug 10, 2023

How to connect an Access database to an Always-On Listener?

I follow this instruction for SQL Server and hope it is applicable to the listener https://support.microsoft.com/en-us/office/import-or-link-to-data-in-an-sql-server-database-a5a3b4eb-57b9-45a0-b732-77bc6089b84e
I go to EXTERNAL DATA -> NEW DATA SOURCE -> FROM DATABASE -> FROM SQL SERVER -> LINK TO THE DATA SOURCE BY CREATING A LINKED TABLE -> MACHINE DATA SOURCE -> NEW ->SQL SERVER -> then I enter a name and as server the DNS name of my listener, that is listener in my case. -> then I choose SQL server authentication method as authentication method and enter password and user -> then two errors come:
SQLState: 0100
SQL Server error: 53
SQLState: 08001
ConnectionOpen (Connect())
SQL Server error: 17
SQL Server does not exist or access is denied.

The ping to the listener also exists.
With a SQL Server my steps work.
What am I doing wrong?

No RepliesBe the first to reply