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 |
|
urbanmojo
Starting Member
5 Posts |
 Posted - 2010-02-25 : 09:55:36
|
| Hi:I have a customer still using some work we did for them in DTS and SQL server 2000. Suddenly a package started failing out of nowhere. It fails on the first SQL Task, which connects to both the database specified in the connection object as well as a linked server using a fully qualified link to that server. It runs fine when run manually--typical storyA domain account runs the SQL Agent service and that user is mapped to a regular SQL Account in the linked server properties. The error I get is:DTSStep_DTSExecuteSQL Task_1, Error = -2147217900 (80040E14) Error String: Login failed for user'(null)'. Reason: not associated with a trusted SQL connectionnot sure why I would get that error--that account is setup on the local sql server in the correct database, and as for the remote server, I have mapped the user to a local sql account so it shouldn't need that account to be set up there. And it has been working fine like this.Any ideas? |
|
|
|
|
|
Trusted connection and SQL Server