Forum Discussion
How to connect a SQL-CLuster with Access?
I have two SQL servers that are in an alwayson availibility group. The cluster should serve as a backend for an Access database on a client. However, I can not find instructions on how to set this up.
Thank you
2 Replies
admin1095 , setup what?
A client connects to the AG listener, he isn't aware it's a cluster instead a stand-alone server.
Connect to an availability group listener - SQL Server Always On | Microsoft Learn
Thanks for the answer. However, I do not know how to connect an Access database to the listener. I follow the instructions in this article https://support.microsoft.com/en-us/office/import-or-link-to-data-in-an-sql-server-database-a5a3b4eb-57b9-45a0-b732-77bc6089b84e and for a SQL server it works perfectly. To connect to the listener, I simply specified the listener DNS name in my case "Listener" instead of a SQL server name. And I specified the SQL server driver as driver. Nevertheless a connection is not possible.
Translated with http://www.DeepL.com/Translator (free version)
