Troubleshoot installing Business Contact Manager for Outlook 2010: SQL Server 2008 Express

The following list includes common SQL Server 2008 Express installation issues encountered by Business Contact Manager for Outlook 2010 customers.

Note:  Advanced users may be more comfortable trying the resolutions that are listed in this topic.

What is the installation issue that you want to resolve?

SQL Server 2008 cannot be installed until your computer is restarted

You must start the SQL Server service

You must install SQL Server 2008 Express because the Business Contact Manager for Outlook 2010 setup program cannot install SQL Server for you

The setup program cannot install SQL Server 2008 Express because another version of SQL Server is installed

The setup program failed to install SQL Server 2008 Express

Check the SQL Server log files

Why Business Contact Manager for Outlook also installs SQL Server 2008 Express

Check SQL Server Knowledge Base articles for more information

SQL Server 2008 cannot be installed until your computer is restarted

The SQL Server 2008 Express installation program checks for "restart required" notifications from the version of Windows that your computer is running. If the program finds a notification that your computer should be restarted, SQL Server will not install. You must restart your computer, and then start the Business Contact Manager for Outlook setup program again.

If, after restarting your computer and the Business Contact Manager for Outlook setup program, you are again prompted to restart your computer, do the following:

1. Check to see if Windows Update lists any important updates for you to install and then please install them.

   How do I open Windows Update?

   1. Click Start, and then point to All Programs.

   2. Click Windows Update.

2. Please restart your computer if you are prompted to restart it.

3. Start the Business Contact Manager setup program again.

If SQL Server 2008 Express still will not install, download and install SQL Server 2008 Express Runtime from the Microsoft web site. Then run the Business Contact Manager for Outlook setup program again.

You might also want to check the Business Contact Manager log file, Temp\BCMrebootcheck*.log, for information about issues that are related to restarting your computer.

Note:  The asterisk (*) represents letters and numbers in the file name.

Open your Temp folder and the BCMrebootcheck*.log file

1. Do the following:

   • In Windows XP, click Start, and then click Run.

   • In Windows Vista and Windows 7, click Start.

2. Type %temp% and then press ENTER.

Note:  %Temp% represents the path, usually C:\Users\user name\AppData\Local\Temp, to your Temp folder.

1. Open the BCMrebootcheck*.log file.

Top of Page

You must start the SQL Server service

Sometimes, even though SQL Server is installed, the SQL Server service cannot start. The SQL Server Service must be running to complete Business Contact Manager for Outlook setup. A message will prompt you to start the SQL Server service.

You must start the SQL Server (MSSMLBIZ) service and set it to start automatically.

1. Open Administrative Tools in Control Panel.

How?

1. Click Start, and then click Control Panel.

2. If necessary, change the view to display all Control Panel options.

   • In Windows XP, in Control Panel, click Switch to Classic View.

   • In Windows Vista, under Control Panel Home, click Classic View.

   • In Windows 7, click Category, and then click Large icons or Small icons.

3. Double-click Administrative Tools.

1. Double-click Services.

2. Right-click SQL Server (MSSMLBIZ), and then click Properties.

3. On the General tab, do the following:

   1. In the Startup type box, click Automatic.

   2. In the Service status section, click Start.

4. Click OK to close the dialog box.

5. Close Services.

Top of Page

You must install SQL Server 2008 Express because the Business Contact Manager for Outlook 2010 setup program cannot install SQL Server for you

If SQL Server is not installed, Business Contact Manager for Outlook cannot be installed.

1. Download and install SQL Server 2008 Express Runtime from the Microsoft web site.

2. Run the Business Contact Manager for Outlook setup program again.

Top of Page

The setup program cannot install SQL Server 2008 Express because another version of SQL Server is installed

If SQL Server is already installed on your computer, the Business Contact Manager for Outlook setup program may not be able to install SQL Server 2008 Express.

Uninstall the other version of SQL Server, and then run the Business Contact Manager for Outlook 2010 setup program again.

Use the following procedure to remove the existing version of SQL Server.

1. Click Start, and then click Control Panel.

2. Do the following:

   • In Windows XP, if necessary, click Switch to Classic View, and then double-click Add or Remove Programs.

   • In Windows Vista and Windows 7, click Control Panel, and then under Programs, click Uninstall a program.

3. Click Microsoft SQL Server 2008, and then click Uninstall.

   If other programs also use SQL Server 2008, you will be prompted to specify the instance that you want to remove. Choose the MSSMLBIZ instance.

SQL Server 2008 Express might not install if there's another version of SQL Server on your computer for various reasons. For example, if the existing version of SQL Server is in a different language than the version of SQL Server 2008 Express that is being installed, the install will fail. Another reason the installation could fail is because the permissions on the version of SQL Server that is installed on the computer prevent the Business Contact Manager for Outlook setup program from updating some SQL Server files.

Top of Page

The setup program failed to install SQL Server 2008 Express

This issue sometimes occurs if the drive where Business Contact Manager for Outlook 2010 is going to be installed is compressed or encrypted using regular encryption or BitLocker.

Decompress or remove encryption from the folder or drive where Business Contact Manager for Outlook is going to be installed, and then try to install Business Contact Manager for Outlook again.

Top of Page

Check the SQL Server log files

The SQL Server install program creates several log files while installing SQL Server. If there is a problem installing SQL Server, first open a file named Summary.txt. The file indicates which log files contain more detailed information about why SQL Server could not be installed. Look for the Summary.txt file in the following folder:

C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\

If the SQL Server Summary.txt file says that the SQL Server installer completed successfully but the Business Contact Manager for Outlook setup program says that SQL Server is not installed, do the following.

1. Open your %Temp% folder.

   1. Do one of the following:

      • In Windows XP, click Start, and then click Run.

      • In Windows Vista and Windows 7, click Start.

   2. Type %temp% and then press ENTER.

      Note:  %Temp% represents the path, usually, C:\Users\user name\App Data\Local\Temp.

2. Open the BCMSetupWizardtmp*.log file with the most recent date.
   

   Note:  The asterisk (*) represents letters and numbers in the file name.

3. Look for information about any errors that have occurred.

Other folders where SQL Server log files are created

C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log

C:\Program Files\Microsoft SQL Server\MSSQL10.MSSMLBIZ\MSSQL\Log

Note:  On 64-bit versions of Windows, the path will start with C:\Program Files (x86).

Top of Page

Why Business Contact Manager for Outlook also installs SQL Server 2008 Express

Business Contact Manager for Outlook stores your data in a SQL Server database named MSSMLBIZ. The database is an instance of SQL Server. Other programs might also use SQL Server, but not the same instance that is used by Business Contact Manager for Outlook.

When you start the Business Contact Manager for Outlook setup program, it checks to see if SQL Server is already installed. If not, the SQL Server 2008 Express install program is run first. Then, the Business Contact Manager for Outlook setup program runs.

Top of Page

Check SQL Server Knowledge Base articles for more information

• SQL Server 2008 installation fails when you try to install SQL Server a second time

• FIX: SQL Server Setup may be unsuccessful when you try to install SQL Server 2008

• SQL Server 2008 setup may fail with "Setup Failure in SetupActionName: gatherusersettings" error message

• SQL Server 2008 setup may fail with an unknown exception on MSVCR80.DLL

• SQL Server 2008 setup program may fail with an unhandled exception when installing from a network location

• Windows File Protection error for "msxml6r.dll" in setup of SQL on localized Windows XP SP3

• FIX: SQL Server 2008 Setup fails if you installed the security update package 954459 for MSXML Core Services 6.0

Top of Page