I'm attempting to install SQL Backup Pro 6.4 on our new server. It is SQL2008R2 enterprise edition running on Windows 2008R2 Enterprise running on VMWare vSphere 4.0. I've never managed to install SQL Backup from the Backup GUI - probably due to our restrictive permissions, so I'm running SQBServerSetup.exe directly on the server. I have a domain account that I'm hoping to use to run the backup service, and have granted this account SQLSysAdmin permissions on the database server. However, when I click next on the 'Select SQL Server Authentication Mode', having chosen 'Windows Authentication' with this account, I get the following error. 'Failed to verify that the account (rias\svcSQLBackupDev) is a member of the SQL Server sysadmin fixed server role for the selected instance. SQL Error: OLE DB error occured. Code 80070005h
This installation may not be able to install the SQL Backup extended stored procedures. Use another login.'
Using my personal domain account works, but I don't want to use that.
Any ideas? I've tried making the domain account an Administrator on the Windows server but that didn't help. Don't really want to do that anyway.