chandradineshbabu
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.dt sx, 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
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_
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
So ... did my comment help? 'Excellent thought' implies that it did.
ASKER
Excellent thought
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.