SQL script gets 'Access denied' to write a registry key value during SESSION 0

hello,

on windows 2008 r2 ps1 server, ms sql server 2005.

running installation (*.msi), performing sql script writes value registry key:

- running user administrative rights, logged in - writing registry succeed;

- running during session 0 (no logging in) as temporary user, impersonated administrator - writing registry fails - "access denied".

what cause denial?

any suggestions appreciated,

sergy s.

first of all, thank attention , time. appreciate that.

additional information regarding issue:

the msi log error is:

"error 27506: error executing script _105_set_login_auditing.sql. line 26. regcreatekeyex() returned error 5, 'access denied.' (22002)"

the script 26 line is:

"exec xp_instance_regwrite n'hkey_local_machine', n'software\microsoft\mssqlserver\mssqlserver', n'auditlevel', reg_dword, 3"

(please assume there no syntax errors in quotation marked text - it is typed manually, since copy-paste disabled here.)

hi  savser,

based on error message, suggest running msi file administrator.
please right click msi file , select ”run administrator”.
additionally, want confirm did msi file, please post full name , download link here analysis. if application sql server related, please check sql server installation log located at” %programfiles%\microsoft sql server\90\setup bootstrap\log” directory ,select latest installation log. find registry key name don’t have permission access, , take permission of  registry key opening “run” application ( use shortcuts ”windows+r”  ) , input ”regedit”, click”ok”, find particular registry key ,right click located registry folder, select “permissions” ,grant proper permission folder.

thanks,
candy zhou

SQL Server  >  SQL Server Database Engine