CODEWITHSUNDEEP
sqlsql-server-2008ssis
davey
davey

Reputation: 1564

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?

Upvotes: 4

Views: 12636

Answers (1)

Fearghal
Fearghal

Reputation: 11407

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)

Upvotes: 4

Related Questions