Hi, anyone can help me with this problem:
I tried to create a DTS to copy sql server objects from
one server to another. But at the end of the
transformation, it gives me this error message :"Windows
NT user or group 'XXX\XXX' not found. Check the name
again." Then I tried to create a DTS to transfer logins
task which brought me another erroe message:"Your SQL
Server Service is running under the local system account.
You need to change your SQL Server Service account to have
the rights to copy files over the network." What am I
suppose to do with this? I tried to get into the SQL
server properties(configure). But I don't know where to
go exactly to make the change. I'm already the system
admins of the two sql servers and my local computer.
Thank you in advance.