May 16 2017
- last edited on
Jan 14 2022
I am trying to create Registered Servers list in SQL Server for SQL Azure Databases. I plan to connect to all databases at same time and run some queries. When I register SQL Servers that are authenticating using Active Directory Password Authentication, I cannot connect all of them at same time; I can connect to eatch one at a time.
I wonder if there is any limitation on Azure Active Directroy for this?
When I use SQL Server Authentication, it works fine.
Jul 26 2019 01:53 PM
@Maysam Jahromi Have you received any input regarding this? I'm doing the same and running into similar issues.
Jul 26 2019 02:14 PM
@Ry_Shannon No I did not but I found a way to go around it. I developed a powershell to basically get a list of databases I am interested (Filter based on wildcard) and just run any script I want on those using a loop.