Note: A note has been added to the V7.0.1 MS SQL Server plug-in configuration screen stating that the MS SQL Server instance write access must be confirmed.
The MS SQL plug-in cannot export the selected databases to the specified dump folder.
Unable to export database abc: Cannot open backup device 'C:\Program Files\Attix5 Pro\Backup Client SE\SQLDump\abc.bak'. Operating system error5(Access is denied.).
The error is a result of Windows security settings. The SQL Server service is by default started with the built-in Network Service account, and this service account does not have read/write access to most areas on the server, apart from the default SQL install location.
- Change the dump folder to a location where the SQL service have sufficient permissions to access it
(e.g. a SQLDump subfolder in the SQL install location
- Or give the Network Service account read/write access to the specified dump folder.
- Another alternative is to change the SQL service Log On account to Local System or another account with access to the specified dump folder.
Old Article ID: 134
Posted: 02 Mar, 2012 by Van Rensburg J.