User can't access db under current security context

Question

User can't access db under current security context

Eric L 0

I am receiving the following error when attempting to connect to a database that I just created yesterday, however clearly there is some default setting for security that is blocking my access. I have no idea how to resolve this issue. Can someone help?

WHY IS THE AI BASED TOOL MARKING MY CONTENT AS AGAINST CODE OF CONDUCT BECAUSE I PASTED THE EXACT CONTENT OF THE ERROR MESSAGE?

Anonymous

2025-03-24T03:45:03.45+00:00

Hi Eric L

In addition to the answer provided by @Amira Bedhiafi, could you please provide me with more details regarding whether the newly created database is under Azure SQL Managed Instance or Azure SQL Database?.

1 answer

Your answer

Anonymous

2025-03-24T03:45:03.45+00:00

Hi Eric L

In addition to the answer provided by @Amira Bedhiafi, could you please provide me with more details regarding whether the newly created database is under Azure SQL Managed Instance or Azure SQL Database?.

Answer 1

Amira Bedhiafi 41,721 MVP Volunteer Moderator

Hello Eric !

Thank you for posting on Microsoft Learn.

Did you create the Azure SQL Server yourself? If so, the login you created during provisioning should be the server admin.

If you're using Azure Active Directory (AAD) for login, ensure your user is properly added to the database with correct roles (db_owner...).

If you are the server admin, connect to the master database and run this to grant yourself access to the new DB:

CREATE USER [your_user] FROM LOGIN [your_user];

ALTER ROLE db_owner ADD MEMBER [your_user];

Or, switch to the target database and run:

CREATE USER [your_user] FROM LOGIN [your_user];  

ALTER ROLE db_owner ADD MEMBER [your_user];

If you're using AAD:

CREATE USER [******@domain.com] FROM EXTERNAL PROVIDER;

ALTER ROLE db_datareader ADD MEMBER [******@domain.com];

ALTER ROLE db_datawriter ADD MEMBER [******@domain.com];

If you want to verify with the Azure Portal, go to your Azure SQL server resource > Active Directory admin and check if your account is set as admin.

You can also check SQL users and permissions from the Azure Portal (under the database > Query editor (preview)) if you can log in there.

Anonymous

2025-03-24T01:11:31.4+00:00

Hi Eric L

Just checking in to see if the Above answers provided by @Amira Bedhiafi helped.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Anonymous

2025-03-25T01:39:24.6466667+00:00
Hi Eric L

We would like to thank you for your feedback provided in the survey. We noticed that your recent engagement on this question was rated low. However, we would appreciate it if you could provide some additional details regarding whether the newly created database is under Azure SQL Managed Instance or Azure SQL Database. Additionally, if possible, please include any specific error number or error message, as this would be helpful for us in troubleshooting the issue.

Kindly provide the following details:

Is the newly created database under Azure SQL Managed Instance?

Is it under Azure SQL Database?

If possible, could you please provide any error messages or error numbers?
Anonymous

2025-03-25T06:37:24.9166667+00:00
Hi Eric L

We would like to thank you for your feedback provided on survey. We found your recent engagement on this question was rated low. However, we were able to share some additional information that could helped in the below comment. Would you please re-evaluate your feedback

Please run the following query and let’s try to find evidence about the Azure SQL Database being throttled.

SELECT *

FROM sys.dm_db_resource_stats ORDER BY end_time DESC;

If you see avg_log_write_percent is close or equal 100% you need to scale up the tier of the database.

What about the DTU graph on the portal? Please verify if consumption of resources is reaching the limits of the tier since you added the data sync process.

You can run the following query also to verify throttling occurs.

SELECT

(COUNT(end_time) - SUM(CASE WHEN avg_cpu_percent > 80 THEN 1 ELSE 0 END) * 1.0) / COUNT(end_time) AS 'CPU Fit Percent', (COUNT(end_time) - SUM(CASE WHEN avg_log_write_percent > 80 THEN 1 ELSE 0 END) * 1.0) / COUNT(end_time) AS 'Log Write Fit Percent', (COUNT(end_time) - SUM(CASE WHEN avg_data_io_percent > 80 THEN 1 ELSE 0 END) * 1.0) / COUNT(end_time) AS 'Physical Data Read Fit Percent' FROM sys.dm_db_resource_stats

service level objective (SLO) of 99.9% <= go to next tier

When avg_log_write_percent is at 100% or near 100% then throttling occurs.

Auto-pause only occurs if the database is an Azure Serverless database, the other Azure SQL flavors do not support auto-pause.

I hope, this response will address your query and helped you to overcome on your challenges
Anonymous

2025-03-26T11:31:12.4033333+00:00

Hi Eric L

We found your recent engagement on this question was rated low. However, we were able to share some additional information that could helped in the above comment. Would you please re-evaluate your feedback.
Anonymous

2025-03-27T09:29:21.6533333+00:00

Hi Eric L

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Share via

User can't access db under current security context

1 answer

Your answer