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 keep reading in forums that the "sql server service account" needs to be changed but I am not sure where to change it at.
I am logged in as Administrator on both machines. The Share Permissions has the following groups or user names: Administrator(SQLCOM2\Administrator) connect(SQLCOM2\connect) Everyone NETWORK NETWORK SERVICE Remote Desktop Users(SQLCOM2\Remote Desktop User) SERVICE SQLServer2005MSFTEUser$SQLCOM2$MSSQLSERVER SQLServer2005MSSQLUser$SQLCOM2$MSSQLSERVER SQLServer2005AgentUser$SQLCOM2$MSSQLSERVER SYSTEM
Each of these users\groups has full control permissions.