Hi Team,

We are trying to take backup from a (source database) different server and restoring the backup to the (target database) another server. But we are getting below error Operating system error 5(Access is denied). When we checked the prerequisites in docs.microfocus we found that read and write permission is required, we have given the same but still we are getting the same error.  

Flow inputs: source, target, working path is on a network share, windows share password and user.

Please find the step error below

Gather Parameters for MS SQL Database Backup and Restore

30 Jun 20:02 - 30 Jun 20:03Exit: 0Server: mc4w01888.microfocus.com, Instance: MSSQLSERVER, Database: msdb

Gather Advanced Parameters for MS SQL Database Backup and Restore

30 Jun 20:03 - 30 Jun 20:03Exit: 0Server: mc4w01888.microfocus.com, Instance: MSSQLSERVER, Database: msdb

Run MS SQL Pre-Backup Validation

30 Jun 20:03 - 30 Jun 20:05Exit: 0Server: mc4w01950.microfocus.com, Instance: MSSQLSERVER, Database: msdb

  [WARNING]: Unable to check free space on shared drive because Windows Share User and Password not provided

Backup MS SQL Database

30 Jun 20:05 - 30 Jun 20:05Exit: 0Server: mc4w01950.microfocus.com, Instance: MSSQLSERVER, Database: msdb

Run MS SQL Post-Backup Validation

30 Jun 20:05 - 30 Jun 20:06Exit: 0Server: mc4w01950.microfocus.com, Instance: MSSQLSERVER, Database: msdb

Run MS SQL Pre-Restore Validation

30 Jun 20:06 - 30 Jun 20:07Exit: 1Server: mc4w01888.microfocus.com, Instance: MSSQLSERVER, Database: msdb

  [ERROR]:

  [.....]: Traceback (most recent call last):

  [.....]:   File "c:\users\mssql\appdata\local\temp\dma\8ff809c672e84c74017305a528134996\003_8ff809c672e84c74017305a871ee4be9\stepcode.py", line 583, in <module>

  [.....]:     main()

  [.....]:   File "c:\users\mssql\appdata\local\temp\dma\8ff809c672e84c74017305a528134996\003_8ff809c672e84c74017305a871ee4be9\stepcode.py", line 503, in main

  [.....]:     backup_file_dict = sqlservertools.query_backup_file(data_file, instance_user=RUNAS_USERNAME, instance_password=RUNAS_PASSWORD)

  [.....]:   File "C:\Users\MSSQL\AppData\Local\Temp\dma\8ff809c672e84c74017305a528134996\003_8ff809c672e84c74017305a871ee4be9\sqlservertools.py", line 514, in query_backup_file

  [.....]:     result_set = sql_conn.query_with_headers(sql,

  [.....]:   File "C:\Users\MSSQL\AppData\Local\Temp\dma\8ff809c672e84c74017305a528134996\003_8ff809c672e84c74017305a871ee4be9\sqlservertools.py", line 263, in query_with_headers

  [.....]:     raw_result = self.query(sql, result_type=result_type)

  [.....]:   File "C:\Users\MSSQL\AppData\Local\Temp\dma\8ff809c672e84c74017305a528134996\003_8ff809c672e84c74017305a871ee4be9\databaseconnection.py", line 57, in query

  [.....]:     return cur.fetchall(parse=parse, result_type=result_type,

  [.....]:   File "C:\Users\MSSQL\AppData\Local\Temp\dma\8ff809c672e84c74017305a528134996\003_8ff809c672e84c74017305a871ee4be9\databaseconnection.py", line 43, in fetchall

  [.....]:     return self._query(parse=parse, result_type=result_type,

  [.....]:   File "C:\Users\MSSQL\AppData\Local\Temp\dma\8ff809c672e84c74017305a528134996\003_8ff809c672e84c74017305a871ee4be9\sqlservertools.py", line 172, in _query

  [.....]:     raise self.DatabaseError(msg % (status, output, errors))

  [.....]: DatabaseError: Query failed with return code "1" -- "Msg 3201, Level 16, State 2, Server MC4W01888, Line 2\r\nCannot open backup device '\\\\MC4W01950\\Temp\\msdb_20200630_143504.bak'. Operating system error 5(Access is denied.).\r\nMsg 3013, Level 16, State 1, Server MC4W01888, Line 2\r\nRESTORE HEADERONLY is terminating abnormally.\r\n"; ''

  [ERROR]: Query failed with return code "1" -- "Msg 3201, Level 16, State 2, Server MC4W01888, Line 2\r\nCannot open backup device '\\\\MC4W01950\\Temp\\msdb_20200630_143504.bak'. Operating system error 5(Access is denied.).\r\nMsg 3013, Level 16, State 1, Server MC4W01888, Line 2\r\nRESTORE HEADERONLY is terminating abnormally.\r\n"; ''

Any suggestions on how we can resolve/ causes for the error would be helpful.