How to fix RegCreateKeyEx() returned error 5, 'Access is denied.' in SQL Server 2017

ddrv8njm 于 2023-06-04 发布在 SQL Server

关注(0)|答案(2)|浏览(228)

I am trying to change auth mode to mix mode with following command in SQL Server 2017:

EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', 
                 N'SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQLServer', 
                 N'LoginMode', REG_DWORD, 2

I have executed this command so far:

EXEC sp_addsrvrolemember 'NT AUTHORITY\SYSTEM', 'sysadmin';
GRANT EXECUTE ON xp_instance_regwrite TO public

After restarting SQL Service I still get this error:

RegCreateKeyEx() returned error 5, 'Access is denied.'

I have given all permissions to all users in SQL, is this something to do with SQL or Windows and how am I able to fix it?

sql-server

来源：https://stackoverflow.com/questions/55416987/how-to-fix-regcreatekeyex-returned-error-5-access-is-denied-in-sql-server

2条答案

按热度按时间

s4chpxco1#

For me to work I had do change the user witch executes SQL Background Service. Click on Windows -> search for Services and locate MS SQL Server and right click and change properties , at this place you can change sql user to someone with admin permission. not the best way, but it worked.

赞(0）回复(0）举报 2023-06-04

pgpifvop2#

This error happens if SQL server cannot change service properties.

You can manually change SQL Server Agent startup type from services as below :