<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
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?<br />
<br />
<br />

<pre><code class="code-1 nolinks" id="code-1280352"><span>exec master.dbo.xp_regread </span>
<span>        N'HKEY_LOCAL_MACHINE',N'SOFTWARE\PH_application\IHS Default UOM',N'Weight'</span>
</code></pre>
</div>
</div>


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?



Windows 2003 Registry Read permissions error SQL 2005

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Windows Server 2003 was based on Windows XP and was released in four editions: Web, Standard, Enterprise and Datacenter. It also had derivative versions for clusters, storage and Microsoft’s Small Business Server. Important upgrades included integrating Internet Information Services (IIS), improvements to Active Directory (AD) and Group Policy (GP), and the migration to Automated System Recovery (ASR).