Video Screencast Help
Scheduled Maintenance: Symantec Connect is scheduled to be down Saturday, April 19 from 10am to 2pm Pacific Standard Time (GMT: 5pm to 9pm) for server migration and upgrades.
Please accept our apologies in advance for any inconvenience this might cause.

Backup Exec 2012 failing on SQL 2008 server

Created: 18 Sep 2013 | 1 comment

Hello everyone, 

A bit of back story. 

I have a SIMS (Student Information Management System) 2008 R2 server, which runs an SQL 2008 database.

During the summer I had my other servers upgraded to 2008 R2 and had Backup Exec upgraded to 2012. The install went fine and the remote agents installed without issue. Backup Exec was configured to use two NAS devices for storage, and Full/Differential backups were created for my Main Server, Exchange and SIMS. 

The Main Server and Exchange backup correctly and I have carried out tests on recovering mail and files.

My SIMS server keeps failing and I cannot see why.

I recreated the Backup Jobs from scratch. Checked all the required tick boxes, tested the credentials and all were successful

120px_Backup Exec credentials.JPG

Ran a full backup and it failed. crying

I have tried various setting changes, different admin accounts, but nothing seems to work.

Attached is the log file from my last attempt.

Thanks in advance to anyone that can shead some light on this for me. It's probably really straight forward. I just can't see the wood for the trees.

Operating Systems:

Comments 1 CommentJump to latest comment

pkh's picture

The problem is caused by the id BROKEHALL/SystemAdmin not having SA rights to the database.  If this id is a domain admin, then you need to enable Windows authentication for your database.