Login Problem

HI,
I handle three Production database (England,Grmany and Australia).
In one of the location i had created a user rep_process and given the
permission on the production database.
Now from thailand i am tranferring a object using DTS tasks(copy sql
server objects) from the production server in which i had created a
user rep_process.I connects successfully to that server from the task .
but when i execute the dts it gave me an error that rep_user does not
exists.
Does that means that i rep_user does not exists on the local database.
Or some other problem.
pls help
hope u understand.
from
Dollerdoller
I did some testing and it worked just fine
What login/pass have you specified on source and desitnation server. Have
you connect successfully ?
Whe did you get the error? on what stage?
"doller" <sufianarif@.gmail.com> wrote in message
news:1125988323.938071.61480@.g44g2000cwa.googlegroups.com...
> HI,
> I handle three Production database (England,Grmany and Australia).
> In one of the location i had created a user rep_process and given the
> permission on the production database.
> Now from thailand i am tranferring a object using DTS tasks(copy sql
> server objects) from the production server in which i had created a
> user rep_process.I connects successfully to that server from the task .
> but when i execute the dts it gave me an error that rep_user does not
> exists.
> Does that means that i rep_user does not exists on the local database.
> Or some other problem.
> pls help
> hope u understand.
> from
> Doller
>|||Hi Uri,
If u read my question carefully then u will come to know that i had
created a user for replication perpose(rep_user) and given full rights
to that user on the production database.
now when i transfer the object(only object mean structure of table)
from the server where i created the replication user it give me error
user does not exists.
2 stage it gave error means when tranferring the object.
it successfully droped the table in the local database.
hope u will understand
from
doller|||Hi
May because:
"In one of the location i had created a user rep_process and given the
permission on the production database"
rep_user does not exist!!
John
"doller" wrote:

> Hi Uri,
> If u read my question carefully then u will come to know that i had
> created a user for replication perpose(rep_user) and given full rights
> to that user on the production database.
> now when i transfer the object(only object mean structure of table)
> from the server where i created the replication user it give me error
> user does not exists.
> 2 stage it gave error means when tranferring the object.
> it successfully droped the table in the local database.
> hope u will understand
> from
> doller
>|||Hi Jhon bell,
i am connected from sa then why rep_user is creating problem.
secondly i had 7 logins on production server why they are not
intrepting .
hope u understand
from
doller|||Hi
When you created the DTS task, it sounds like rep_user was entered for the
connection user.
You may want to check out http://support.microsoft.com/kb/246133/
and http://support.microsoft.com/kb/240872/EN-US/
You may want to check whether the production server has a case sensitive
collation.
John
"doller" wrote:

> Hi Jhon bell,
> i am connected from sa then why rep_user is creating problem.
> secondly i had 7 logins on production server why they are not
> intrepting .
> hope u understand
> from
> doller
>|||Hi John,
It is not the problem of collation.Actually the table was created the
that user and some permission was set that is the why the error
occured.
hope this help u
thanx for help and support
from
doller