Link to home
Start Free TrialLog in
Avatar of Member_2_7966113
Member_2_7966113

asked on

Azure SQL Database Access Denied

Hello Experts,

I have just created a Azure SQL Database. I think connect to the database via Microsoft SQL Server Management Studio as Administrator, but I keep on getting the message shown in the image. Even though I created the database.. can someone let me know how to get around this issue?

User generated image
Cheers
ASKER CERTIFIED SOLUTION
Avatar of Pawan Kumar
Pawan Kumar
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Member_2_7966113
Member_2_7966113

ASKER

Hi Pawan

Thanks for responding.

I only have one database
Hi Pawan,

In the document it states
If you forget your server login information, navigate to the SQL Database server page to view the server admin name

I can't see where I can find the server admin name?
Check in the azure.
ok, so I've got the server admin login, but I'm still getting the same message
same error?
yes, same error
Ahhhh...

Just found out the problem. I was attempting to create a table in the system database as opposed to the database I created, see image.

User generated image
Thanks Pawan
Avatar of Pushpakumara Mahagamage
log on your azure portal
Go to SQL Databases ----> and Then your database
and find connection string and click it, there you can find the username.

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-manage-logins