KB: SQL Transient Error during Passwordstate Backup
Issue:
On the screen Administration -> Backups, when clicking Test Permissions, the error below is generated.
- Testing if files can be written to the backup path.....
- Testing for correct version of PowerShell on web server.....
- Testing SQL Server database server prerequisites.....
- Testing SQL Server database backup.....
Failed: A transient error occurred when testing permissions. Please re-test, and report the issue to Click Studios if the problem persists.
Fix:
It was found that some PowerShell SqlServer module dll files were being blocked. To unblock, run the PowerShell commannd below:
Get-ChildItem "C:\Program Files\WindowsPowerShell\Modules\SQLServer" -Recurse | Unblock-File