Microsoft KB Archive/925394

= Error message when you restore a backup file in Accounting Professional, Accounting Express, or in Small Business Accounting 2006: &quot;SQL does not exist, the service is stopped, or access is denied&quot; =

Article ID: 925394

Article Last Modified on 10/24/2007

-

APPLIES TO


 * Microsoft Office Accounting Professional 2008
 * Microsoft Office Accounting Express 2008
 * Microsoft Office Accounting Professional 2007
 * Microsoft Office Accounting Express 2007
 * Microsoft Office Small Business Accounting 2006

-



SYMPTOMS
You receive an error message when you use the Restore Database functionality to restore a backup file in the following products:
 * Microsoft Office Accounting Professional
 * Microsoft Office Accounting Express
 * Microsoft Office Small Business Accounting 2006

You receive the following error message:

SQL does not exist, the service is stopped, or access is denied.



CAUSE
This problem occurs because one or more of the following conditions are true:
 * In a multiuser environment, you perform the Restore Database functionality on a computer that is not the server computer.
 * The backup file is not on the partition on which you installed Small Business Accounting 2006.
 * The MSSQL$MICROSOFTSMLBIZ service is not started.
 * In Accounting Professional or in Accounting Express, the MSSMLBIZ service is not started.



RESOLUTION
To resolve this problem, use one or more of the following methods.

Method 1
In a multiuser environment, perform the Restore Database functionality on the server computer. The server computer is the computer on which the database is located. You should use this computer instead of a client computer to perform the Restore Database functionality.

Method 2
If you have multiple partitions on the computer on which you performed the Restore Database functionality, move the backup file to the partition on which you installed Microsoft Office Small Business Accounting. Then, use the Restore Database functionality to restore the backup file.

Method 3
Start the MSSQL$MICROSOFTSMLBIZ service. To do this, follow these steps:
 * 1) Click Start, click Run, type services.msc, and then click OK.
 * 2) In the Services dialog box, right-click MSSQL$MICROSOFTSMLBIZ, and then click Properties.
 * 3) In the MSSQL$MICROSOFTSMLBIZ Properties dialog box, click the General tab.
 * 4) In the Startup Type list, click Automatic.
 * 5) Click Start.

Method 4
If you are using Accounting Professional or Accounting Express, start the MSSMLBIZ service. To do this, follow these steps:
 * 1) Click Start, click Run, type services.msc, and then click OK.
 * 2) In the Services dialog box, right-click SQL Server (MSSMLBIZ), and then click Properties.
 * 3) In the MSSMLBIZ Properties dialog box, click the General tab.
 * 4) In the Startup Type list, click Automatic.
 * 5) Click Start.

