Azure Portal - Cannot access SQL Server Database

1
votes

I created a SQL Server Instance and Database through Azure. Then over the course of development I deleted and recreated that database through SQL Management Studio. I can still see the Database under the SQL Server Instance but when I click on it I get:

Access denied
You do not have access
Looks like you don't have access to this content. To get access, please contact the owner.

Note: This only occurs on the new Azure Portal. The old one works fine, but it will soon be going away.

Any idea what I need to do to get access in the new Azure Portal

1
azureazure-sql-databaseazureportal

1 Answers

0
votes

I wasn't even aware you could delete and create Azure SQL Databases from SSMS...

I'm guessing it has created the DB with different credentials then. If you have Owner/Contributor/Reader role in the resource group where the DB is you should be able to access it. Even more so if you have one of those roles on the subscription/are an admin.

You need to check your roles.