About Me...

My photo
I have gone to find myself, please keep me here if I get back before I return. Does it make sense to you?

Tuesday, January 20, 2009

SQL Restore fails using Commvault Galaxy

Problem: SQL Restore fails using Commvault Galaxy
Platform: Windows 2003 Server (32 Bit)
Error: Query Result [ERROR:
Microsoft SQL-DMO (ODBC SQLState: 42000) Error: -2147217440
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open user default database. Login failed.
IDispatch error #3552
].

Solution:

1) Change the user name and password for Galaxy Agent using Commcell

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

2) Verify if user name used by comcell has "master" access on the server

Windows Management > Users >Select User> Properties > Master

Thanks,

Mihir Sangani

No comments: