Backup DB error

Problem: i create a deployment project for a windows application, this setup will install SQL Server express edition before installing the application, after installing the application and when the user trying to backup the DB using the application it gave me the below error
"Cannot open backup device 'C:\backupname.bak'. Operating system error 5(error not found).BACKUP DATABASE is terminating abnormally." and the only location i can create the backup is "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup".

Cause: becaue the SQL Server Express Service run under account "Local Syetm Network".

Resolution:

1. Go to "My Computer" ==> "Control Panel" ==> "Administrative Tools".

2. Open "Services".

3. Locate Service with name "SQL Server (SQLEXPRESS)" and Open it.

4. Choose "Log On" tab.

5. then select "Local System Account".

6. Press "OK".

7. Right Click on the service.

8. Choose Restart.

Created By
Ahmed Abdel Moneim