Post reply

Cannot connect to SSIS from SSMS

  • June 6, 2008 at 11:13 am

    #187723

    I am using SP2 and cant connect to SSIS from SSMS. Also, I have another problem. I try to connect to Integration services using SSMS and want to connect using sql server authentication. Its not even allowing me to go to that option. Its like disabled. Though I can connect to database services using sql server authentication. Any help would be a lot of help.

    Thanks in advance,

    NIkhil Parsi

  • June 6, 2008 at 11:38 am

    #825619

    See reply here:

    http://www.sqlservercentral.com/Forums/Topic512974-148-1.aspx#bm513016

    Greg

  • June 6, 2008 at 11:45 am

    #825626

    Thanks for the reply,

    But if that is the case, why do they even have it in SSMS? I thought it is there for a reason. I mean I could login and execute it as a sysadmin but cant do it without that permission. If you guys know anything else, it will be helpful.

    N

  • June 6, 2008 at 2:24 pm

    #825716

    You can connect if you have a Windows account with the correct permissions (and that's the account you start up SSMS with). So you can manage SSIS from SSMS, you just must do so with a Windows account.

    K. Brian Kelley
    @kbriankelley

  • June 12, 2008 at 3:23 am

    #827715

    For connecting remotely using SSMS you need to have configured permissions to the DCOM config node and provide access permissions to connect to SSIS. Refer this link for more info,

    http://deepakrangarajan.blogspot.com/2008/03/connecting-to-integration-service-on.html

    [font="Verdana"]- Deepak[/font]

  • October 6, 2009 at 3:09 am

    #1062130

    Thanks Deepak

    Just had the same problem on one of our servers and your blog fixed it for me 🙂

  • September 3, 2013 at 1:29 am

    #1646890

    Deepak ,Kindly provide alternative link for your blog ,bcz older one is no more active

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

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