SQL Server Registered Server using Active Directory With Password Authentication

Question

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.

Thanks

ry_shannon · Answer

Maysam Jahromi&nbsp;Have you received any input regarding this? I'm doing the same and running into similar issues.&nbsp;Thanks!

maysam jahromi · Answer

Ry_Shannon&nbsp;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.&nbsp;

Forum Discussion

SQL Server Registered Server using Active Directory With Password Authentication

Share

Resources