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.
@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.