Welcome to MSDN Blogs Sign in | Join | Help

News

  • The views expressed in this blog are those of the individual and do not necessarily represent those of Microsoft. This information is provided by way of general information only and should not be relied on without obtaining independent expert advice. These postings are provided "AS IS" with no warranties and confer no rights. You assume all risk for your use
Restoring Business Contact Manager Database After Upgrading XP to Vista

When you upgrade from XP to Vista and try to restore previously backed up BCM database, you might see permission related error.  This is caused by mismatch between the user information stored in backup file and actual user account after upgrade to Vista. In BCM, a back-up database can be restored by the user who created database (called Database Owner) or computer administrator. After machine has been upgraded to Vista, SQL might complain that the user information stored in backup file is not valid. You can resolve this issue by explicitly running Outlook.exe process as administrator. Browse to Outlook.exe file in the folder where you installed Office, right click Outlook.exe and select "Run as Admin".

You need to run Outlook as admin only once. After successful migration, you can start Outlook normally and use BCM.

-Mukesh

Posted: Thursday, February 08, 2007 6:03 PM by bcmteam
Filed under: , ,

Comments

Sunem said:

An alternative to "browse to Outlook.exe file in the folder where you installed Office" would be that on Vista, you can right-click on the Outlook icon on your Quick Launch bar and select "Run as administrator".  You can right-click on your Taskbar | Toolbars, if you don't have Quick Launch bar visible.

HTH,

Sunem

# February 19, 2007 1:52 PM

rupeshsns said:

After upgrading to MS Vista Business from XP my BCM does not work and comes up with the following messages when i try to open Outlook 07:

Business Contact Manager for Outlook could not connect to the shared database. Do you want to work offline?Yes/No, then i click yes the following message comes up:

Business Contact Manager for Outlook

Business Contact Manager database cannot be loaded. This action cannot be completed because Business Contact Manager cannot access the database. The database is currently stopped. Do you want to change the database configuration?

Yes   No (when i choose yes, the following message comesup):

Business Contact Manager for Outlook

This action cannot be completed because Business Contact Manager cannot access the database.

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 the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

OK  

can you please advice on how i can fix the problem and get BCM work with Outlook 07  

sorry for being novice..any help is highly appreciated..thank you..rupesh

# February 22, 2007 9:05 PM

Sunem said:

rupeshsns, I am not sure what problem you are facing, but it sounds like SQL Server cannot find your BCM database.

Here are a few suggestions... I am not guarentee if they will work:

1. Use Windows Update and see if there is any patch for SQL Server.  It maybe that SQL Server needs an update

2. If you are using remote desktop connection, or if you are connecting your BCM client to a database hosted on a different machine, it may be the enhanced Vista security that's preventing SQL Server from being reached.  I do not have specific instruction on how this should be fixed, but it may be one of the reasons...

Let me know if updating SQL Server turns out to be the solution.  Hope that helps,

Sunem

# February 27, 2007 6:00 PM

DoktrMark said:

rupeshsns -

I encountered the sample problem as you when I upgraded from XP to Vista a few days ago.

It is definitely a permission issue. The solution I used was to change the Log On property in the SQL server service for the business contact manager database instance (MSSMLBIZ). I changed it from the Network Service account to log on the Local System Account.

I tried changing the permissions for Network Service for the folder containing the BCM database. I did not have any success going that route.

There is probably a better solution out there, but this one worked for me.

Mark

# March 3, 2007 11:06 AM

mielniczuk said:

During setup of new Vista notebook with Office 2007, I used a backup copy of Outlook 2003 Bus. Contact Manager. Installed it successfully into an instance of SQL Express 2005 on the new notebook.

During setup of Outlook 2007 BCM, found the SQL Express instance and the prior version OK, but could not get it to update.

Tried several of the above suggestions without success. Finally, restored a copy of the old BCM to the second instance of SQL Express created on the install of BCM to Outlook 2007. Had use the SQL Express Properties > Files on the restored BCM DB to change the ownership to my new notebook logon account.

Started up Outlook again. Update Wizard went through without a hitch.

Hope this helps.

A. Simon Mielniczuk

# March 9, 2007 12:14 PM

Canada61 said:

I'm getting a data conversion error when trying to restore 2003 SP4 BCM Data to a new install on Vista/outlook 2007.  The wizard first displays that the program has to migrate data created in version 2.0.3606.0 to version 3.0.5625.0.  when Ok'd the restoral bar comes up and runs to about 3/4 of the way down ond stops.  After a bit the Migrating database progrss bar comes up and goes about a quarter of the way down and stops.  Then I get this error after the wizard states that the migration was unsuccessful:

Problem signature:

 Problem Event Name: BCM

 Problem Signature 01: Addin

 Problem Signature 02: IrisDbException

 Problem Signature 03: 3.0.5828.0

 Problem Signature 04: 12.0.4518.1014

 Problem Signature 05: DoMigrate

 Problem Signature 06: InternalTryToConvert

 Problem Signature 07: 6265D0F1

 OS Version: 6.0.6000.2.0.0.256.6

 Locale ID: 1033

Additional information about the problem:

 LCID: 1033

I've tried the 'run as admin' solution, and the SQL fixes suggested here.  Any help would be appreciated.

BH

# March 9, 2007 1:04 PM

efredian said:

I opened Outlook as administrator and was able to restore the BCM database to Outlook. However, when I open Outlook, normally, with my log in account name (also an administrator), I get an error message:

"Business Contact Manager for Outlook could not complete your last action or actions. Please try again."

No number of retries seems to fix the problem. I opened Outlook as administrator, again, and did not receive any error messages and the BCM database looks okay.

# March 29, 2007 4:10 PM

efredian said:

Most recently removed BCM database (File - Data File Management - delete BCM database) in Outlook opened in Run as Administrator mode.

Closed Outlook then opened in normal mode - added BCM back in and all contacts were there.

Shut down Outlook, restarted in normal mode (with log-in as administrator, not in administrator mode) and got the old error message again.

"Business Contact Manager for Outlook could not complete your last action or actions. Please try again."

Also, seems to have messed up my indexes in Outlook. Contacts not indexed in Outlook Contacts.

# March 31, 2007 3:58 PM

andyhamer said:

Help I have just bought a new pc with vista installed on in and installed Office SB 2003 with an upgrade to 2007.  My problems is that when I want to restore my 2003 database which I backed up of my old pc.  I told that I dont have permission to restore the backup!!!  I have over a 1000 contacts locked in 2003 than need to be on my 2007.

I have tried everything suggested that I have found on the internet but nothing works.

Any suggestions before I throw the new pc out the window.

# September 12, 2007 1:11 PM

bcmteam said:

Start Outlook as administrator. You can do that by right clicking on C:\Program Files\Microsoft Office\Office12\OUTLOOK.EXE and selecting "Run as Administrator". Try restoring the DB after that. You will need to do "Run as Admin" only once when you are restoring an old DB.

# September 12, 2007 1:21 PM

andyhamer said:

I have tried that and it doesn't work!  

# September 12, 2007 2:05 PM

bcmteam said:

If you are unable to restore your .sbb or .msbcm backup after trying the above workaround, follow the steps below:

1.) Make a copy of the .sbb or .msbcm backup file and rename it with a .zip extension.

2.) Open the .zip file and extract the files

3.) You'll see a file that contains a version number (e.g. en-US#3.0.5625.0)

4.) Rename this file to the name of your backed up database and add a .bak extension (e.g. MSSmallBusiness.bak)

5.) Follow the instructions to restore a BCM database from an automatic SQL backup:

http://blogs.msdn.com/bcm/archive/2007/09/06/restoring-an-automatic-sql-backup.aspx

~ Clinton Ford

# September 12, 2007 3:10 PM

andyhamer said:

Thank you.  

# September 13, 2007 4:01 AM

Dave J. (Scoop0901) said:

I cannot get the contents of DVD2 from the Office 2007 Ultimate package to install.  The contents are Business Contact Manager for Outlook 2007 and MS Accounting 2007, along with (by default -- would be nice if I could get around that, as that would solve the issue entirely!) SQLserver2005.

Each time I try -- without SQLserver 2005 installed on the system (Vista Ultimate on P4-2.8gHZ with 4gigs RAM and dual 120gig HDs) -- it stops after about 3/4 of the install, telling me that it cannot install because "An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name."

As I said, I have uninstalled ALL SQLserver items from the Add/Remove panel, deleted ALL directories in C:\Program Files\Microsoft SQL Server\.  What am I missing?  Where?  There is nothing anywhere else in the C drive, other drives, or in MY DOCUMENTS or the PROGRAM DATA directories.

The log generated is, in full:

Microsoft SQL Server 2005 9.00.2047.00

==============================

OS Version      : Professional  (Build 6000)

Time            : Sat Feb 02 17:26:11 2008

Machine         : Tower1

Product         : Microsoft SQL Server Setup Support Files (English)

Product Version : 9.00.2047.00

Install         : Successful

Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_Tower1_SQLSupport_1.log

--------------------------------------------------------------------------------

Machine         : Tower1

Product         : Microsoft SQL Server Native Client

Product Version : 9.00.2047.00

Install         : Successful

Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_Tower1_SQLNCLI_1.log

--------------------------------------------------------------------------------

Machine         : Tower1

Product         : Microsoft SQL Server VSS Writer

Product Version : 9.00.2047.00

Install         : Successful

Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_Tower1_SqlWriter_1.log

--------------------------------------------------------------------------------

Machine         : Tower1

Product         : SQL Server Database Services

Error           : An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name.

--------------------------------------------------------------------------------

Machine         : Tower1

Product         : SQL Server Database Services

Error           : An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name.

--------------------------------------------------------------------------------

Machine         : Tower1

Product         : Microsoft SQL Server 2005 Express Edition

Product Version : 9.1.2047.00

Install         : Failed

Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_Tower1_SQL.log

Last Action     : DetectInstanceClash

Error String    : An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name.

Error Number    : 28086

--------------------------------------------------------------------------------

SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt.

Time            : Sat Feb 02 17:27:16 2008

List of log files:

C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_Tower1_Core(Local).log

C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_Tower1_SQLSupport_1.log

C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_Tower1_SQLNCLI_1.log

C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_Tower1_SqlWriter_1.log

C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_Tower1_SQL.log

C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_Tower1_Datastore.xml

C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_Tower1_.NET Framework 2.0.log

C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_Tower1_SNAC.log

C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_Tower1_Core.log

C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt

C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_Tower1_Support.log

C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_Tower1_SCC.log

# February 2, 2008 6:24 PM

sarathi15 said:

hi, i have a situation where i want to ge rid of the default databse & create a new databse with the same name as teh default databse name,somehow this is not working out, get an error saying "datbse already exists . Give a unique name. Can anyone help me with this

# April 23, 2008 3:10 PM

contumaz said:

Hi. I had a .bcm file (Outlook 2007 in English) on a computer with Windows XP Professional also in English where I had administrator privileges and now I'm trying to import that .bcm file to a different computer with Windows Vista Home Basic in Spanish where I also have administrator privileges and Office 2007 in English. I'm giving you all this information just in case it makes sense. I get the following error "Some errors occurred while your data was being imported. Wrong file version." I tried running Outlook as administrator and the importing doesn't work either. I get the same error.

What can I do? any ideas?

# July 15, 2008 8:11 PM

bcmteam said:

Hi Contumaz,

 Can you please change the user locale of your Spanish Vista machine to English and then try importing the file?

Bcmteam

# July 22, 2008 1:38 PM

contumaz said:

Yes, I've tried that as well. My laptop is all set up in english US but I can't retrieve my .bcm file yet. I really need those contacts! any other ideas? thanks!

# July 31, 2008 6:41 PM

bcmteam said:

Hi Contumaz,

Can you please verify that the first line of your bcm file is in the following format

<BCMEntities version="3.0" bcmlocale="en-US" hasheader="True"

# August 4, 2008 6:27 PM

contumaz said:

Yes BCMTeam, it's

<BCMEntities version="3,0" bcmlocale="en-US" hasheader="True" hascustomizationschema="True">

and I just made sure again that the system is set en-US  

# August 6, 2008 11:44 AM

bcmteam said:

Hi Contumaz,

In your file the value of BCMEntities version is "3,0" and not "3.0" . Please change the value to "3.0" and try importing it again.

# August 6, 2008 12:44 PM

contumaz said:

HAHAH!!!! Thank you so much!! that really worked! Cheers BCMTeam!

# August 6, 2008 3:31 PM
Anonymous comments are disabled
Page view tracker