How to assign Reader Access to an Azure SQL Database

Question

Is assigning a Reader Role access in the Azure Server level to XXXXXXX-sql-01.database.windows.net sufficient to view/read tables or databases hosted on the SQL Server? How can I properly assign a Reader role to XXXXXXX-sql-01.database.windows.net?

Answer 1

Hi TSHEPHO RAPHOLO •,

Could you please refer to the solutions provided at the below links if these are helpful:

https://techcommunity.microsoft.com/t5/sql-server/sql-server-connectivity-issues-ideas/m-p/3794493

https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/connect/network-related-or-instance-specific-error-occurred-while-establishing-connection#error-messages

https://stackoverflow.com/questions/52272001/cannot-open-a-sql-connection-to-a-sql-server-the-network-path-was-not-found

Awaiting your reply.

Thanks

Answer 2

There are a couple of ways

https://stackoverflow.com/questions/73033034/set-datareader-role-in-azure-sql-database-why-do-i-get-error

https://learn.microsoft.com/en-us/purview/how-to-policies-data-owner-azure-sql-db

---

hth

Marcin