babids
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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.