Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / DB Engine / SQL Server / July 2008

Tip: Looking for answers? Try searching our database.

Problem with MS Accounting that may be related to SQL Server

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
gamer2k4@gmail.com - 17 Jul 2008 14:25 GMT
I'm trying to migrate our current systems of Janna Contact and
Peachtree Accounting over to MS BCM and MS Accounting.  Naturally, I
want to integrate the two latter products with each other, while
keeping all of the data accessible to any computer on the network.  To
that end, I copied the BCM database over to our server (where it's now
being handled with Microsoft's database admin tool), along with the
converted MS Accounting database (the latter was created on the
server).

I've tried running the BCM integration wizard in MS Accounting 2008.
Everything seemed okay, until I got to the integration part.  It needs
to make a backup first, which fails:

"The Business Contact Manager for Outlook Integration Wizard did not
successfully complete the process due to the following error:

Cannot open backup device "C:\Documents and Settings\Administrator
\Local Settings\Temp\303uvmjf.etr".  Operating system error 5(Access
is denied.).
BACKUP DATABASE is terminating abnormally."

Each time I've tried, the file name and extension are different.  What
might be the cause of this? As you can see, I'm running as the
Administrator, so there shouldn't be any permission problems...
gamer2k4@gmail.com - 17 Jul 2008 20:26 GMT
I've found the solution, I think.  Although the user is Administrator
and has administrator access, SQL isn't the same account.  It has a
separate account called sql, and that's the account that needs to be
given access to the folder.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.