The Problem: In your SQL Availability Group environment and you have created a new login. After failover the users reports that they cannot connect to the database with the application. Because the connection to database goes via AG Listener, the application will be redirect to the secondary SQL Server Node after failover of Availability GroupContinue reading “Sync Login for SQL Server Availability Groups AG Multiple Server”
Tag Archives: sql server
Join database to SQL Server Availability Group with PowerShell
The customer for whom I am working, need that I check all SQL Server Instances (about 40) for a database that is not joined in the availability group (AG). I am a little bit lazy to do that manually, so I decide to write a PowerShell. Of course, I am using dbatools (thanks to allContinue reading “Join database to SQL Server Availability Group with PowerShell”
Home 