首页 > itarticle > ssis cannot import package

ssis cannot import package

admin 11月 13, 2020 0

Error:

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)

Solution:

Add the user XXXX as a login to the SQL server
with sys_admin rights to msdb