Windows 2003 Registry Read permissions error SQL 2005

Hello,

I am trying to read a registry key using the SQL server process. The SQL server is configured to run as the local system. When using the SQL server management studio and the following commands, I get these results. Should I try to run the SQL server under some other account?


exec master.dbo.xp_regread 
        N'HKEY_LOCAL_MACHINE',N'SOFTWARE\PH_application\IHS Default UOM',N'Weight'

Open in new window

vg30eAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
HumpdyConnect With a Mentor Commented:
yup...run it under local admin a/c that has access to it.
0
All Courses

From novice to tech pro — start learning today.