Link to home
Start Free TrialLog in
Avatar of babids
babidsFlag for United States of America

asked on

(ODBC SQLState:42000) Login failed for user (null)

I have a package that run DTS from FoxPro to SQL the packages have been running about 8 months without failure. Now i need to change the schedule on one of the package and got an error like:
Microsoft SQL-DMO (ODBC SQLState:42000) [microsoft] [odbc sql server driver] [sql server] login failed for user '(null)' Reason: Not Associated with trusted SQl Server connection
---*********-------
i login as administrator and login for server agent is also administrator. administrator has complete and unrestricted permissions. Anybody have any ideas whould could be wrong here?
ASKER CERTIFIED SOLUTION
Avatar of xnmb
xnmb

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of CleanupPing
CleanupPing

babids:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.