SQL Backup Failure - Commvault Galaxy

Problem: SQL Restore fails using Commvault Galaxy
Client Platform: Windows 2003 Server (64 Bit), SQL 2005
Error: Authentication Error
Change before the problem arise: Change in SQL admin account Password

Solution:

Commvault needs to use SQL Admin user name and password in order to work with the agent. This id and password is from the client side. The commvault Galaxy has a bug and it does not interact well with good passwords with symbols like £ $ % ^ & *. So make sure your SQL Admin account password does not contain any of the characters. Eg: P@$5w0rD <<< Wont work. Pa55w0rd <<< will work

How to find it:

In Comcell GUI > Client Computers > Client name > SQL Server > DB Instance > Properties > Accounts


Thanks,

Mihir Sangani