Auto Update script ...
 
Notifications
Clear all

Auto Update script failing on backup

3 Posts
2 Users
0 Reactions
819 Views
Posts: 53
Topic starter
(@beckhamk)
Trusted Member
Joined: 8 years ago

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

2 Replies
Posts: 53
Topic starter
(@beckhamk)
Trusted Member
Joined: 8 years ago

I also wanted to add that our sql server is on another server.

Reply
Posts: 1457
Admin
(@trobinson)
Noble Member
Joined: 9 years ago

Hello,

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.

Regards,

Trevor

Reply
Share: