I don't see any resorces in azure portal

Question

Thank you in advance!

I am new to azure portal, I joined a team of developers for a specific project. I have granted access to azure portal, and granted a contributed role. but when I log in to the portal I don't see any resource. I know there is there is an SQL Database in the portal but I am getting is "not SQL database to display" message.

When I try to access the database from my local computer with a connection string I am getting the following message.

Microsoft.Data.SqlClient.SqlException: 'Cannot open server '**appdb' requested by the login. Client with IP address '..' is not allowed to access the server.

Please guide to the right direction.

Thank you!

Answer 1

Good day,

I am new to azure portal, I joined a team of developers for a specific project.

(1) Do you use a separate subscription or did the team created for you a user in their subscription?

Note: For now I will; assume that you have a user in the company's Azure active directory using their subscription.

---

I don't see any resorces in azure portal

For this issue you should contact the person in your team who is the owner of the subscription (administrator of AAD and the Role-based access control), where the Azure services are. He should give you the right permission for each service or for the entire subscription

For example: Azure Assign User to Subscription and configure Role-based access control (RBAC)

1. Go to portal.azure.com
2. Search for "subscriptions"
3. Select the subscription you want to give access to.
4. On the left menu, click on "Access Control (IAM)"
5. Click Add
6. Select: "Add role assignment"
7. fill the form to add role to the user

---

Regarding the role

granted a contributed role... I know there is there is an SQL Database in the portal but I am getting is "not SQL database to display" message.

A Contributor grants full access to manage all existing resources. If you do not see the resources then you probably did not get Contributor role on the entire subscription. Make sure that you have roles for each resource which you need to use or for the entire subscription

---

When I try to access the database from my local computer with a connection string I am getting the following message... Client with IP address '..' is not allowed to access the server.

Seems like you need to configure the Azure server-level IP firewall rule or the database firewall as explained here:

To add Azure server-level IP firewall rule:

1. Go to the list of servers: https://portal.azure.com/#blade/HubsExtension/BrowseResource/resourceType/microsoft.sql%2Fservers
2. select your server
3. on the left menu click on "Firewalls and virtual networks"
4. add your IP to the list

Note! You can also configure the firewall for specific database

Answer 2

For error "Microsoft.Data.SqlClient.SqlException: 'Cannot open server 'appdb' requested by the login. Client with IP address '..' is not allowed to access the server." Make sure they can gve you a valid login (and its credentials) with permissions to access the database. Let an Azure administrator add your current IP address on the whitelist on Azure SQL firewall as explained **here. SQL Server Contributor role does not grant access to connect to a database hence this permission must be granted within the database using T-SQL statements.

The appropriate role you need to be assigned to list all Azure SQL databases is named "SQL DB contributor". This role will allow you to manage Azure SQL databases but won't give access to them. Make sure they assigned to this role and not to the "SQL Server contributor" by mistake.