Connect to Azure SQL Database Read Only Replica from SSMS
This is a quick blog post that shows how to connect to a read scale out replica in Azure SQL database business critical tier.
When you create the database in the Azure portal enable Read scale out. You can change this setting in the configure blade as needed. If you don’t have access to the portal, there are several methods to accomplish this task programmatically by following this doc.
To connect to the read replica with SSMS, enter your login information, then click on the “Additional Connection Parameters” tab and add the following param: “ApplicationIntent=ReadOnly”
To check if you are connected to the read replica, you can simply try to create a table, and you would get an error such as the following:
You can also run this query to find out if your database is ready only:
SELECT DATABASEPROPERTYEX(DB_NAME(), 'Updateability');