Troubleshoot database operations in Business Contact Manager

In this article


Cannot create a Business Contact Manager database - Database creation is unsuccessful

Your Business Contact Manager database uses Microsoft SQL Server Express, a lightweight version of Microsoft SQL Server. If the SQL Server is not available, you cannot create a database. The SQL Server service might not be available for various reasons.

Use the following list of SQL Server scenarios to resolve your issue. Please complete the procedure that most closely resembles your circumstances.

SQL Server issues

ShowStart the SQL Server

If you see the following messages, complete the procedure to start the SQL Server service.

  • Database creation is unsuccessful or failed
  • Cannot create the Business Contact Manager database because the SQL Server service (the Business Contact Manager database service) is not running. Start the service, and then restart Outlook to display the Startup Wizard again.
  • Cannot connect to the local Business Contact Manager database because the SQL Server service (the Business Contact Manager database service) is not running. You can connect to a Business Contact Manager database that is stored on a different computer.
  • Cannot start Business Contact Manager because the SQL Server service (the Business Contact Manager database service) is not running.
Start the SQL Server service

ShowWindows XP

  1. Click Start, and then click Control Panel.
  2. Click Performance and Maintenance.
  3. Click Administrative Tools, and then double-click Services.
  4. Scroll down to SQL Server (MSSMLBIZ), click it, and then click Start.

ShowWindows Vista

  1. Click the Start button, and then click All Programs.
  2. Click Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Configuration Manager.
  3. In the SQL Server Configuration Manager window, in the left pane, click SQL Server 2005 Services.
  4. In the right pane, right-click SQL Server (MSSMLBIZ), and then click Start.
  5. Re-open Microsoft Outlook. You should now be able to connect to the Business Contact Manager database.

For more information on Microsoft SQL Server Express, go to the Microsoft Support Web site, and consult the Knowledge Base.

Top of Page Top of Page

ShowGrant the user account that logs onto the SQL Server service permissions to access the Business Contact Manager folder

By default, the SQL Server service logs on using the Network Service user account to access the Business Contact Manager folder to create a database. If a database cannot be created, it may be that the Network Service user account does not have permissions to log onto the SQL Server.

A different user account can log onto the SQL Server. If an account other than the Network Service user account logs onto the SQL Server, the account should be given read and write permissions to access the Business Contact Manager folder.

To grant the account that logs onto the SQL Server service (Network Service user account or a different user account) permission to access the Business Contact Manager folder, complete the following procedure:

ShowWindows XP

  1. Click Start, and then click My Computer.
  2. Open the Business Contact Manager folder by double-clicking each folder in the following path:

C:\Documents and Settings\[username]\
Local Settings\Application Data\Microsoft\

where [username] is the name of the folder of the user account who cannot create the database.

 Note   The path is the default location of the Business Contact Manager folder. Some of the folders in the path are hidden by default. For information about how to display hidden folders, see Help and Support.

  1. Right-click the Business Contact Manager folder, and then click Properties.
  2. Click the Security tab, and then click Add.

 Note   The Security tab is not available if your computer is a member of a workgroup (workgroup: A simple grouping of computers that helps users find such items as printers and shared folders within that group. Workgroups do not offer the centralized user accounts and authentication offered by domains.) rather than a domain (domain: In Active Directory, a collection of computer, user, and group objects defined by the administrator. These objects share a common directory database, security policies, and security relationships with other domains.). See the Help and Support for Microsoft Office Outlook 2007 with Business Contact Manager (All Languages) web site to contact a support professional. Charges may apply.

  1. In the Select Users, Computers, or Groups dialog box, in the Enter the object names to select box, type Network Service, or the name of the user account that is used to log onto the SQL Server, and then click Check Names.
  2. Click OK.
  3. On the Security tab, click Network Service, or the name of the user account that is used to log onto the SQL Server.

 Note   The Security tab is not available if your computer is a member of a workgroup (workgroup: A simple grouping of computers that helps users find such items as printers and shared folders within that group. Workgroups do not offer the centralized user accounts and authentication offered by domains.) rather than a domain (domain: In Active Directory, a collection of computer, user, and group objects defined by the administrator. These objects share a common directory database, security policies, and security relationships with other domains.). See the Help and Support for Microsoft Office Outlook 2007 with Business Contact Manager (All Languages) web site to contact a support professional. Charges may apply.

  1. Click the Read and Write check boxes respectively, and then click OK.

ShowWindows Vista

  1. Click Start, and then click Computer.
  2. Open the Business Contact Manager folder by double-clicking each folder in the following path:

C:\Users\[username]\AppData\
Local\Microsoft

where [username] is the name of the folder of the user account who cannot create a database.

 Note   The path is the default location of the Business Contact Manager folder. Some of the folders in the path are hidden by default. For information about how to display hidden folders, see Help and Support.

  1. Right-click the Business Contact Manager folder, and then click Properties.
  2. Click the Security tab, and then click Edit.
  3. In the Permissions for Business Contact Manager dialog box, click Add.
  4. In the Select Users, Computers, or Groups dialog box, in the Enter the object names to select box, type Network Service, or the name of the user account that is used to log onto the SQL Server, and then click Check Names.
  5. Click OK.
  6. On the Security tab, click Network Service, or the name of the user account that is used to log onto the SQL Server.
  7. In the Allow column, click the Read and Write check boxes, and then click OK.

Top of Page Top of Page

ShowGrant the Network Service user account full control permission to the MSSQL.1\Data folder

The master Business Contact Manager database files, master.mdf and mastlog.ldf, are stored in the C:\Program Files\Microsoft SQL Server'MSSQL.1\MSSQL\Data folder. Occasionally, the Network Service user account that logs onto the SQL Server does not have permissions to read the private key containers so the database cannot be created.

To give the Network Service user account full control of the MSSQL.1\Data folder, complete the following procedure.

ShowWindows XP

  1. Click Start, and then click My Computer.
  2. Double-click each folder in the following path to open it:

C:\Program Files\Microsoft SQL Server\
MSSQL.1\MSSQL

  1. Right-click the Data folder, and then click Properties.
  2. Click the Security tab, and then click Add.

 Note   The Security tab is not available if your computer is a member of a workgroup (workgroup: A simple grouping of computers that helps users find such items as printers and shared folders within that group. Workgroups do not offer the centralized user accounts and authentication offered by domains.) rather than a domain (domain: In Active Directory, a collection of computer, user, and group objects defined by the administrator. These objects share a common directory database, security policies, and security relationships with other domains.). See the Help and Support for Microsoft Office Outlook 2007 with Business Contact Manager (All Languages) web site to contact a support professional. Charges may apply.

  1. In the Select Users, Computers, or Groups dialog box, in the Enter the object names to select box, type Network Service, and then click Check Names.
  2. Click OK.
  3. On the Security tab, click Network Service.

 Note   The Security tab is not available if your computer is a member of a workgroup (workgroup: A simple grouping of computers that helps users find such items as printers and shared folders within that group. Workgroups do not offer the centralized user accounts and authentication offered by domains.) rather than a domain (domain: In Active Directory, a collection of computer, user, and group objects defined by the administrator. These objects share a common directory database, security policies, and security relationships with other domains.). See the Help and Support for Microsoft Office Outlook 2007 with Business Contact Manager (All Languages) web site to contact a support professional. Charges may apply.

  1. In the Allow column, click the Full Control check box, and then click OK.

ShowWindows Vista

  1. Click Start, and then click Computer.
  2. Double-click each folder in the following path to open it:

C:\Program Files\Microsoft SQL Server\
MSSQL.1\MSSQL

  1. Right-click the Data folder, and then click Properties.
  2. Click the Security tab, and then click Edit.
  3. In the Permissions for Data dialog box, click Add.
  4. In the Select Users, Computers, or Groups dialog box, in the Enter the object names to select box, type Network Service, and then click Check Names.
  5. Click OK.
  6. On the Security tab, click Network Service.
  7. In the Allow column, click the Full Control check box, and then click OK.

Top of Page Top of Page

ShowProtocol for the SQL Server is not enabled (Windows Vista only)

The Named Pipe protocol for the SQL Server is disabled. This issue sometimes occurs when using Windows Vista. Use the following procedure to enable the protocol.

  1. Click the Start button, and then click All Programs.
  2. Click Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Configuration Manager.
  3. In the SQL Server Configuration Manager, click SQL Server 2005 Network Configuration, and then click Protocols for MSSMLBIZ.
  4. In the right pane, double-click Named Pipes.
  5. In the Named Pipes Properties dialog box, click the arrow to the right of Enabled, and then select Yes.

Close the SQL Server Configuration Manager window, and then start Outlook to complete the Startup Wizard and create the database.

Top of Page Top of Page

ShowUse the Local System user account to log onto the SQL Server

If, after completing the preceding procedures, you still cannot create a database because the SQL Server service will not start, use the Local System user account to log onto the SQL Server.

ShowWindows XP

  1. Click Start, and then click Control Panel.
  2. Click Performance and Maintenance.
  3. Click Administrative Tools, and then double-click Services.
  4. Right-click SQL Server (MSSMLBIZ), and then click Properties.
  5. Click the Log On tab, and then click Local System account.
  6. Start Outlook and then complete the Startup Wizard.

ShowWindows Vista

  1. Click the Start button, and then click All Programs.
  2. Click Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Configuration Manager.
  3. In the SQL Server Configuration Manager window, click SQL Server 2005 Services.
  4. In the right pane, right-click SQL Server (MSSMLBIZ), and then click Properties.
  5. On the Log On tab, under Built-in account, click the arrow, and then click Local System.
  6. Start Outlook, and then complete the Startup Wizard.

See the Help and Support for Microsoft Office Outlook 2007 with Business Contact Manager (All Languages) web site to contact a support professional. Charges may apply.

Top of Page Top of Page

Compressed drive, guest account, and missing Startup Wizard issues

ShowCompressed drive or folder

On an NTFS file system drive, the folder in which the database is being installed is compressed. The Business Contact Manager database (Business Contact Manager database: The database that stores information about Accounts, Business Contacts, Opportunities, Business Projects, and other items.) cannot be created in a compressed folder that was created on an NTFS (NTFS:An enhanced file system that heightens reliability, by providing transaction logs to help recover from disk failures; security, by enabling permission setting for directories or individual files; and other features not found in the FAT file system.) file system drive. In order to create the database, the file compression setting must be disabled for the Business Contact Manager folder.

 Note   You must be logged on as an administrator to enable or disable compression.

Disable folder compression
  1. Open My Computer.
  2. Double-click a drive or folder.
  3. Right-click the folder where you want to install Business Contact Manager for Outlook. (This is usually C:\Documents and Settings\[username]\Local Settings\Application Data\Microsoft\Business Contact Manager\.)
  4. Click Properties.
  5. On the General tab, click Advanced.
  6. Clear the Compress contents to save disk space check box, and then click OK.

After you have disabled compression on the folder, retry creating the database.

ShowYou have logged on to Outlook by using a guest account

As a guest user, you are not allowed to create a Business Contact Manager database.

ShowI have installed Business Contact Manager for Outlook, but I was not prompted to create a new database

The Startup wizard runs automatically the first time you run Outlook after you have installed and activated Business Contact Manager for Outlook. If you choose to run the Startup wizard, you will be given the opportunity either to create a new Business Contact Manager database (Business Contact Manager database: The database that stores information about Accounts, Business Contacts, Opportunities, Business Projects, and other items.) or to select an existing database.

  1. Verify that Business Contact Manager for Outlook is installed.

ShowHow?

ShowMicrosoft Windows XP

  1. On the Start menu, click Control Panel.
  2. In Control Panel, click Add or Remove Programs, and then click Remove a program.
  3. In the Currently installed programs list , check to see whether Business Contact Manager for Outlook 2007 appears.

ShowWindows Vista

  1. On the Start menu, click Control Panel.
  2. In Control Panel, under Programs, click Uninstall a program.
  3. On the Uninstall or change a program page, check to see whether Business Contact Manager for Outlook 2007 appears.
  1. If Business Contact Manager for Outlook 2007 does not appear in the Currently installed programs list, do one of the following:
  • If you have the Business Contact Manager for Outlook 2007 CD, install the program from that CD.

 Note   The installation CD for Business Contact Manager for Outlook is included with the following 2007 Microsoft Office suites: Microsoft Office Professional 2007, Microsoft Office Small Business 2007, and Microsoft Office Ultimate 2007.

  • If you received Business Contact Manager for Outlook with your computer purchase (and, therefore, do not have a CD) you need to configure Business Contact Manager for Outlook.

ShowHow?

  • In Outlook, on the Help menu, click Configure Business Contact Manager, and follow the instructions.

Top of Page Top of Page

Cannot start Business Contact Manager for Outlook

Try the following procedures and then restart Outlook.

ShowCannot start Business Contact Manager because the SQL Server service (the Business Contact Manager database service) is not running.

The master Business Contact Manager database files, master.mdf and mastlog.ldf, are stored in the C:\Program Files\Microsoft SQL Server'MSSQL.1\MSSQL\Data folder. The folder also contains security certificates (http://support.microsoft.com/kb/900495) that allow the SQL Server to create the Business Contact Manager database. Occasionally, the Network Service user account that logs onto the SQL Server cannot access the folder so the database cannot be created.

This might occur after changing the file system for a drive from FAT32 to NTFS on a computer running Windows XP.

To give the Network Service user account full control of the MSSQL.1\Data folder, complete the following procedure.

ShowWindows XP

  1. Click Start, and then click My Computer.
  2. Double-click each folder in the following path to open it:

C:\Program Files\Microsoft SQL Server\
MSSQL.1\MSSQL

  1. Right-click the Data folder, and then click Properties.
  2. Click the Security tab, and then click Add.

 Note   The Security tab is not available if your computer is a member of a workgroup (workgroup: A simple grouping of computers that helps users find such items as printers and shared folders within that group. Workgroups do not offer the centralized user accounts and authentication offered by domains.) rather than a domain (domain: In Active Directory, a collection of computer, user, and group objects defined by the administrator. These objects share a common directory database, security policies, and security relationships with other domains.). See the Help and Support for Microsoft Office Outlook 2007 with Business Contact Manager (All Languages) web site to contact a support professional. Charges may apply.

  1. In the Select Users, Computers, or Groups dialog box, in the Enter the object names to select box, type Network Service, and then click Check Names.
  2. Click OK.
  3. On the Security tab, click Network Service.

 Note   The Security tab is not available if your computer is a member of a workgroup (workgroup: A simple grouping of computers that helps users find such items as printers and shared folders within that group. Workgroups do not offer the centralized user accounts and authentication offered by domains.) rather than a domain (domain: In Active Directory, a collection of computer, user, and group objects defined by the administrator. These objects share a common directory database, security policies, and security relationships with other domains.). See the Help and Support for Microsoft Office Outlook 2007 with Business Contact Manager (All Languages) web site to contact a support professional. Charges may apply.

  1. In the Allow column, click the Full Control check box, and then click OK.

ShowWindows Vista

  1. Click Start, and then click Computer.
  2. Double-click each folder in the following path to open it:

C:\Program Files\Microsoft SQL Server\
MSSQL.1\MSSQL

  1. Right-click the Data folder, and then click Properties.
  2. Click the Security tab, and then click Edit.
  3. In the Permissions for Data dialog box, click Add.
  4. In the Select Users, Computers, or Groups dialog box, in the Enter the object names to select box, type Network Service, and then click Check Names.
  5. Click OK.
  6. On the Security tab, click Network Service.
  7. In the Allow column, click the Full Control check box, and then click OK.
  8. Start Outlook with Business Contact Manager.

ShowSQL Server service does not start after granting permissions to the Network Service user account.

The SQL Server usually starts with a security certificate and does not use encryption. Sometimes, the SQL Server service does not turn off encryption. If this occurs, turn off encryption for the SQL Server instance.

ShowWindows XP

  1. Click Start, and then click Control Panel.
  2. Click Performance and Maintenance, and then click Administrative Tools.
  3. Double-click Computer Management.
  4. Click Services and Applications, and then double-click SQL Server Configuration Manager.
  5. Double-click SQL Server 2005 Network Configuration.
  6. Right-click Protocols for MSSMLBIZ, and then click Properties.
  7. On the Flags tab, click the arrow at the end of the Force Encryption row, and then click No.
  8. Click OK to close the dialog box.
  9. Click SQL Server 2005 Services.
  10. In the right pane, right-click SQL Server (MSSMLBIZ). and then click Start.
  11. Restart Outlook and then complete the Startup Wizard.

ShowWindows Vista

  1. Click the Start button, and then click All Programs.
  2. Click Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Configuration Manager.
  3. In the SQL Server Configuration Manager window, click SQL Server 2005 Network Configuration.
  4. In the right pane, right-click Protocols for MSSMLBIZ, and then click Properties.
  5. On the Flags tab, in the Force Encryption row, click the arrow, and then click No.
  6. Start Outlook, and then complete the Startup Wizard.

ShowUse the Local System user account to log onto the SQL Server

If, after completing the preceding procedures, Business Contact Manager will not start, use the Local System user account to log onto the SQL Server.

ShowWindows XP

  1. Click Start, and then click Control Panel.
  2. Click Performance and Maintenance.
  3. Click Administrative Tools, and then double-click Services.
  4. Right-click SQL Server (MSSMLBIZ), and then click Properties.
  5. Click the Log On tab, and then click Local System account.
  6. Start Outlook and then complete the Startup Wizard.

ShowWindows Vista

  1. Click the Start button, and then click All Programs.
  2. Click Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Configuration Manager.
  3. In the SQL Server Configuration Manager window, click SQL Server 2005 Services.
  4. In the right pane, right-click SQL Server (MSSMLBIZ), and then click Properties.
  5. On the Log On tab, under Built-in account, click the arrow, and then click Local System.
  6. Start Outlook, and then complete the Startup Wizard.

Top of Page Top of Page

Cannot open database - login failed

The most common reason that this message is displayed during database creation is because the user account used to log onto the SQL Server service does not have read and write permissions for the Business Contact Manager folder.

By default, the SQL Server service logs on using the Network Service user account to access the Business Contact Manager folder to create a database. The user account used by the SQL Server service might have been changed.

To resolve this issue complete the following procedures:

  1. ShowVerify which user account logs onto the SQL Server.

ShowWindows XP

  1. Click Start, and then click Control Panel.
  2. Click Performance and Maintenance.
  3. Click Administrative Tools, and then double-click Services.
  4. Right-click SQL Server (MSSMLBIZ), and then click Properties.
  5. Click the Log On tab, and then note the name of the account listed in the This account box.

ShowWindows Vista

  1. Click the Start button, and then click All Programs.
  2. Click Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Configuration Manager.
  3. In the SQL Server Configuration Manager window, click SQL Server 2005 Services.
  4. In the right pane, right-click SQL Server (MSSMLBIZ), and then click Properties.
  5. On the Log On tab, note the Account name used to log on to the SQL Server.
  1. ShowGrant the user account that logs onto the SQL Server read and write permissions for the Business Contact Manager folder.

ShowWindows XP

  1. Click Start, and then click My Computer.
  2. Open the Business Contact Manager folder by double-clicking each folder in the following path:

C:\Documents and Settings\[username]\
Local Settings\Application Data\Microsoft\

where [username] is the name of the folder of the user account who cannot create the database.

 Note   The path is the default location of the Business Contact Manager folder. Some of the folders in the path are hidden by default. For information about how to display hidden folders, see Help and Support.

  1. Right-click the Business Contact Manager folder, and then click Properties.
  2. Click the Security tab, and then click Add.

 Note   The Security tab is not available if your computer is a member of a workgroup (workgroup: A simple grouping of computers that helps users find such items as printers and shared folders within that group. Workgroups do not offer the centralized user accounts and authentication offered by domains.) rather than a domain (domain: In Active Directory, a collection of computer, user, and group objects defined by the administrator. These objects share a common directory database, security policies, and security relationships with other domains.). See the Help and Support for Microsoft Office Outlook 2007 with Business Contact Manager (All Languages) web site to contact a support professional. Charges may apply.

  1. In the Select Users, Computers, or Groups dialog box, in the Enter the object names to select box, type the name of the user account that is used to log onto the SQL Server, and then click Check Names.
  2. Click OK.
  3. On the Security tab, click the name of the user account that is used to log onto the SQL Server.

 Note   The Security tab is not available if your computer is a member of a workgroup (workgroup: A simple grouping of computers that helps users find such items as printers and shared folders within that group. Workgroups do not offer the centralized user accounts and authentication offered by domains.) rather than a domain (domain: In Active Directory, a collection of computer, user, and group objects defined by the administrator. These objects share a common directory database, security policies, and security relationships with other domains.). See the Help and Support for Microsoft Office Outlook 2007 with Business Contact Manager (All Languages) web site to contact a support professional. Charges may apply.

  1. Click the Read and Write check boxes respectively, and then click OK.

ShowWindows Vista

  1. Click Start, and then click Computer.
  2. Open the Business Contact Manager folder by double-clicking each folder in the following path:

C:\Users\[username]\AppData\
Local\Microsoft

where [username] is the name of the folder of the user account who cannot create a database.

 Note   The path is the default location of the Business Contact Manager folder. Some of the folders in the path are hidden by default. For information about how to display hidden folders, see Help and Support.

  1. Right-click the Business Contact Manager folder, and then click Properties.
  2. Click the Security tab, and then click Edit.
  3. In the Permissions for Business Contact Manager dialog box, click Add.
  4. In the Select Users, Computers, or Groups dialog box, in the Enter the object names to select box, type the name of the user account that is used to log onto the SQL Server, and then click Check Names.
  5. Click OK.
  6. On the Security tab, click the name of the user account that is used to log onto the SQL Server.
  7. In the Allow column, click the Read and Write check boxes, and then click OK.

Top of Page Top of Page

Cannot connect to computer or shared Business Contact Manager database

ShowI received a message stating that the computer I am looking for cannot be found

  • Check with the owner of the database that you are trying to connect to, and verify the computer name.
  • Verify that the computer is connected to the network and is accessible. The PING protocol can help you verify the computer's connection status. For more information about the PING protocol, see Windows Help.
  • Check with the administrator of the remote computer to see if a firewall may be blocking network traffic. In Windows Firewall, on the Exceptions tab, ensure that the File and Printer Sharing exception is selected, so that Business Contact Manager for Outlook can detect the existence of a remote computer for sharing.

ShowI received a message that says, Cannot connect to database.

More than likely, the Business Contact Manager database that you want to use is a shared database on a different computer and it is offline. Verify that the computer where the database is located is turned on. The shared database and all computers that connect to it must be running the same version of Business Contact Manager for Outlook.

If the database is on the same computer, verify that the SQL Server service is started. For information about how to start the SQL Server service, see this section, Cannot create a Business Contact Manager database - Database creation unsuccessful.

ShowI received a message stating that the database server that I am looking for is inaccessible

  • Verify that a shared Business Contact Manager database exists on the computer.
  • Verify that firewall settings on the remote computer are permitting connections to the Business Contact Manager database (through TCP port 5356). You might also want to change the scope to allow any computers to access the port. For more information see, How do I change my Windows settings so I can share my Business Contact Manager database with users on other computers?
  • Verify that the computer on which the database is located is turned on.
  • The database on the remote computer may be stopped or paused. Verify that the database service, SQL Server, is running.

ShowHow?

Start the SQL Server service

ShowWindows XP

  1. Click Start, and then click Control Panel.
  2. Click Performance and Maintenance.
  3. Click Administrative Tools, and then double-click Services.
  4. Scroll down to SQL Server (MSSMLBIZ), click it, and then click Start.

ShowWindows Vista

  1. Click the Start button, and then click All Programs.
  2. Click Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Configuration Manager.
  3. In the SQL Server Configuration Manager window, in the left pane, click SQL Server 2005 Services.
  4. In the right pane, right-click SQL Server (MSSMLBIZ), and then click Start.
  5. Re-open Microsoft Outlook. You should now be able to connect to the Business Contact Manager database.

For more information on Microsoft SQL Server Express, go to the Microsoft Support Web site, and consult the Knowledge Base.

ShowI received a message stating that the Business Contact Manager database I am looking for cannot be found

  • Verify with the database owner that you have been granted access to the shared database.
  • Verify that you have the same version of Business Contact Manager for Outlook installed as the version used by the shared database. You cannot use a database shared out by a version of Business Contact Manager for Outlook that is different from the version that you have installed.

Top of Page Top of Page

Cannot restore a Business Contact Manager database

ShowI received a message stating that I cannot restore a database because I was not authorized to back up or restore databases or because I am not the owner of the database.

You are not the database owner (database owner: The person who created the database, and has full control, including granting access permissions or deleting records. When a database has been restored, then the person who restored it becomes the owner.) of the database you want to restore. Occasionally, after upgrading from Windows XP to Windows Vista, the database owner is not recognized as the database owner. To restore the database, you must be the administrator (administrator: The person in charge of managing a Windows computer. The administrator is responsible for installing software, assigning passwords, and managing files.) on the computer where you want to restore the database, and you must be running Outlook as an administrator. Do the following:

  • Ask your system administrator to add you to the Administrators group or add yourself to the Administrators group.
  • Run Outlook as an administrator.

ShowHow?

  1. In Outlook, on the File menu, click Exit to close Outlook.
  2. Click the Start button, and then click Computer.
  3. Click drive C, named Local Disk (C), to explore your hard drive.

 Note   If you have installed the stand-alone edition of Microsoft Office Outlook 2007 with Business Contact Manager or the 2007 Office System to a different drive, browse to that location.

  1. Click Program Files, and then click Microsoft Office.
  2. Click Office 12.
  3. Right-click the Outlook icon, and then click Run as administrator.

You can now perform all administrator tasks in Outlook, including restoring a Business Contact Manager database.

Top of Page Top of Page

SQL Server does not install or start

ShowI received a message stating that Microsoft SQL Server has not been installed

The Business Contact Manager database is built using Microsoft SQL Server. Without SQL Server, you are not able to use Business Contact Manager for Outlook. For assistance with SQL Server, go to the Microsoft Support Web site, and consult the Knowledge Base.

ShowSQL Server service did not start automatically

In most cases, SQL Server, which is installed with Business Contact Manager for Outlook starts automatically. Business Contact Manager for Outlook will not start if the SQL Service does not start. If you do not see any other messages, and you do not see Business Contact Manager for Outlook menus, start the SQL Server service manually by completing the following procedure:

ShowIn Windows XP

  1. Click Start, right-click My Computer, and then click Manage.
  2. Double-click Services and Applications to expand the list.
  3. Double-click Services.
  4. In the Services window, click MSSQL$MSMLBIZ.
  5. In the Status column, verify that the MSSQL$MSMLBIZ service is not started.
  6. Click Restart the service.
  7. Close the Computer Management window, and then start Outlook.

ShowIn Windows Vista

  1. Click Start, right-click Computer, and then click Manage.
  2. Click Services and Applications.
  3. Double-click Services.
  4. In the Services window, click SQL Server (MSSMLBIZ).
  5. In the Status column, verify that the SQL Server (MSSMLBIZ) service is not started.
  6. Click Restart the service.
  7. Close the Computer Management window, and then start Outlook.

ShowI want to use Business Contact Manager for Outlook with a different SQL Server Express instance name

If your Business Contact Manager database is on your local computer, as opposed to it being shared from a remote computer, the supported SQL Server Express instance name is MSSMLBIZ. Other instance names are not supported.

Rather than trying to use Business Contact Manager for Outlook with an unsupported instance name, install another SQL Server Express instance and name it MSSMLBIZ. The SQL Server Express instance should log on using the built-in Network Service user account.

To verify that the SQL Server instance logs on using the Network Service user account, complete the following procedure in Windows Vista:

  1. Click Start, and then click All Programs.
  2. Click Microsoft SQL Server 2005, and then click Configuration Tools.
  3. Click SQL Service Configuration Manager.
  4. Right-click SQL Server (MSSMLBIZ), and then click Properties.
  5. Under Built-in account, verify that Network Service appears.
  6. Click OK to close the SQL Server (MSSMLBIZ) Properties dialog box.
  7. Start Outlook to start the Business Contact Manager Startup Wizard, and then follow the instructions on your screen.

ShowSQL Server failed to install

Error code 2147746132 (0x80040154) is displayed. Try using the WMI diagnostics utility to learn more information about the error. The tool is found here: http://www.microsoft.com/technet/scriptcenter/topics/help/wmidiag.mspx

 Note   If you have additional questions about SQL Server Express, try posting them on the SQL Server Express Forum on MSDN: http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=385&SiteID=1

Top of Page Top of Page

Cannot migrate Business Contact Manager database

ShowI see the message, Database migration was unsuccessful after selecting an existing database

Try again to use the database, by clicking Select an existing database in the Startup Wizard.

If you continue to receive the Database migration was unsuccessful message, try the following:

  1. Uninstall Business Contact Manager for Outlook 2007.

ShowHow?

  1. Click Start, and then click Control Panel.
  2. Click Add or Remove Programs.
  3. Click Business Contact Manager for Outlook 2007, and then click Change/Remove.
  1. Reinstall Business Contact Manager for Outlook 2003.
  2. In the Startup Wizard, click Select a database, and then follow the instructions on your screen.
  3. Export all of the information in the Business Contact Manager for Outlook 2003 database.

ShowHow?

  1. On the File menu, point to Import and Export, and then click Business Contact Manager for Outlook..
  2. Click Export a file.
  3. Click Business Contact Manager data (.bcm), and then follow the instructions on your screen.
  1. Install Business Contact Manager for Outlook 2007.
  2. In the Startup Wizard, click Create a new database, and then follow the instructions on your screen.
  3. On the File menu, point to Import and Export, and then click Business Contact Manager for Outlook.
  4. Click Import a file.
  5. Click Business Contact Manager data (.bcm), and then follow the instructions on your screen.

If database migration continues to be unsuccessful, see the Help and Support for Microsoft Office Outlook 2007 with Business Contact Manager (All Languages) web site. Charges may apply.

Top of Page Top of Page

Cannot load Business Contact Manager database

ShowI received a message stating that My database cannot be loaded after upgrading to Windows Vista from Windows XP.

Several Business Contact Manager for Outlook messages are displayed that indicate that there are problems with the Business Contact Manager database after upgrading to Windows Vista.

The following messages could be displayed:

  • Business Contact Manager for Outlook could not connect to the shared database.
    • Business Contact Manager database cannot be loaded.
    • This action cannot be completed because Business Contact Manager cannot access the database
    • An error has occurred while establishing a connection to the server

Try the following:

Change the Log On property for the SQL Server (MSSMLBIZ) instance to Local System.

ShowHow?

  1. In Windows Vista, click the Start button, and then click All Programs.
  2. Click Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Configuration Manager.
  3. In the SQL Server Configuration Manager, window, click SQL Server 2005 Services, right-click SQL Server (MSSMLBIZ), and then click Properties.
  4. Under Built-in account, click Local System, and then click OK.
  5. Restart Outlook.

Top of Page Top of Page

Remove Business Contact Manager for Outlook

ShowI want to remove Business Contact Manager for Outlook from all user profiles on a computer

Uninstalling Business Contact Manager for Outlook removes it from all users on that computer.

You might need to remove Business Contact Manager for Outlook if Outlook does not open or if you want to stop the Startup wizard from displaying and skip creating a database.

  1. Click Start, and then click Control Panel.
  2. Click Add or Remove Programs.
  3. Click Business Contact Manager for Outlook 2007, and then click Change/Remove.

You can remove Business Contact Manager for Outlook from your own profile on a computer that has multiple users and it will not be removed from other users' profiles.

ShowHow?

  1. On the File menu, click Data File Management.
  2. Click the Data Files tab.
  3. Click Business Contact Manager, and then click Remove.

Business Contact Manager folders are missing

ShowI can't see my Business Contact Manager folders

If your Business Contact Manager folders do not appear in the Navigation Pane (Navigation Pane: The column on the left side of the Outlook window that includes panes such as Shortcuts or Mail and the shortcuts or folders within each pane. Click a folder to show the items in the folder.), you need to associate Business Contact Manager for Outlook with your profile.

  1. On the File menu, click Data File Management.
  2. Click the Data Files tab.
  3. Click Add.
  4. In the New Outlook Data File dialog box, under Types of storage, click Business Contact Manager Database.
  5. Click OK.
  6. In the Startup wizard, do one of the following:
  • If you installed Business Contact Manager for Outlook for the first time, click Create a new database.
  • In the Database name box, type a name for the new database, by default MSSmallBusiness, and then click Next.
  • If you are restoring a previous database, click Select an existing database.
  • In the Computer name box, type the name of the computer on which the database is located, and then click Connect.
  • In the Database name box, click the database that you want to restore, and then click Next.
  1. Restart Outlook.

Top of Page Top of Page

Where is the Business Contact Manager database?

ShowWhere is my Business Contact Manager database?

The name of your Business Contact Manager database is the name that the database owner used when he or she created the database. The Business Contact Manager database is a SQL Server database, so the database has two components, the main database and the log file for the database.

The database files are located in the following folder:

ShowWindows XP

In Windows XP, the Business Contact Manager database and log files are stored in the following folder:

C:\Documents and Settings\<username>\
Local Settings\Application Data\Microsoft\
Business Contact Manager\<databasename.mdf>

where username is the name of the database owner and database name is the name, by default MSSmallBusiness of the Business Contact Manager database.

 Note   You must display hidden files and folders to some of the files in the path. For information about how to display hidden folders, see Help and Support

C:\Documents and Settings\<username>\
Local Settings\Application Data\Microsoft\
Business Contact Manager\<databasename.ldf>

where username is the name of the database owner and database name is the name, by default MSSmallBusiness, of the Business Contact Manager database.

ShowWindows Vista

C:\Users\<username>\AppData\Local\
Microsoft\Business Contact Manager\<databasename.mdf>

where username is the name of the database owner and database name is the name, by default MSSmallBusiness, of the Business Contact Manager database.

 Note   You must display hidden files and folders to some of the files in the path. For information about how to display hidden folders, see Help and Support

C:\Users\<username>\AppData\Local\
Microsoft\Business Contact Manager\<databasename.ldf>

where username is the name of the database owner and database name is the name, by default MSSmallBusiness, of the Business Contact Manager database.

Install Business Contact Manager for Outlook on a server

ShowI want to install Business Contact Manager for Outlook on a remote server

For more information about how to use Business Contact Manager for Outlook on a remote server, install the Business Contact Manager Database Admin Tool.

Top of Page Top of Page

Records and items are not sorting correctly

ShowMy records and items are not sorting correctly

To correctly sort records and items in a database, you need to use the same language version of Business Contact Manager for Outlook as the language version of Windows that is installed on your computer.

For more information about language versions, see the Regional and Language Options topic in Windows Help.

Top of Page Top of Page

Import business data

ShowI'm looking for information about how to import business data from a different program.

For information about importing business data from a different program, see Import and export business data in Business Contact Manager.

Workgroup issues only

ShowI received a message stating that the remote user account I am looking for could not be found

In workgroup (workgroup: A simple grouping of computers that helps users find such items as printers and shared folders within that group. Workgroups do not offer the centralized user accounts and authentication offered by domains.) environments, you must have a user account on the computer on which the shared database is located. Check with the administrator of the remote computer to confirm that your user account exists.

ShowI restored a shared database, but users cannot access the database

If you have restored a database that was previously shared with a different computer, the old user names and passwords will not be recognized by the new computer. You must stop sharing the database and then share it again after you have restored it. In the process of sharing it again, you can then add users to access the database.

ShowI received a message stating that verification of my remote user account has failed

Verify with the administrator of the remote machine that Simple File Sharing is not enabled and that the database is shared out.

ShowI received a message stating the following: Logon failure: user account restriction

The computer on which the database is located may not allow blank passwords, may have logon restrictions by hour, or may have a policy that restricts the frequency of password changes that are allowed. Consider asking the administrator to reset your password manually.

Top of Page Top of Page

ShowI received a message stating that the password does not meet password policy requirements.

The computer on which the database is located may have password policies that require a minimum password length or special characters to be included in a password, or password history may be tracked to ensure pre-existing passwords are not reused. Consider asking the administrator to change your password manually.

ShowI received a message stating that Microsoft Office Outlook 2007 with Business Contact Manager could not change my password

  • Your remote account may have been locked out. This issue can occur if you type your remote password incorrectly and the security policy is configured to lock out user accounts after a set number of failed logon attempts. The administrator may need to reset your user account.
  • Your remote account may be unavailable. Consider asking the administrator to reset your account.
  • Your remote account may have the User must change password at next logon setting enabled. You cannot use the remote password change functionality for Business Contact Manager for Outlook if this setting is enabled. Either ask the administrator of the remote computer to disable this setting on your remote user account, or manually reset your password.
  • Your remote account may have the User cannot change password setting enabled. The administrator must manually reset your password or disable this setting on your user account.
  • If you have a blank password, the use of blank passwords for network authentication may be disabled. We recommend that you use non-blank passwords to access Business Contact Manager remote databases.

Top of Page Top of Page

Additional resources

 Note    In June 2010, the Business Contact Manager for Outlook Discussion Group was moved to the Microsoft Office Forum.

Top of Page Top of Page

 
 
Applies to:
Outlook 2007