Category:SSMS

New Trusted Site Required when Connecting to Azure SQL DB

Posted on Updated on by Andy LeonardCategories:Azure, Azure SQL DB, Security, SSMS

I got pinged about a new trusted site requirement when I tried to connect to Azure SQL DB this morning. https://aadcdn.msftauth.net is the URL. I added the URL to Internet Explorer’s Trusted Sites: I was then able to connect to Azure SQL DB and add a rule for my IP using SQL Server Management Studio (SSMS).

Change to the SSMS Create Catalog Dialog

Posted on Updated on by Andy LeonardCategories:SSIS, SSIS Catalog, SSMS

I’m glad to see a change in the Create Catalog dialog for creating an instance of an SSIS Catalog using SQL Server Management Studio (SSMS) version 17.9. The “Enable this server as SSIS scale out master” checkbox is now unchecked by default: I’m not sure if this changed in SSMS version 17.9 or an earlier …
Continue reading Change to the SSMS Create Catalog Dialog