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?
Cheers
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?
Cheers
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Pawan,
In the document it states
I can't see where I can find the server admin name?
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.
ASKER
ok, so I've got the server admin login, but I'm still getting the same message
same error?
ASKER
yes, same error
ASKER
ASKER
Thanks Pawan
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
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
ASKER
Thanks for responding.
I only have one database