Error when importing data in SQL2005 Express

[runnerlk]

Sqllib error: OLEDB Error encountered calling IDBInitialize::Initialize. hr = 0x80040e4d. SQLSTATE: 42000, Native Error: 18456
Error state: 1, Severity: 14
Source: Microsoft OLE DB Provider for SQL Server
Error message: Login failed for user 'NT AUTHORITY\SYSTEM'.


Any help would be greatly appreciated.

 

[drtree]

Hi,

It looks like the service that is importing the data is using the Local System account (that is, I think, the NT Authority\System account). Did the service used to run under someone else's credentials, or has there been a change in the accounts/security configuration for the target database?

HTH,

Dr Tree