Menu
I don't think this question has been answered, apologies if I've missed a thread.
In short, I've performed a vanilla install of a SQL 2012 and SSIS on my local machine. I've configured SSIS to run with the NT AUTHORITY\Local Service account (also tried my local login), and am running SSMS under my local login (I'm a local admin). SQL instance is running as NT Service\MSSQLSERVER.
I can access Integration Services in the object explorer and run packages using the GUI. However, when calling from code, I get the following:
Could not load package "\MSDB\FileLoad\CustomerMaster_Customer" because of error 0xC00160AE. Description: Connecting to the Integration Services service on the computer "UKLT-RHE-1" failed with the following error: "Access is denied."
By default, only administrators have access to the Integration Services service. On Windows Vista and later, the process must be running with administrative privileges in order to connect to the Integration Services service. See the help topic for information on how to configure access to the service.
Any help is muchly appreciated!!
Thanks in advance,
Rich
437
Right-click on it and choose "Properties". Here we should set "Launch and Activation Permissions" and "Access Permissions" for our user. Click "Edit" on "Launch and Activation Permissions". Hence, the problem is solved, and the user can work with SQL Server Integration Services using SQL Server Management Studio.
To grant access to the Integration Services serviceRight-click Microsoft SQL Server Integration Services 13.0, and then click Properties. On the Security tab, click Edit in the Launch and Activation Permissions area. Add users and assign appropriate permissions, and then click Ok.
Go to Connect to Server and select the Server Type as Integration Services and give the Server Name then click connect. Go to Object Explorer on the left corner. You can see the Stored Package folder in Object Explorer. Expand the Stored Package folder, here you can see the SSIS interfaces.
You access the SSISDB catalog in SQL Server Management Studio by connecting to the SQL Server Database Engine and then expanding the Integration Services Catalogs node in Object Explorer. You access the SSISDB database in SQL Server Management Studio by expanding the Databases node in Object Explorer.
Fixed it..!
http://msdn.microsoft.com/en-us/library/hh213130.aspx
N.B. Step 6 - Repeat steps 4 - 5 for Access Permissions.
HTH someone!
50
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
