Updated as of 4/18/08:
The problem originally occurred apparently with syncing Outlook w BCM and OA 08 with my Office Live account using the provided Time Manager. I created a clone version of my work schedule using Beta Business applications called schedule then synce’d this with Outlook. Have had no problems since…
Recently have had a problem with my install of OA on my Vista laptop.
Some history:
Lapper goes from work to home. Work is an SBS 2003 domain, home is Vista shared network, lapper not joined to domain just Internet access and restored to. Recently we changed routers and reconfigured the domain for network access for the company boxes. That is when the problem started.
Problem:
I can restore to and use OA 08 as long as I am at work and also at home as long as I do not close and try to reopen OA at home. Tried restoring to at home and get this error message:
Can restore to this lapper at work using the SBS domain but not on a Vista shared network.
Dennis, as per your email after our conversation today:
Chris,
I have discovered the issue with my backup file. The file was created on SBS 2003 R2 under the Administrator name. Office Accounting 2008 was installed on the server and integrated with BCM. This set a folder system that is unique to SBS. Here is the folder system from the error message.
C:\Documents and Settings\Administrator\Local Settings\Application Data\Microsoft\Business Contact Manager\MSSmallBusiness.mdf
And
C:\Documents and Settings\Administrator\Local Settings\Application Data\Microsoft\Business Contact Manager\MSSmallBusiness.ldf
Both of these directory file paths were created during the setup process of OA2008 and BCM on the network share. This makes it unique to the world by using another SQL database default name MSSMLBIZ. When this is setup in a multiuser network the name cannot be MSSMLBIZ it must be MSSmallBusiness and include the path at each workstation on the network.
I have attempted to provide an explanation that is as descriptive as I can get. If you need any more info just contact me and I will attempt to explain. I think I need to post this on the partner site and see if I get any reply from Microsoft. I don’t think they took my prior posts very serious.
Here is the error message that shows up whenever I attempt to restore the database.
Directory lookup for the file “C:\Documents and Settings\Administrator\Local Settings\Application Data\Microsoft\Business Contact Manager\MSSmallBusiness.mdf” failed with the operating system error 5. (Access Is Denied)
File “MSSmallBusiness_dat” cannot be restored to “C:\Documents and Settings\Administrator\Local Settings\Application Data\Microsoft\Business Contact Manager\MSSmallBusiness.mdf”. Use with MOVE to identify a valid location for the file.
Directory lookup for the file “C:\Documents and Settings\Administrator\Local Settings\Application Data\Microsoft\Business Contact Manager\MSSmallBusiness.ldf” failed with the operating system error 5. (Access Is Denied)
File “MSSmallBusiness_dat” cannot be restored to “C:\Documents and Settings\Administrator\Local Settings\Application Data\Microsoft\Business Contact Manager\MSSmallBusiness.ldf”. Use with MOVE to identify a valid location for the file.
Problems were identified while planning for the RESTORE statement. Previous massages provide details. RESTORE DATABASE is terminating abnormally.
I think I understand why this is occurring but I am not certain how to resolve the errors. Can anyone of the Microsoft folks help me with this?
Thanks,
Dennis Pillow
That is what I am going to post tonight.
Dennis Pillow
Dennis, Did not have time this evening to try the KB article mentioning the referred SQL Express update that I mentioned today. Got home after 8 central. Luck on your MPAN post. As well you could post your void question there also.