Cant access SSIS packages in MSDB folder via SSMS

10,674

add the user as a login to the SQL server with sys_admin rights to msdb (taken from last comment in reply to the original question, by davey, @june 19th at 21:54which worked for me - this is the answer)

Share:
10,674

Related videos on Youtube

davey
Author by

davey

Updated on June 25, 2022

Comments

  • davey
    davey almost 2 years

    The SQL Server instance specified in SSIS service configuration is not present or is not available. This might occur when there is no default instance of SQL Server on the computer. For more information, see the topic "Configuring the Integration Services Service" in Server 2008 Books Online.

    Login failed for user 'XXXXX'. (MsDtsSrvr)

    After connecting to Intergation Services on the server, I get the above error error message when i try open the MSDB folder under Stored Packages. This is a default instance of SQl server. I've checked the MsDtsSrvr.ini.xml file and all looks fine. The user has access to MSDB system tables. Can anyone recommend any thing else to check?

    • davey
      davey over 11 years
      I had to add the user as a login to the SQL server with sys_admin rights to msdb