Auto Update script failing on backup
We are trying to run the auto upgrade script for the first time and are getting the error below. We are not connected to a domain. We ran the test and everything passed. However i have a feeling that the test doesnt check for permissions. This seems similar to the when solidcp permissions are not set on the c:users folders for a backup. We gave everyone full permissions to the folder in question and it still fails.
Downloading the Files ready for updating
Extracting the Files ready for updating
Starting the "SolidCP Enterprise Server" upgrade
Stopping the "WebsitePanel Enterprise Server" website
Restarting IIS on this server for a clean upgrade
Stopping the "WebsitePanel Enterprise Server" Scheduler service
Creating a backup of the "Enterprise Server" files
Creating a backup of the "Enterprise Server" Database
Backup-SqlDatabase : System.Data.SqlClient.SqlError: Cannot open backup device
'\xxx.xxx.90.43SCPUpgrade$WebsitePanel - 2019-12-07 - (08.44 AM).bak'. Operating system error 5(Access is denied.).
At C:solidCP.1.4.5.betaToolsSolidCP-Auto-Upgrade.ps1:409 char:7
+ Backup-SqlDatabase -ServerInstance "$SCP_Database_Servr" -Database "$SCP_D ...
+ CategoryInfo : InvalidOperation: (:) [Backup-SqlDatabase], SmoException
+ FullyQualifiedErrorId : ExecutionFailed,Microsoft.SqlServer.Management.PowerShell.BackupSqlDatabaseCommand
I also wanted to add that our sql server is on another server.
The error suggests that the script is unable to connect to the network share on xxx.xxx.90.43. Please check this is allowed through the firewall and related services are not stopped.