question

niall5098 avatar image
niall5098 asked

sharepoint error connecting to active node

Hi There, we have a basic A/G configured and failed from node1 to node2 yesterday only to find the sharepoint app couldn't connect to the primary instance which was node2. the error thrown in the sp logs were:

the target database, 'sharepoint_config', is participating in an availability group and is currently not accessible for queries

i could expand the db anbd expand the tables through ssms so the server\db was available but no obvious reason why the app couldn't connect.

sharepoint config is set up to connect to the cluster name.

anyone ever seen this issue before ?

error-messagealways-onsql server 2016sharepoint-2010
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
anthony.green avatar image
anthony.green answered

AOAG setup you should be connecting to the listener not the clustername.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.