Extended SP cannot read registry

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Extended SP cannot read registry

Author

Topic

hrishi_des
Yak Posting Veteran

76 Posts

Posted - 2007-02-19 : 04:23:17

Hi,
I am trying to use master.dbo.xp_regread to access registry, it is giving me this error.
xp_regread() returned error 5, 'Access is denied

The sql user has server role: bulkadmin and has db_owner role membership on Database.

I am able to acces registry when i use sa user account i.e. server role sysadmin.

Many Thanks,
Hrishikesh

When solution is simple, God is answering….

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-02-19 : 04:29:50

Are you trying to read local registry or a remote registry?

Peter Larsson
Helsingborg, Sweden

hrishi_des
Yak Posting Veteran

76 Posts

Posted - 2007-02-19 : 04:41:42

Hi,

I want to read registry of machine on which sql server is installed using master.dbo.xp_regread ( so i guess this is "local" to the sql server)

Thanks,
Hrishikesh

When solution is simple, God is answering….

hrishi_des
Yak Posting Veteran

76 Posts

Posted - 2007-02-20 : 02:36:22

Hi,

I tried giving following permission to the user, nut still it gives same error...

USE MASTER
GRANT EXECUTE ON OBJECT::master.dbo.xp_regread To TEST

Many Thanks,
Hrishikesh

When solution is simple, God is answering….

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources