Article ID: 928166
Article Last Modified on 10/23/2007
APPLIES TO
- Microsoft Office Small Business Accounting 2006
- Microsoft Office Small Business Management Edition 2006
SYMPTOMS
When you open a company file in Microsoft Office Small Business Accounting 2006, you receive the following error message:
CAUSE
This problem occurs because of one of the following reasons:
- The port for the MICROSOFTSMLBIZ instance is incorrect.
- The MICROSOFTSMLBIZ instance uses the same port that another instance of Microsoft SQL Server uses.
- The database of the company that you try to open is not attached to Small Business Accounting.
RESOLUTION
To resolve this problem, use one of the following methods.
Method 1: Make a modification on the server computer
- Click Start, click Run, type svrnetcn, and then click OK.
- In the SQL Server Network Utility dialog box, click
ComputerName
\MICROSOFTSMLBIZ in the Instance(s) on this server list.
Note ComputerName
represents an actual computer name.
- Verify that the TCP/IP protocol is in the Enabled protocols field. Otherwise, click the TCP/IP protocol, and then click Enable.
- In the Enabled protocols field, click the TCP/IP protocol, and then click Properties.
- In the Default port field, type 56183, and then click OK.
- Click Start, click Run, type services.msc, and then click OK.
- In the Services dialog box, right-click MSSQL$MICROSOFTSMLBIZ Service, and then click Restart.
- If you have multiple instances of SQL Server on the server computer, verify that these instances do not use port 56183.
- Open the company file that is on the server computer.
Method 2: Make a modification on the local computer
- Click Start, point to All Programs, point to Microsoft Small Business Accounting, and then click Data Tools.
- In the Small Business Accounting Data Tools dialog box, click Rebuild.
- In the Rebuild Company File dialog box, make sure that the company that you try to open is not in the list of databases, and then click Close.
- Click the Advanced Tools tab, and then click Attach.
- In the Attach a Database dialog box, click Browse.
- In the Select data file to attach dialog box, locate the Microsoft SQL Server data folder, click the .sbd file that you want to attach, and then click Open.
- In the Attach a Database dialog box, type a name for the new company data file in the Database name field.
- Click Attach, click OK, and then click Close.
Additional query words: SBA
Keywords: kbtshoot kberrmsg kbmbsmigrate kbprb KB928166