How to connect a SQL-CLuster with Access?

Copper Contributor
Spoiler
 

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

@olafhelper 

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... 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 www.DeepL.com/Translator (free version)