Backup issues with SQL instances - build 9112 and below

[support]

Issue:

If you are using a named SQL instance on your database server, with a common one being SQLEXPRESS, you may see an issue with the Test Permissions button or when performing a backup, where is says it cannot connect to the database server, and you should check permissions.

 

Fix:

If you can upgrade to build 9117 or higher, this should fix the issue.  On some systems, the Powershell commands do not accept the server name in a FQDN format, for example, dbserver01.contoso.com\SQLEXPRESS.  We have changed this to only reference the netbios name of the server in build 9117, which fixes this issue.

 

If you need to, please do a manual upgrade first by following these instructions: https://www.clickstudios.com.au/community/index.php?/topic/13911-manual-backup-using-sql-management-studio-tools/

 

 

To do a manual upgrade, please follow section 5 in this document: https://www.clickstudios.com.au/downloads/version9/Upgrade_Instructions.pdf 

 

Alternatively, please see this video for a demonstration on performing a manual upgrade: https://www.youtube.com/watch?v=2nLWD7fX_gY

 

Regards,

Support