Error The server principal is not able to access the database when backing up

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.

    After-Hours Emergency Support
    For use ONLY outside of business hours. (Mon-Fri, 8am to 7pm ET). 

    To avoid any delay, be sure to search this knowledgebase for your issue prior to submitting a ticket. Most answers can be found here.

    If you're issue does NOT consist of one of the following, please email support@kennelconnection.com with your issue to create a ticket and someone will get back to you on the next business day. 

    - Kennel Connection Desktop - Will not open on any machine including server. 
    - KC-Cloud - Cannot login/spinning and you've verified you have Internet.
    - KC Online Reservations - Clients are getting an error upon login or cannot book ANY reservations.
    - Hello-Groom - Cannot login/spinning and you've verified you have Internet.
    - Credit Card Processing - Cannot take payments at all from any method.
    - PawLoyalty - Cannot login/spinning or extreme latency and you've verified you have Internet.

    *Utilizing the emergency support for non-emergencies will not receive a call back.
    *Users without a valid subscription will not receive a call back and will need to speak with a sales representative on the next business day.