The video demo for sharing business contact manager has been published on office online, you can find it here: http://office.microsoft.com/en-us/outlook/HA102258501033.aspx
Troubleshoot for sharing issues
Q: I have two computers in a Workgroup with same user account and sharing doesn’t work.
A: Please refer to the demo for how to share a BCM Database at http://office.microsoft.com/en-us/outlook/HA102258501033.aspx
Q: Windows Desktop Search can search the BCM database, but the instant search within outlook does not seem to in a shared environment.
A: Outlook instant search can search local BCM Database. Although in case of a shared remote database it’s not currently supported by outlook.
Q: How do I separate sharing Business and Personal Contacts?
A: You should keep your personal contacts and information in Outlook contacts on his PC, and use BCM contacts for business.
Q: All users running XP or Vista with Office 2007 and Some Anti-Virus S/W cannot connect to the machine with the BCM 2007 database.
A: ou need to make sure to have port 5356 opened for outlook.exe on both remote and local machines for send and receive. 5356 is the TCP port that SQL Server instance uses to access the shared database.
Q: I have a local database that I want to move to a server and hence share it with my colleagues
A: You should use Admin Tool to achieve this.
Q: Can we stop the MSSMLBIZ SQL service on client machines to save local machine resources?
A: Yes, you can stop the service only if you don’t have an offline database on your local machine.
Q: Can the database administrator select what data to share with the other users?
A: BCM currently shares all the records in the database with all the shared users.
Q: If a user wants to make the BCM database available to all the colleagues, is it required to install BCM on each machine?
A: Yes, it is required to install BCM on every machine, so that the BCM forms and folders will show in Outlook, but you'll connect them all to the same database. Also, you don’t really need BCM on server machine if it’s only used for hosting database.
Q: I have shared out the database successfully from the server computer. When trying to connect to it from the client computer, I got the error message “Cannot find computer xyz. Confirm that the remote computer exists and that it is available on the network.”
A: Try pinging the server computer from the client. If it cannot ping the server computer, make sure that the firewall on server computer has exception for “File and Printer sharing”. If the exception is there, it could be that the server computer and client computer are not in the same subnet. You can verify that by looking at the IP address of these two machines. If they are in different subnet, follow the steps below
1. Open Windows Firewall Settings by going to the Control Panel,
2. Switch to the Exceptions tab; find exceptions for File and Printer Sharing, if the exception is not checked, check it
3. Click on Properties of this exception, and click on the “Change Scope”
4. In the “Change Scope” dialog window, if it shows “My Subnet Only”, choose “Custom List” and enter the IP addresses of the client computers (separate each with a comma).
Q: I have shared out the database successfully from the server computer. When trying to connect to it from the client computer, I got the error message “Cannot access the database server on computer xyz.”
A: There are multiple possible causes for this as listed below:
1. Check the
2. If the service is running, see if its
3. If there is no problem with
4. If you cannot find firewall exception for “Microsoft Small Business” in Windows firewall Settings, you can manually add one exception for
5. Note that if the shared DB is hosted in a SQL Instance not by default name “MSSMLBIZ”, and if its
Q: I made the changes in Windows Firewall settings and
A: Please see if there are other firewall services other than Windows Firewall running on the server computer. If so, please refer to each of these firewall solutions’ user manual and manually enable the firewall exceptions for both “File/Printer Sharing” (
Q: When trying to connect to it from the client computer, I got the error message “Cannot find any Business Contact Manager databases on computer xyz. For more information about possible causes, click Help.”
A: This is mostly due to reason that the database is not correctly shared to the user on the client computer. You can verify that by running the following SQL command as the shared user from the client computer:
Sqlcmd –S “tcp:serverName\instanceName,portNumber”
If this command fails, make sure that the database is not private, and that the intended shared user account does exist on server computer and has been granted shared user access to the database.
Q: I can connect to the shared database from client computer through SQL command or Management Studio fine; however, I could not connect through
A: The Business Contact Manager Database must be of same version and locale as the
Q: I get the error message “Cannot verify your remote user account on computer xyz. For more information, click Help.”
A: See if the server computer has “Simple File sharing” enabled, if so, it needs to be turned off. On
Or you can do this by running to the Registry Editor (regedit.exe) and going to the registry key HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa\ForceGuest
Set this value to be 0.
Sometimes the server computer needs to be restarted to let the change take effect.