Microsoft Secure Tech Accelerator
Apr 03 2024, 07:00 AM - 11:00 AM (PDT)
Microsoft Tech Community

SQL Server Registered Server using Active Directory With Password Authentication

Copper Contributor

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 

2 Replies

@Maysam Jahromi Have you received any input regarding this? I'm doing the same and running into similar issues.

 

Thanks!

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