Syncing System resources with Always-on AG Secondaries #8639
TedSchnieders
started this conversation in
Contributors
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
The attached script has been developed to sync resources to the secondary instance of a SQL Server Always-On availability Group (Logins, Jobs, permissions, linked servers, etc..) We are constantly receiving the blow error message because the script has an open connection to DAC when the next process tries to also gain a DAC connection. We are a little lost and cannot figure out what we need to do to ensure this does not take place and the DAC is available for connecting. Thank you for your time and any advice you may be able to offer to resolve this issue.
DESCRIPTION: Could not connect because the maximum number of '1' dedicated administrator connections already exists. Before a new connection can be made, the existing dedicated administrator connection must be dropped, either by logging off or ending the process. [CLIENT: 127.0.0.1]
Set-AlwaysOnSyncResources.txt
Beta Was this translation helpful? Give feedback.
All reactions