I'm trying to backup a new SQL server using Backup Exec 2012. My knowledge of SQL is very limited. This SQL server was set up by consultants who are implementing some product repository software called EpaCube for us. They've set up 3 SQL instances on the SQL 2008 R2 server.
I'm having issues with the test credentials portion for this server's backup. Credentials for normal data is successful, but having issues with the SQL credentials.
Every time i try to test any logins, the Microsoft SQL server comes back with success but all 3 SQL instances fail with a message "Test failed, Test recommended" in the Credential Status column of the job.
I've tested multiple logins for the SQL portion of the backup job. For the SQL server, I've used various logins, from the SA account, to the domain account used by the consultants to set up the software
I also tried the domain admin account. I logged into SQL as SA, added the domain admin account to the security list, with the sysadmin role (as well as public).
Am I missing some role, or some kind of hidden feature in SQL that I'm not aware of?