Error "the server principal is not able to access the database" when backing up
This error means that the permissions are incorrect and the Windows user is not allowed to access the database due to SQL security restrictions. This is an SQL server issue and it is possible that it needs updating.
Please note: We only support Kennel Connection. SQL Server is not our product and we do not support it.
1 - Run the backup utility as administrator. To do this, go to the C drive and double click on the KC7 folder. Find brutil7.exe, right click on it and choose "Run as administrator". If you are then able to backup, then you have a Windows user account permissions issue.
2 - If step 1 does not work, the next step is to reboot the server and try again. Make sure KC is closed on all computers before you reboot the server.
3 - If step 2 does not work, close KC on all computers and go to your server/main computer.
On the C drive, double click on the KC7 folder.
Double click on wkennel.ini file. If you do not see the .ini extension, hold your mouse over each wkennel file. You are looking for the Configuration Settings file.
Scroll to the bottom to where the SQL parameters are.
Find where it says Trusted=Yes or Trusted=No.
If it says Yes, change it to Trusted=No.
Click File, Save, close this screen and try to backup again.
If it is already on Trusted=No, do not make any changes.
4 - If step 3 does not work, check for and complete all Windows updates both important and optional. This will include any updates for SQL server. Once all updates are completed, try to backup again.
If none of these steps fix the issue, you will need to bring in a technician familiar with SQL server to see what the issue is.
Related Articles
Error "Database error: The server principal is not able to access the database under the current security context" when attempting to backup the database
This error means there is a permission issue when attempting to backup. It can be due to Windows permissions on the drive you attempting to backup to, or some security setting in Windows changed for the database files themselves. Right click on the ...Error 5, access is denied, when backing up the database
This error means you don't have permission to backup to the drive you are choosing. 1 - Backup to a different drive. For example if you are backing up to the C drive, you can choose an external drive instead. 2 - Run the backup/restore utility on ...Backing up your Kennel Connection database
Backing up your Kennel Connection database We strongly recommend that you backup your database regularly. We have supplied a Backup/Restore utility within your software to aid you in the safekeeping of your data. For KC7, the file that contains your ...Restoring the Kennel Connection 7 database using Microsoft SQL Management Studio
Restoring the Kennel Connection 7 database using Microsoft SQL Management Studio If you have been advised to use SQL Management Studio to restore your KC7 backup, there is a good chance it is because there are Windows or SQL Server permissions ...Configuring SQL server to access a network drive for backups
Configuring SQL server to access a network drive for backups *Please note this is not a supported backup method. We STRONGLY discourage anyone from making changes to their installed SQL instance! This guide is only here for reference if you decide ...