DTS package failure

[ashaig]

I'm trying to export 3 tables to my ISP's server from my PC. I keep getting
"UserId (myID)not a valid user on (database I've never heard of)"
My ISP can't or won't help, seeing it as a problem I have created.
I can't see how. I even used the wizard to create this package. Opted for 'Transfer Objects and data', 'drop destination tables first', 'replace data'. I've double-checked that I'm pointing at the correct server, and using the correct UserId/password.

 

[bgreenhouse]

I've never created a DTS package before, but there must be a step in there where you select what Database you are working on (for example, in each Job step you have to choosea database). It sounds to me like somehow, the wrong one has been selected. Either that or your default database has been wrongly assigned.

Hope that helps.

Ben

 

[ashaig]

Thanks Ben,
I forgot to say that I selected the correct database from wizard. I'm wondering about having different authentication protocols screwing things up somehow. I'm using NT authentication at Pc end and SQL authentication at Server end.

 

[ashaig]

Don't want to waste anyone else's time. I changed to SQL authentication at PC end and it worked like a dream! (I also used same userid/password as at server end.)