Cant access SSIS packages in MSDB folder via SSMS

  • 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?

  • Is the SQL Server service running? What port does it listen on?

    John

  • Yes SQL Server Integration Services is running, how do i check what port its running on? after some googling it seems it can only run on port 135?

  • I had to create a login for the windows admin user in SQL with permissions to the MSDB

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

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