Technote (troubleshooting)
Problem(Abstract)
Tivoli Storage Manager for Microsoft SharePoint platform backup encounters an error regarding the write permission to the DocAve agent directory
Cause
Logon account of the SQL service does not have enough permission for the DocAve directory
Diagnosing the problem
Error message seen in job report of platform backup:
| Error:An error occurred while backing up raw database : An error occured while backup the certificate.Database will be invalid without certificate,error messageSystem.Data.SqlClient.SqlException: Cannot write into file 'xxxxx'. Verify that you have write permissions, that the file path is valid, and that the file does not already exist. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Avepoint.VCSPFarm.TSQLUtility.BackupCertificate(String server, String userName, String password, String certificateName, String outputFolder) at Avepoint.VCSPFarm.DBBackupWorker.BackupCertificate(BackupNode dbNode, DataNode& certificateNode) at Avepoint.VCSPFarm.DBBackupWorker.VDIBackup() |
Resolving the problem
On the SQL server:
1. Go to SQL server configuration manager > SQL server services.
2. Figure out the "Log On As" account
3. Grant this account "Full Control" permission to the DocAve agent directory, default location is C:\Program Files (x86)\Tivoli\TSM\SharePoint\DocAve5\Agent
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.