Post reply

Unable to access SQL Server Integration Services

  • July 30, 2009 at 2:10 pm

    #224315

    Hi,

    I am not able to connect to SQL Server Integration Services even though my login has sysadmin rights in the SQL Server

    Could somebody help on this ?

  • July 30, 2009 at 2:11 pm

    #1032665

    Are you trying to connect via SSMS? What happens?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • July 30, 2009 at 2:12 pm

    #1032666

    Yes, I am getting the following error

    Connect to SSIS Service on machine "server1" failed:

    Access is denied.

    Connect to SSIS Service on machine "server1" failed:

    Access is denied.

  • July 30, 2009 at 2:16 pm

    #1032668

    Try to walk through this and see what happens:

    http://totaldevpro.com/blogs/khaselden/archive/2009/04/09/connecting-to-a-remote-ssis-server.aspx

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • July 30, 2009 at 2:18 pm

    #1032669

    Another one from Microsoft:

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

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • July 30, 2009 at 2:25 pm

    #1032674

    Thanks for your replies. Unfortunately, I can't connect to the server physically in order to do the windows admin settings. I only have FULL access to sql server

  • July 30, 2009 at 2:29 pm

    #1032680

    Were you ever able to connect?

    It sounds like you'll need to get someone involved who has server admin rights to help go through the troubleshooting list.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • July 30, 2009 at 2:36 pm

    #1032685

    I was able to connect thru my manager's system. He has full access to remotely login into the physical server. Now, he is not available and I need to connect to SSIS to deploy my package

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply