I am an intern working with two SQL Server 2005 instances on two Windows Server 2003. The servers are linked via crossover. I am using this setup to practice my log shipping before I move to the production databases. I am using the wizard to complete the log shipping. The primary server SQLCOM1 is to backup and restore the DB on the secondary server SQLCOM2\SQL_Data using the default folders after the restore. SQLCOM2\SQL_Data has been shared and I have permissions for most of the default SQL groups as well as a user ‘connect’ and the local admin. When I go to execute the log shipping it throws the following:
BackupDiskFile::CreateMedia: Backup device ‘\\SQLCOM2\SQL_Data\AdventureWorks.bak’ failed to create. Operating system error 5(Access is denied.).
I am working with SQL Server 2005 Enterprise Edition SP1. (SP1 to replicate the production servers.)
I am logged in as Administrator on both machines.
The Share Permissions has the following groups or user names:
Remote Desktop Users(SQLCOM2\Remote Desktop User)
Each of these users\groups has full control permissions.
Thanks for any help,