Unable to create SSISDB

  •  I would like to create SSISDB but even with sa password I see the below error. I am not sure if SSIS is installed so I placed a screenshot above. Is Polybase something new which take care of that? Please advise thank you!

  • The SQL Server is 2016 version.
     Enterprise Edition: Core-based Licensing (64-bit)

  • You need SQL Server Integration Services - which does not appear to be installed. 

    Interesting that everything else seems to be installed though - and you probably don't need even half of what has been installed.

    Are you using SSAS and SSRS on the same server?
    Are you using T-SQL to read data from Hadoop (PolyBase)?
    Are you using or planning on using R (Launchpad)?

    If you are not using these - or plan on using them - then there is no reason to have them installed.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • I figured it out that I might have to install integration services again.

    Yes, SSRS  and we have plan on using others like polybase. 

    Thanks.

Viewing 4 posts - 1 through 3 (of 3 total)

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