March 28, 2018 at 3:52 pm
When running a SQL Server agent job by right-clicking it and choosing to Start at Step 1, the following message appears:
Could not load package "\MSDB\Import Opening Balance Into f_Trans_GL_Detail" because of error 0xC00160AE. Description: Connecting to the Integration Services service on the computer "GALAXY1" failed with the following error: "Access is denied."I can log into SQL Server Integration Services and run the integration package.
I've started SSMS as a domain Administrator.
I've walked through steps regarding setting permissions for DCOM components.
I don't know what else to check to get past this message.
Thank you for any help.
March 29, 2018 at 11:16 am
Does the agent account have rights to do this? Quick test, set the agent to run under your account.
March 30, 2018 at 2:09 pm
Something I wrote up years ago, not sure if you tried this but could not hurt to post:
To connect to Integration Services on a Remote Server
The server responds with an "Access is denied" error message.
1. If the user is not a member of the local Administrators group, add the user to the Distributed COM Users group. You can do this in the Computer Management MMC snap-in accessed from the Administrative Tools menu.
2. Open Control Panel, double-click Administrative Tools, and then double-click Component Services to start the Component Services MMC snap-in.
3. Expand the Component Services node in the left pane of the console. Expand the Computers node, expand My Computer, and then click the DCOM Config node.
4. Select the DCOM Config node, and then select MsDtsServer in the list of applications that can be configured.
5. Right-click on MsDtsServer and select Properties.
6. In the MsDtsServer Properties dialog box, select the Security tab.
7. Under Launch and Activation Permissions, select Customize, then click Edit to open the Launch Permission dialog box.
8. In the Launch Permission dialog box, add or delete users, and assign the appropriate permissions to the appropriate users and groups. The available permissions are Local Launch, Remote Launch, Local Activation, and Remote Activation. The Launch rights grant or deny permission to start and stop the service; the Activation rights grant or deny permission to connect to the service.
9. Click OK to close the dialog box.
10. Under Access Permissions, repeat steps 7 and 8 to assign the appropriate permissions to the appropriate users and groups.
11. Close the MMC snap-in.
12. Restart the Integration Services service.
Also check to make sure the server name is in the ini.xml file.
F:\Program Files\Microsoft SQL Server\100\DTS\Binn\ MsDtsSrvr.ini.xml
<?xml version="1.0" encoding="utf-8"?>
<DtsServiceConfiguration xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<StopExecutingPackagesOnShutdown>true</StopExecutingPackagesOnShutdown>
<TopLevelFolders>
<Folder xsi:type="SqlServerFolder">
<Name>MSDB</Name>
<ServerName>SERVERNAME\WITHINST</ServerName>
</Folder>
<Folder xsi:type="FileSystemFolder">
<Name>File System</Name>
<StorePath>..\Packages</StorePath>
</Folder>
</TopLevelFolders>
</DtsServiceConfiguration>
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply