SharePoint connect to SQL AG

Question

Hi there,

A simple question: there is a SharePoint will connect to backend SQL Database. The database is SQL Always On AG. We have a two information: SQL AG Cluster Name is SQLAG, SQL AG Listener is SQLListener; When we connect to SQL AG our connection string will be:

SQLAG\SQLListener or SQLListener\SQLListener or SQL Hostname\SQLListener

Thanks

Answer 1

usually connection string contains servername\dbname. You may also use SQL alias and use this alias name for connection string - but under the hood alias should still contain servername and dbname it refers to.

Answer 2

You should be using the fully qualified name for an AOAG Listener (listener.corp.example.com). Do not use a SQL Alias or single server name. SQL Aliases are used for database mobility. AOAG is mobile already.

Answer 3

SQL AG Listener name, SQLListener is used in this scenario.
See the examples of connection string via this document: Connect to an Always On availability group listener.

---

If an 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. **