Upgrade your Internet Experience
Microsoft.com
Welcome Sign in
SQL Server Developer Center
Click to Rate and Give Feedback
MSDN
MSDN Library
SQL Server
SQL Server 2005
 Connecting to a Remote Integration ...

  Switch on low bandwidth view
Community Content
In this section
Statistics Annotations (0)
SQL Server 2005 Books Online (November 2008)
Connecting to a Remote Integration Services Server

New: 17 July 2006

Connecting to an instance of Integration Services on a remote server, from SQL Server Management Studio or another management application, requires a specific set of rights on the server for the users of the application.

  1. Open SQL Server Management Studio.

  2. Select File, Connect Object Explorer to display the Connect to Server dialog box.

  3. Select Integration Services in the Server type list.

  4. Type the name of a SQL Server 2005 Integration Services (SSIS) server in the Server name text box.

    Aa337083.note(en-US,SQL.90).gifNote:
    The Integration Services service is not instance-specific. You connect to the service by using the name of the computer on which the Integration Services service is running.

  5. Click Connect.

Aa337083.note(en-US,SQL.90).gifNote:
The Browse for Servers dialog box does not display remote instances of Integration Services. In addition, the options available on the Connection Options tab of the Connect to Server dialog box, which is displayed by clicking the Options button, are not applicable to Integration Services connections.

When a user without sufficient rights attempts to connect to an instance of Integration Services on a remote server, the server responds with an "Access is denied" error message. You can avoid this error message by ensuring that users have the required DCOM permissions.

  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, select Customize, and then click Edit.

  11. In the Access Permission dialog box, add or delete users, and assign the appropriate permissions to the appropriate users and groups.

  12. Click OK to close the dialog box.

  13. Close the MMC snap-in.

  14. Restart the Integration Services service.

  1. Run dcomcnfg.exe at the command prompt.

  2. On the Applications page of the Distributed COM Configuration Properties dialog box, select MSDTSServer and then click Properties.

  3. Select the Security page.

  4. Use the two separate dialog boxes to configure Access Permissions and Launch Permissions. You cannot distinguish between remote and local access - Access permissions include local and remote access, and Launch permissions include local and remote launch.

  5. Close the dialog boxes and dcomcnfg.exe.

  6. Restart the Integration Services service.

If you are working in a local Windows account on a client computer, you can connect to the Integration Services service on a remote computer only if a local account that has the same name and password and the appropriate rights exists on the remote computer.

SQL Server 2005 Integration Services (SSIS) does not support the delegation of credentials, sometimes referred to as a double hop. In this scenario, you are working on a client computer, Integration Services is installed on a second computer, and SQL Server is installed on a third computer. Although SQL Server Management Studio successfully passes your credentials from the client computer to the second computer on which Integration Services is running, Integration Services cannot pass your credentials on from the second computer to the third computer on which SQL Server is running.

Release History

15 September 2007

Changed content:
  • Updated procedure about how to configure rights for remote users.
Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
Helpful information from the newsgroups...took me a few to find it.      Marvin Bobo ... Đonny   |   Edit   |   Show History

Copied from this newsgroup post:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=701950&SiteID=1

I believe I got it to work...

One the webpage http://msdn2.microsoft.com/en-us/library/aa337083.aspx, under "To configure rights for remote users on Windows Server 2003"...

replace step 9 with "Click OK to close the dialog box."
Add a step 9.1 with the following text: "On the same Security tab, under Access Permissions, select Customize, then click Edit to open the Access Permission dialog box."
Add a step 9.2 with the following text: "In the Access Permission dialog box, add or delete users, and assign the appropriate permissions to the appropriate users and groups. The available permissions are Local Access, and Remote Access. The easiest is to add the local DCOM Distributed Users group. "
Add a step 9.3 with the following text: "Click OK to close the dialog box. Close the MMC snap-in."
Step 10 stays as-is: "Restart the Integration Services service."

[taiyee -- MSFT] Thanks, I have submitted this feedback to the SQL Server documentation team.

See Also      Jason H - SQL   |   Edit   |   Show History
http://support.microsoft.com/?id=940232

Step 3 has helped some people as well.

3.On the server, add the user account to the Distributed COM Users group. To do this, follow these steps: a. Click Start, click Run, type lusrmgr.msc, and then click OK.b. In the Local Users and Groups dialog box, click Groups, and then double-click Distributed COM Users.c. In the Distributed COM Users Properties dialog box, click Add.d. In the Select Users dialog box, type the user name under Enter the object names to select, and then click OK two times.
Tags What's this?: dcom (x) seealso (x) ssis (x) Add a tag
Flag as ContentBug
© 2009 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker