When I run a package from our SQL box against our application servers Intergrated Services service, I get the following error:
Message
Executed as user: TOREXWORLD\BPCSqlAdmin. Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 2:02:58 PM Could not load package "\MSDB\Admin_Optimise" because of error 0x80131500. Description: The SQL server 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 2005 Books Online. Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Source: MsDtsSrvr Started: 2:02:58 PM Finished: 2:02:58 PM Elapsed: 0.172 seconds. The package could not be loaded. The step failed.
The package runs ok in Visual Studio on the application server.
Edited by: Simon Hulse on Mar 2, 2009 2:20 PM
And it runs OK if I run it manually in IS on the application server.
Edited by: Simon Hulse on Mar 2, 2009 2:23 PM