Re: Run As Command
- From: Sue Hoegemeier <Sue_H@xxxxxxxxxxxxx>
- Date: Mon, 21 May 2007 19:58:09 -0600
Not sure of all the details on the mapped drive - you had no
luck where? Can you create a mapped drive and access it from
your domain with a particular login and password?
If you have that, you could execute net use to map a drive
and specify a domain\user and password. Then copy the file
to that mapped drive. Then delete the mapped drive when
done.
-Sue
On Mon, 21 May 2007 09:11:00 -0700, Rick
<Rick@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
I need to copy a backup file from server to server in seperate domains.
Unfortunately in my company they do not have trusted connections. So I need
to use a seperate logon for the destination server. I have tried a mapped
drive that is mapped as a valid logon in thatdomain with no luck, I get
"cannot find the drive specified." Is there a way thorugh sql server to run a
job or a copy as something different than the SQL Agent account. FYI, the
logon that I use to logon to the other domain cannot be registered as a logon
to SQL server bacause SQL Server cannot see that domain. Any suggestions?
.
- Prev by Date: Re: Decryption within an application
- Next by Date: Re: Run As Command
- Previous by thread: Help in SQL
- Next by thread: Re: Run As Command
- Index(es):
Relevant Pages
|
|
