Solved

Windows 2003 Registry Read permissions error SQL 2005

Posted on 2010-11-08
1
243 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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Can’t delete a file 14 179
Robocopy Doesn't Retain Shared Folders After Copying 5 78
Sql Server group by 10 44
Hyper-V won't start Server 2003 as a guest OS 7 67
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

839 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