Select the product you need help with

Error message when you try to open a company or you try to create a company in Small Business Accounting 2006, in Accounting Professional, and in Accounting Express: "General network error has occurred, DB cannot be created"

Article ID: 915514 - View products that this article applies to.

SYMPTOMS

When you try to open a company or you try to create a company in Microsoft Office Small Business Accounting 2006, in Microsoft Office Accounting Professional, and in Microsoft Office Accounting Express, you may receive the following error message:

General network error has occurred, DB cannot be created.

Back to the top | Give Feedback

CAUSE

This problem occurs because one of the following conditions is true:

The MSSQL$MICROSOFTSMLBIZ service is stopped.
The database of the company that you try to open is not attached to Small Business Accounting.
The Microsoft SQL Server (MSSMLBIZ) service is stopped.

Back to the top | Give Feedback

RESOLUTION

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

Method 1: Start the MSSQL$MICROSOFTSMLBIZ service in Small Business Accounting 2006

To start the MICROSOFTSMLBIZ service, follow these steps.

Note The MICROSOFTSMLBIZ instance is the instance of Microsoft SQL Server Desktop Engine (also known as MSDE 2000) that is installed with Small Business Accounting 2006.

Click Start, click Run, type services.msc, and then click OK.
In the Services dialog box, right-click MSSQL$MICROSOFTSMLBIZ, and then click Properties.
In the MSSQL$MICROSOFTSMLBIZ Properties dialog box, click the General tab.
From the Startup Type list, select Automatic, and then click OK.
Right-click MSSQL$MICROSOFTSMLBIZ, and then click Start.

Method 2: Attach the company database in Small Business Accounting 2006

Click Start, point to All Programs, point to Small Business Accounting, and then click Data Tools.
In the Small Business Accounting Data Tools dialog box, click Rebuild.
Make sure that the company that you try to open is not in the list of databases.
Click Close.
On the Advanced Tools tab, click Attach.
In the Attach a Database dialog box, click Browse.
On the local drive, locate the Microsoft SQL Server data folder, click the .sbd file that you want to attach, and then click Open.

Note An example of a Microsoft SQL Server data folder is the following folder:
Program Files\Microsoft SQLServer\MSSQL$MICROSOFTSMLBIZ\Data
In the Attach a Database dialog box, enter a name for the new company data file in the Database name field.
Click Attach, click OK, and then click Close.

Method 3: Start the SQL Server (MSSMLBIZ) service in Accounting Professional and in Accounting Express

Note The instance of MSSMLBIZ is the instance of Microsoft SQL Server Express that is installed together with Accounting Professional and with Accounting Express. If you are not using the default instance of MSSMLBIZ for these versions, you must verify that particular instance is started.

Click Start, click Run, type services.msc, and then click OK.
In the Services dialog box, right-click SQL Server (MSSMLBIZ), and then click Properties.
In the MSSQL$MSSMLBIZ Properties dialog box, click the General tab.
In the Startup Type list, select Automatic, and then click OK.
Right-click SQL Server (MSSMLBIZ), and then click Start.