Connection to Integration Service Failed

  • yrstruly

    SSCrazy

    Points: 2815

    D46ONo5XkAAlcOND47bR60XoAgkPwz

    I am using a trial of SQL Server 2017.  SSIS worked. Untill i change Log On As to Local Service. Please help?

  • Tim Mitchell

    SSCoach

    Points: 15653

    Starting in SQL Server 2012, you no longer connect to Integration Services directly like you would in prior versions. It is now accessible as a node in the connection to the SQL Server database engine, under the heading Integration Services Catalogs.

    If you've not used the SSIS catalog before, I have an introduction video here.

    I hope this helps!

    • This reply was modified 6 months, 3 weeks ago by  Tim Mitchell.

    Tim Mitchell, Microsoft Data Platform MVP
    Data Warehouse and ETL Consultant
    TimMitchell.net | @Tim_Mitchell | Tyleris.com
    ETL Best Practices

  • Thom A

    SSC Guru

    Points: 98407

    Got to love a photograph of a screen. As an FYI there is a Screenshot button on your keyboard, it's normally located on the right hand side, above the Insert Key. You can press that to take a screenshot of your whole screen. Alternatively you can press Alt+Print Screen and it'll capture your current active window. You can then paste the image into something like Paint and save for upload. That dialogue box also has a copy button in the bottom left to copy the text (which would make it much easier for us to read).

    Why did you change the Log on details of the service? Are you trying to have it run as a different account? Have a look in the Event Viewer, which should give you a concise error of why the service failed to start and paste the error here (please don't take pictures of your screen, they are very hard to read. Text is best!).

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.

  • yrstruly

    SSCrazy

    Points: 2815

    1556122085644-2105061975

    Is this it? Do i not have to worry further?

  • Tim Mitchell

    SSCoach

    Points: 15653

    Yes, that's where the SSIS catalog will reside. It looks like you haven't yet created an SSIS catalog on that instance. You'll need to first create the SSIS catalog before you can deploy or execute any packages from there.

    Tim Mitchell, Microsoft Data Platform MVP
    Data Warehouse and ETL Consultant
    TimMitchell.net | @Tim_Mitchell | Tyleris.com
    ETL Best Practices

  • Thom A

    SSC Guru

    Points: 98407

    yrstruly wrote:

    1556122085644-2105061975 Is this it? Do i not have to worry further?

    /Facepalm

     

    Please; screenshots, not photos. ??

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.

  • Brandie Tarvin

    SSC Guru

    Points: 172542

    Tim Mitchell wrote:

    Starting in SQL Server 2012, you no longer connect to Integration Services directly like you would in prior versions. It is now accessible as a node in the connection to the SQL Server database engine, under the heading Integration Services Catalogs. If you've not used the SSIS catalog before, I have an introduction video here. I hope this helps!

    Ummmm. Since when doesn't SQL 2012 have access to Integration Services as a separate connection?

    We use SQL 2012 and connect to Integration Services separately all the time. And no, we don't use the Catalogs. We upload our packages to SQL Server. We've never had an issue.

    Of course, I haven't worked extensively in SQL 2017 yet. So I don't know how SSIS works in it.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • Tim Mitchell

    SSCoach

    Points: 15653

    You *can* connect using the legacy Integration Services connection in SSMS, but only for packages that are deployed to MSDB. I rarely see packages deployed to MSDB in 2012 in newer since the SSIS catalog is far easier for managing server-deployed packages.

    Tim Mitchell, Microsoft Data Platform MVP
    Data Warehouse and ETL Consultant
    TimMitchell.net | @Tim_Mitchell | Tyleris.com
    ETL Best Practices

  • Thom A

    SSC Guru

    Points: 98407

    Brandie Tarvin wrote:

    Ummmm. Since when doesn't SQL 2012 have access to Integration Services as a separate connection? We use SQL 2012 and connect to Integration Services separately all the time. And no, we don't use the Catalogs. We upload our packages to SQL Server. We've never had an issue. Of course, I haven't worked extensively in SQL 2017 yet. So I don't know how SSIS works in it.

    I haven't got to use 2014+ yet, but I'm not aware they've removed the Integration Services Service as yet; I don't even think it's deprecated either.

    You do, however, have to use the correct version of SSMS to connect to the SSIS service. So, you have to use SSMS 2012 to connect to SSIS 2012, SSMS 2014 for SSIS 2014, etc, etc. Not sure why SSMS doesn't support the other versions, as I'm pretty sure that you can connect to any version of SSRS that is on a supported version of SQL Server (for that version of SSMS). I have no idea about SSAS though, but I don't recall reading anything about it not being back compatible.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.

  • Brandie Tarvin

    SSC Guru

    Points: 172542

    Tim Mitchell wrote:

    You *can* connect using the legacy Integration Services connection in SSMS, but only for packages that are deployed to MSDB. I rarely see packages deployed to MSDB in 2012 in newer since the SSIS catalog is far easier for managing server-deployed packages.

    Well we're getting ready to upgrade to SQL 2017. I guess I need to play around with the catalog to see if it works for our deployment scenarios or not.

    Thank you for verifying.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 10 posts - 1 through 10 (of 10 total)

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