Product Tip of the Month - Prolog
How to Resolve the Error "Operating System Error 5(Access is Denied.)" When Trying to Make a Backup File of Your Prolog Database
By Steven Peterson, Support Services Analyst, Meridian Systems
This error happens when the account that is running your SQL service does not have Write access to the backup location.
There are 2 steps to resolve this error:
-
Determine the account that is running your SQL service. To do this open the services Management Console. This can be done in a number of ways; you can type services.msc at the Run line, you can start the Services Console from Administrative Tools or you can right click the My Computer icon and select Manage. Once you have the services Management Console open find the SQL Server service and look for the column "Log On As" to find the account that starts and runs your SQL service.
-
Give the account that runs your SQL service "write" access to the backup location. To do this right click on the folder or hard drive location where you want to create your backup file and select Properties, then select the Security tab and highlight the account that runs your SQL service. Check the box to Allow write access and save the change by clicking Apply and Ok. Now you will be able to create the backup of your database.
Forward this tip • Sign up for the newsletter • Update your profile • View past newsletters
|
