Solved

Windows 2003 Registry Read permissions error SQL 2005

Posted on 2010-11-08
1
241 Views
Last Modified: 2012-05-10
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

0
Comment
Question by:vg30e
1 Comment
 
LVL 10

Accepted Solution

by:
Humpdy earned 500 total points
ID: 34085694
yup...run it under local admin a/c that has access to it.
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

778 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question