Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vivdix
Starting Member
1 Post |
 Posted - 2011-07-01 : 02:53:45
|
| Hi,Few of my maintenance jobs were failing occasionally with the same following reason since last month –“Executed as user: WIN-*******\SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 10.0.2531.0 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 05:40:00 Could not load package "Maintenance Plans\DB" because of error 0xC0014062. Description: The LoadFromSQLServer method has encountered OLE DB error code 0x80004005 (Unable to complete login process due to delay in opening server connection). The SQL statement that was issued has failed. Source: Started: 05:40:00 Finished: 05:40:49 Elapsed: 48.984 seconds. The package could not be loaded. The step failed.”I have read few forums but none have found exact solution of the problem. Can anyone help?Thanks,Vivek |
|
|
YipingLi
Starting Member
3 Posts |
Posted - 2011-08-02 : 01:43:13
|
| I have the same problem too, my job has running for years, recently, this error happened for few times, is anyone can help me to fix it?Executed as user: Account. Microsoft (R) SQL Server Execute Package Utility Version 9.00.5292.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 8:15:07 PM Could not load package "\Maintenance Plans\SSISPackage" because of error 0xC0014062. Description: The LoadFromSQLServer method has encountered OLE DB error code 0x80004005 (Unable to complete login process due to delay in opening server connection). The SQL statement that was issued has failed. Source: Started: 8:15:07 PM Finished: 8:15:40 PM Elapsed: 32.656 seconds. The package could not be loaded. The step failed. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-02 : 02:21:51
|
| did you do any recent sql upgrade or anything on server?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
YipingLi
Starting Member
3 Posts |
Posted - 2011-08-02 : 20:47:58
|
| yes, we had install KB2494123 on our SQL Server. |
|
|
|
|
|
|
SSIS job connection Timeout