Jump to content

Backup issues with SQL instances - build 9112 and below


support
 Share

Recommended Posts

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

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...