sql-log-shipping-service
sql-log-shipping-service copied to clipboard
Unable to work with SQL 2012-SP4 using SAS token
Please see error below. Any way to modify the program to login using storage account access key instead of SAS token. Also what is the usage of LogFilePath? I'm using blob storage for backup/restore. "LOG/SERVERNAME/{DatabaseName}/ Thanks!
2024-09-19 11:32:19.324 -04:00 [INF] Starting log restore iteration 1 <1> 2024-09-19 11:32:19.686 -04:00 [INF] GetDatabases completed in 350.9 ms <1> 2024-09-19 11:32:19.698 -04:00 [INF] Get logs for MYDB after 09/19/2024 02:58:45 (Offset:0) from LOG/SERVERNAME/MYDB/ completed in 0.7 ms <7> 2024-09-19 11:32:19.730 -04:00 [DBG] MYDB Redo Start LSN: 6308030000000657600001 <7> 2024-09-19 11:32:19.916 -04:00 [ERR] Error restoring logs for MYDB <7> System.AggregateException: One or more errors occurred. (This request is not authorized to perform this operation. RequestId:cfdc444b-c01e-0024-21a9-0a3e3f000000 Time:2024-09-19T15:32:19.8974252Z Status: 403 (This request is not authorized to perform this operation.) ErrorCode: AuthorizationFailure