locked
SQL 2014 Cant access SSIS through Mgmt studio RRS feed

  • Question

  • Im remoted into the server, yet on this server which ive not used before, is not letting me connect to SSIS through SSMS.  I get "access denied. The SSIS service is running under an account that is also in the local admin group.

    I added myself to the local admin group, restarted sql, agent and ssis services, yet I still get the message. 
    Time to bounce the server?  Nevermind, did that.  Tried again after rebooting, same thing.  Access denied


    Followed this example, at least up to the point of looking for MsDtsServer100 within component services.   Could not locate that.  Time to repair this installation?
    https://www.mssqltips.com/sqlservertip/3086/how-to-resolve-ssis-access-denied-error-in-sql-server-management-studio/


    • Edited by shiftbit Wednesday, June 20, 2018 5:10 PM dfg
    Wednesday, June 20, 2018 4:32 PM

All replies