Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 936630 - Last Review: September 10, 2011 - Revision: 2.0
Error message when you try to restore an Accounting Express backup or an Accounting Professional backup: "An error has occurred while establishing a connection to the server"
When you try to restore a Microsoft Office Accounting Express backup or a Microsoft Office Accounting Professional backup, you receive the following error message:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under default settings, SQL Server does not allow remote connections. (provider: TCP Provider, error:0 - No such host is known.)
This problem can have either of the following causes.
Cause 1
This problem occurs if the company file to which you want to restore the backup is not valid. Or, the company file is pointing to a database that is not stored on the local computer. The company file is an .sbc file. See Resolution 1 in the "Resolution" section.
Cause 2
This problem occurs if you are trying to restore the backup on a computer that is running Windows Vista. See Resolution 2 in the "Resolution" section.
Note In a multiuser environment, you must restore an an Accounting Express or an Accounting Professional backup on the computer on which the company database is stored. You cannot restore a backup by using a remote computer or by using a client computer.
Resolution 1
To resolve this problem, re-create the company file. To do this, follow these steps:
- Delete the company file that causes the problem.
Note By default, the company file is in the following directory:
C:\Documents and Settings\UserName\My Documents\Small Business Accounting\Companies
- Click Start, point to All Programs, point to Microsoft Office, point to Microsoft Office Accounting version Tools, and then click Data Tools.
Note In this step, version is a placeholder for the version of Microsoft Office Accounting. - On the Basic Tools tab, click Restore.
- In the Select backup file to restore area, click Browse next to the Backup filename box.
- In the Restore dialog box, click the backup file that you want to use, and then click Open.
- In the Select backup file to restore area, click Browse next to the Restore backup file to box.
- In the Select configuration file dialog box, type a name in the File name box, and then click Save.
- Click OK.
- Use the company file that you saved in step 7 to open the company.
Resolution 2
To resolve this problem, apply Service Pack 2 for Microsoft SQL Server 2005. To do this, follow the appropriate step:
- If you are using SQL Server 2005 Express Edition, apply SQL Server 2005 Express Edition Service Pack 2. To obtain this service pack, visit the following Microsoft Web site:
- If you are using other editions of SQL Server 2005, apply SQL Server 2005 Service Pack 2. To obtain this service pack, visit the following Microsoft Web site:
Note The other editions of SQL Server 2005 are as follows:- SQL Server 2005 Enterprise Edition
- SQL Server 2005 Enterprise Evaluation Edition
- SQL Server 2005 Developer Edition
- SQL Server 2005 Standard Edition
- SQL Server 2005 Workgroup Edition
APPLIES TO
- Microsoft Office Accounting Professional 2008
- Microsoft Office Accounting Express 2008
- Microsoft Office Accounting Professional 2007
- Microsoft Office Accounting Express 2007
| kbmbsmigrate kbtshoot kbprb KB936630 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate