client ip does not access server

Moshe Raab 21 Reputation points
2021-10-27T19:29:12.9+00:00

i had my client create an Azure account and an SQL database
I also had him add me as a user (so there are now two users)

let's say that his email is name@keyman .com. that is the user id he uses to log in to the azure portal
my user account was created as myuser@namedomain.onmicrosoft.com

I am able to access the portal. HOWEVER, i cannot see any of the resources including the Server and Database he created

When I try to access the DB with SSMS, I get an error: Your client Ip Address does not have access to the server. Sign in to the Azure account and create a new firewall rule to enable access.

I can log in but I cannot see any of the resources.

What do i need to do to be able to configure Azure to give me access so that I can build the DB and allow my application to access it.

Azure SQL Database
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
19,668 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anurag Sharma 17,576 Reputation points
    2021-10-28T06:25:09.26+00:00

    Hi @Moshe Raab , welcome to Microsoft Q&A forum.

    There are 2 parts to your query, let me try to address them one by one.

    1). Not able to see the Server and Database through Azure Portal: Your client has created a new user but they have to add your user name to subscription under certain role. As all the resources(like Azure SQL Database etc.) are tied up to the resource group which is then tied up to Subscription, so if a specific user is not added to Subscription, we will not be able to see any of those resource. Please ask your client to add you to it.
    Refer to this link:
    Assign Azure subscriptions to your customers

    144444-image.png

    2). Access the database from SSMS: After adding the user to subscription, when we try to connect the SSMS to Azure SQL Server we need to add the ip to firewall rule by logging in with same user. As now you have the access to subscription you should be able to see the database through SSMS as well.

    Please let me know if this helps or in case you face any other issue I will be delighted to assist further.

    ----------

    Please don't forgot to click on accept it as answer button 144380-image.png wherever the information provided helps you. This can be beneficial to other community members as well.