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 |
|
collie
Constraint Violating Yak Guru
400 Posts |
 Posted - 2007-12-17 : 11:32:26
|
| I have tried to create a job to run my ssis packages that are also under the File System in Sql Server.However, i get the following message. What could be the problem?ThanksMessageExecuted as user: BS-SERVER\SYSTEM. ...n 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 6:16:09 PM Error: 2007-12-17 18:16:10.26 Code: 0xC0202009 Source: AccountsDim Connection manager "BS-SERVER1\.AHT_DW 1" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D Description: "Login failed for user 'BUSINESS-SOLUTI\BS-SERVER$'.". End Error Error: 2007-12-17 18:16:10.26 Code: 0xC020801C Source: Import AccountsDims_temp OLE DB Destination [901] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "BS-SERVER1\.AHT_DW 1" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method c... The package execution fa... The step failed.Whisky-my beloved dog who died suddenly on the 29/06/06-I miss u so much. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2007-12-17 : 11:51:58
|
| Login failed for user 'BUSINESS-SOLUTI\BS-SERVERthis means there is some problem in logging on to server. Is the login having the required access permissions? |
 |
|
|
|
|
|
Problems with a job