asked on

SSIS permission error

I am getting the following error

Executed as user: NAM\SqlAdmin001. Microsoft (R) SQL Server Execute Package Utility Version 11.0.3381.0 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 10:55:37 AM Failed to execute IS server package because of error 0x80131904. Server: MATLKTBATSQD001,14330, Package path: \SSISDB\Flex4Cast\F4C\tmp_F4C_ETL.dtsx, Environment reference Id: 2. Description: The EXECUTE permission was denied on the object 'xp_regread', database 'mssqlsystemresource', schema 'sys'. Source: .Net SqlClient Data Provider Started: 10:55:37 AM Finished: 10:55:37 AM Elapsed: 0.125 seconds. The package execution failed. The step failed.

I searched in the web and found that hot fix from the Microsoft

http://support.microsoft.com/kb/2720171

however my server sql version is sql server 2012 sp1 CU6

I tried in many ways but could not find any solution

Could you please provide me the workaround for this

Jim Horn

<Potentially stupid answer, since no one else has responded>
You'll want to eyeball what user will run the SSIS package, and manually attempt to execute xp_regread, to see if it's GRANTed to that user.

It's pretty typical of a DBA to deny such privs.

ASKER CERTIFIED SOLUTION

chandradineshbabu

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Jim Horn

So ... did my comment help? 'Excellent thought' implies that it did.

chandradineshbabu

ASKER

Excellent thought