Backing up SQLServer to NON-Domain Server

[muftak]

I have a handful of SQL Servers (2000 and 7.0) that are sitting outside of my Windows Domain. For application reasons, they need to stay outside the domain. I'm having problems getting them to back up to my Backup Server, which is inside my Windows Domain. I've tried both UNC paths and Mapped drive options, but get stuck with the same problem 'Access Denied'. I don't want to run the SQL services under a Domain account, as the whole idea is that these servers remain entirely outside the domain structure. Bottom line, I'm looking for a way to pass UN and PW credentials in the Backup script. Does anyone know if this is even possible, or have any other suggestions?

Thanks

 

[SQLBill]

This might work...right click on the My Computer icon, find and click on Services. Find the Backup Exec services, especially the Job Engine (which runs your jobs).

What are the services set as "Log on as". That's the account being used to do the backups and to access SQL Server.

Right click on the service and select Properties. Go to the Log on tab. That's where you can change it and change the password.

Now go to SQL Server, does BE have an account in SQL Server? Is the password the same? (You really won't be able to tell this, so you might have to reset both passwords).

-SQLBill

 

[SQLBill]

How are you really doing your backups? Are you using the SQL Server commands to backup to a tape drive or are you using Backup Exec to make the backups? If you are using Backup Exec, do you have the remote agent and the Agent for SQL Server?

If you are using SQL Server commands, the SQL services must be a Domain account.

If you are using Backup Exec, BE's services (especially the Job Agent service) must have account on SQL Server and 1) the account be a domain account or 2) the login/password in SQL Server be the same as Backup Exec services are set for.

-SQLBill

 

[mrdenny]

How about this. Backup the databases to a local drive. Then use a batch file to map a drive to the backup server (the net use command will accept a username and password). Then move the backup files to the linked server drive, then disconnect the linked server drive.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[muftak]

Bill, I'm using SQL Server commands to backup the DB's. I know that you're supposed to use a Domain account, just wondering if anyone knew a way around that.

Denny, I kinda figured that's where I was going to end up, but thought I'd post here to see if anyone had a miracle solution for me.

Thanks Guys.

 

[mrdenny]

If you map the drive in set 1 of a job using xp_cmdshell, then have step 2 run the backup to the remote server, then have step 3 remove the mapped drive that should work as well.

Denny

--Anything is possible. All it takes is a little research. (Me)