Hi,
I'm writing an application and I want to create a screen where the user can perform database backups and restores. I have a default install of SQL Server Express 2012 and I am executing a query to perform the backups.
The problem I have is that it would appear that there is no common ground on the file system between a standard user and the MSSQLSERVER user installed with MSSQL Express. Every time I try to perform a backup I get the message:
Cannot open backup device 'xxxx' Operating system error 3 (The system cannot find the path specified.).
When I check the permissions it would seem that the MSSQLSERVER user only has permission in areas that the standard user doesn't.
What is the best way that I can get round this problem? (bear in mind that this software will be installed on remote machines therefore whatever I do needs to be reflected in an setup/installation process).
Regards
Chris.
Go to the complete details ...