When a user attempts to create a backup of SQL database in BillQuick 20xx, the below error message appears. (The user has an external drive set up for the backup location specified in Global Settings.)
All BQE Software products are independent of any Microsoft SQL Server software. You need to change the SQL Server service account to a Microsoft Windows Domain User account that has access to the drive and path location of the backup folder. For more information, refer to the following links:
http://www.sqlservercentral.com/blogs/steve_jones/2011/12/15/how-to-change-the-sql-server-service-cccount/
https://msdn.microsoft.com/en-us/library/ms186264.aspx
https://technet.microsoft.com/en-us/library/ms345578(v=sql.110).aspx
https://msdn.microsoft.com/en-us/library/ms345578.aspx
Other recommendations:
- Verify that the path name is correct: The two slashes (\\) in the path name indicate that the extra slash might be the problem.
- Confirm that there is no permission issue by backing up to the same location using SQL Server Management Studio to test the path location. SQL Server Management Studio will return a similar error message if the problem is the path.