How to connect a SQL-CLuster with Access?

Copper Contributor

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 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 (free version)