Windows authentication windows user rights

Question

When we use windows authentication in sql server management studio. Does user account which used to get logged into, account type put impact on user authorization.

I use windows authentication to logged into sql management studio, But unable to change sa password and sql authentication mode to sql and windows. I am getting permission related error:

For authentication mode.

The EXECUTE permission was denied on the object 'xp_instance_regwrite', database 'mssqlsystemresource', schema 'sys'.`

For sa password change

Cannot alter the login 'sa', because it does not exist or you do not have permission.

Below image shows the permission of windows user.

Below is permission

I ran sql management studio as administrator, but that also did not help. — Rudra
Which user do you use when logging in? Can you share its permissions? (check both login and database user) — Alexei - check Codidact
I have edited question to show permission, SqlServer is a fresh install and only have system database, Before creating any new database i want to change sa password and authentication mode to mix mode. — Rudra
It would be more relevant to show the permissions of the user you have used to login it (your windows user). — Alexei - check Codidact

Genish Parvadia Genish Parvadia · Accepted Answer · 2016-12-20T08:21:58

this type issue is GRANT Permission Issue

// grant the user directly access to the procedure

Grant Execute ON [sys].[xp_instance_regread] TO [DOMAIN\USER];

//to check and verify that  the user has the privilege granted to him

EXECUTE AS USER = ‘DOMAIN\USER’;Select * from fn_my_permissions(‘xp_instance_regread’,’Object’)

Go

OR

USE DatabaseName;
SELECT * FROM fn_my_permissions (NULL, 'DATABASE');
GO

Reference

Windows authentication windows user rights

2 Answers