Re: Run As Command

This is what I came up with after a lot of trial and error

Declare @VCHCOMMAND Char (150),
@CMD Char (50),
@COPY Char (50)
Set @VCHCOMMAND = 'net use L: *\\172.9.17.99\Backup peoples123
/user:sigueqa\rpeoples'
Set @COPY = 'copy \\server2\Backup\DB\SIRETGUE.Bak L:\DB'
Set @CMD = @VCHCOMMAND + ' Y ' + @COPY
EXEC MASTER..XP_CMDSHELL @CMD


, but I get the following error:

L: has a remembered connection to \\172.17.9.67\backup. Do you
want to overwrite the remembered connection? (Y/N) [Y]:
No valid response was provided.
NULL

Any Suggestions?

"vt" wrote:


Rick

here is how you can do it

SELECT @VCHCOMMAND = 'net use v: \\10.1.97.150\sqlbackups$\SRDEV dbbackup
/user:XXXX\srdev_db_backup'
EXEC @IRESULT = MASTER..XP_CMDSHELL @VCHCOMMAND, NO_OUTPUT

where v: is the share name
dbbackup : password to connect \\10.1.97.150\sqlbackups$\SRDEV
XXXX\srdev_db_backup : is the user login on the destination server

if you are using BACKUP DATABASE command to backup the database then

issue the above command first and then backup up the database on to v:

hope this helps you




Regards
VT
Knowledge is power, share it....
http://oneplace4sql.blogspot.com/


"Rick" <Rick@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:042AEE4F-6267-4EA8-8BB6-4609B32409DB@xxxxxxxxxxxxxxxx
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?



.

Relevant Pages

  • Re: Run As Command
    ... if you are using BACKUP DATABASE command to backup the database then ... to use a seperate logon for the destination server. ... to SQL server bacause SQL Server cannot see that domain. ...
    (microsoft.public.sqlserver.security)
  • Re: User ASPNET in SQL Server 2000
    ... and turn off anonymous access. ... a logon box will pop up if the user cannot ... >While I love integrated security in SQL Server, ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Phantom User or Role
    ... >http://www.support.microsoft.com/?id=314546 Moving ... SQL Server Databases ... Logon and/or Permission ... >Issues When a Database Is Moved Between SQL Servers ...
    (microsoft.public.sqlserver.security)
  • Re: Capture SQL Server Connections
    ... LOGON TRIGGERS are only support in SQL Server 2005+. ... As long as the LOGON TRIGGER is running the connection is not yet made ... connecting so I can provide a custom authenication mechanism? ...
    (microsoft.public.sqlserver.server)
  • Re: User ASPNET in SQL Server 2000
    ... I want to logon to the virtual catalog from the internet ... as the windows user then I want to logon to the SQL Server ...
    (microsoft.public.dotnet.framework.aspnet.security)