How to assign Reader Access to an Azure SQL Database

TSHEPHO RAPHOLO 120

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?

ShaktiSingh-MSFT 14,281 Reputation points Microsoft Employee

2024-03-21T07:35:33.0366667+00:00

Hi TSHEPHO RAPHOLO •,

Just checking in to see if the provided suggestion helped. If this answers your query, do click Accept Answer and Mark Helpful for the same. And, if you have any further query do let us know. Thanks

2 answers

ShaktiSingh-MSFT 14,281 Reputation points Microsoft Employee

2024-03-26T04:26:34.3366667+00:00

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://video2.skills-academy.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
Please sign in to rate this answer.

1 person found this answer helpful.

0 comments No comments
Sign in to comment
Marcin Policht 16,965 Reputation points MVP

2024-03-20T11:16:46.34+00:00

There are a couple of ways

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

https://video2.skills-academy.com/en-us/purview/how-to-policies-data-owner-azure-sql-db

hth

Marcin
Please sign in to rate this answer.
TSHEPHO RAPHOLO 120 Reputation points

2024-03-21T12:01:03.1433333+00:00

I have been assigned Reader role at SQL Server Level but getting the below Error When trying to connect i get the below error

Kindly advise on what could be causing all this
Sign in to comment