search
Japanese Chinese Nederlands Espanol Italiano Deutsch Francais Twitter Rss Feeds
MicrosoftArticlesForumsFAQs
C# .NET
VB.NET
Visual Studio .NET
ADO.NET
Xml / Xslt
VB 6.0
.NET CF
GDI+
LINQ
Deployment
Security
FoxPro
Silverlight / WPF
Entity Framework
RIA Services

Web ProgrammingArticlesForumsFAQs
JavaScript
ASP
ASP.NET
Web Services

Non-MicrosoftArticlesForumsFAQs
NHibernate
Perl
PHP
Ruby
Java
Linux / Unix
Apple
Open Source

DatabasesArticlesForumsFAQs
SQL Server
Access
Oracle
MySQL
Other Databases

OfficeArticlesForumsFAQs
Excel
Word
Powerpoint
Outlook
Publisher
Money

Operating SystemsArticlesForumsFAQs
Windows 7
Windows Server
Windows Vista
Windows XP
Windows Update
MAC
Linux / UNIX

Server PlatformsArticlesForumsFAQs
BizTalk
Site Server
Exhange Server
IIS

Graphic DesignArticlesForumsFAQs
Macromedia Flash
Adobe PhotoShop
Expression Blend
Expression Design
Expression Web

OtherArticlesForumsFAQs
Subversion / CVS
Ask Dr. Dotnetsky
Active Directory
Networking
Uninstall Virus
Job Openings
Product Reviews
Search Engines
Resumes

 

Unable to Restore Data File in Small Bus Acct. 2006 SP3 MOSBA


By R Robinson
Printer Friendly Version
View My Articles
1 Views
    

The problem you are having is that SQL Server is trying to connect remotely using TCP/IP Protocols only. This means that when you try to restore a previous company data, the SQL server is acting as if you have server system setup. Not the case you should change the SQL Server to only connect to TCP/IP and local mainpipe names only. To do this, in the search field type SQL then click search. The SQL links will come up click on the one that say's SQL Server Surface Area Configuration. Then go Add

The problem you are having is that SQL Server is trying to connect remotely using TCP/IP Protocols only. This means that when you try to restore a previous company data, the SQL server is acting as if you have server system setup. Not the case you should change the SQL Server to only connect to TCP/IP and local mainpipe names only. To do this, in the search field type SQL then click search. The SQL links will come up click on the one that say's SQL Server Surface Area Configuration. Then click on add new administrator. This should be your computer name and any passwords you use when logging on to your system. Next click on surface area configuration for service and connections, next click the plus on the MSSLBIZ to drop down it's menu, then click the plus on the database engine tab. Next select the remote connections link. Under thsi tab you want to choose the Local and Remote connections link the choose using both TCP/IP and Name Pipes, then click apply for setting to change. close all windows and open small business accounting 2006 then restore you previous company data to you new company file.

Thanks,
R. Robinson
03/26/2008 


button
Article Discussion: Unable to Restore Data File in Small Bus Acct. 2006 SP3 - Robinson (MOSBA)
R Robinson posted at Thursday, March 27, 2008 12:36 AM
Original Article