We are having a strange problem since a few weeks.
We have a DTS package, where we copy data with a "copy sql server objects" task from one database into another one.

Follwoing situation :
Backend DB-Name : backend (user : back -> default db = backend)
Frontend DB-Name : frontend (user : front -> default db = fronend)

The DTS package has been working fine since months. Since a few weeks we receive an error, while executing, it says, that the user back is no valid user in the clubnatique db.

Strange, as in the user settings the default db of the user back is backend. Also in the task user and password are set correctly and explicitly the backend database is selected!

When we reboot the sql server machine, the problem is gone for a while.

Does anyone has any idea?

We are running sql server 2000.

Any help would be appreciated
[email protected]