Mark--
You might want to post this in the microsoft.public.outlook.bcm group (not
by way of admonition at all, but if you look on that group, there have been
a lot of nice tips for this problem that many people have worked through,
and some experts with BCM hang out there who work with this add-in it day
in and day out and are used to solving problems with it. They can handle
special situations and deliver good tips to you when you get it going.
Also if you remember any errors you got during any kind of crash or problem
opening OL, (my experience is that whatever the cause of the BCM MSDE SQL
engine having trouble associating with OL, you'll see BCM in the folder
list, tools as you say won't show, and OL will take a while trying to
open--sometimes crash and when you go to Help About> or File>Data Base
Engine>Add Disabled Add-Ins-- you will not be able to add it in (*although
sometimes this is all it takes*).
Go to the run box and type in "eventvwr.msc" and click Application and see
if there are any errors with SQL or BCM or BCM data base engine as the
source. I mean error numbers and short statements of the error problem--not
the Event ID or a series of numbers thrown in in there in hexadecimal or
some other language.
Right now if you are connected with Exchange server, Exchange doesn't
support BCM yet. There is a patch for BCM and Windows SBS 2003 on the
Office site.
Updates aren't the probable cause here, but be aware there are Office SP 1,
Outlook SP1, and Outlook SP1 with BCM updates like this one and you should
install them. I'd get BCM up and running before installing this one:
Outlook 2003 with Business Contact Manager Service Pack 1
http://www.microsoft.com/downloads/...89-46AC-4A27-B4C7-BE05723D53E5&displaylang=en
FAQ: How Windows XP Service Pack 2 (SP2) Affects SQL Server and MSDE
http://www.microsoft.com/sql/techinfo/administration/2000/security/winxpsp2faq.asp
This exists, but I doubt will impact you. I have used every build of SP2
including RTM, and I haven't had to do anything to the SP2 Windows firewall
for BCM to work fine, or to the SP1 ICF if you're using some flavor of Win
XP. I wouldn't worry about this issue unless you see a connection error
associated with SQL server or MSDE.
________________________________________________
*Issues to Check to Get BCM Up and Running*
1) Check Help>About> and Try to Add BCM if it is a disabled add-in. This
may be all you need to do, but if not...
2) First type "services.msc" in your run box. I want you to turn on three
entries to at least manual (automatic means they'll always start up on and
start them. BCM uses a mini-MSDE SQL data base engine and it needs these
services started for it to run.
3) 1) MSSQL$MSFTBCM (Installed with BCM) Again make sure Office and then
BCM
are installed or this won't be listed.
2) SQLAGENT$MicrosoftBCM should be started if it's listed.
3) Server (Supports file, print, and pipe sharing over the network)
4) Some people may have to enable File and Print Sharing at the three places
below to get BCM either in or once in to get the add-in associated properly
with Outlook when you fire up Outlook. I'd check and see if the first two
work and then go to these if you're either having BCM install problems or
getting BCM started with Outlook.
Enabled at Lan Properties
Enabled at the Printer
Enabled via the Server Entry in Services Started and On (One of two
services settings already listed).
5) Make sure that another application like an RSS feeder or any beta
application is *not using a .net framework beyond 1.1 plus.*
http://msdn.microsoft.com/netframework/
That's the native one required for BCM, and if you are using others you are
going to need a special patch. My experience is that unless you do special
work arounds, you are going to have a problem getting them to play well
together with BCM. I had a Beta that used a more advanced .net framework
and until I learned this and booted it off, I had big problems.
If you go to the BCM group, Alexander Gorlach has posted along these lines
and he keeps a blog that has his patches and expertise on this at
http://blogs.officezealot.com/gorlach/archives/000858.html
Alexander Gorlach,
MAPILab Ltd.
http://www.mapilab.com/
6) I have *never* found this necessary, but some people with SQL expertise
have found they have to go here and do this: Run box>type
"compmgt.msc">Local Users>Click Groups >Click BCM users Rt. Pane> or you can
get there this way *Check your BCMUsergroup and make sure you have this user
added (logged onas Administrator): Start>Control Panel>Administrative Tools
(or type"lusrmgr.msc" in the run box)>ComputerManagement>Open Local Users
and GroupsDouble Click Groups>(Then in Rt. PaneDouble Click
BCMUsersGroup)>On Botttom of General Tab>Add Button>in the boxenter
"Authenticated Users" so that NT Authority\Authenticated users will be
added to this group.* This profile may be necessary even if you aren't
seeing the error message addressed in this KB #830318:
You Receive an Error Message When You Start Outlook with Business Contact
Manager 2003
http://support.microsoft.com/default.aspx?scid=kb;en-us;830318&Product=out200311
By the way, the KB has wrong instructions. It has type "the authenticated
users" in to add, and "the" just is not going to work. You need to type
"Authenticated users" only in. MSFT has been informed of this for six
months, but the group responsible for the BCM KBs has not taken the "the"
out. This is one situation where the meaning of "is" and the existence of
"the" is important.
7) If you have some type PDA in a cradle connected to your box, you might
need to disconnect the cradle. Some say it interferes. I have seen it run
OL in the background after you kill OL, some before and sometimes these
interfere with BCM firing up and sometimes they don't.
8) You may want to uninstall BCM and reinstall it turning off Auto Protect,
Script Blocking, and any Office Add-ins if present in your AV app. Then
delete any files and folders found here in these folders:
C:\ProgramFiles\Microsoft SQL and Server\MSSQL$MICROSOFTBCM and delete
the following registry keys:
HKLM\Software\ODBC\ODBC.INI\BCM
HKLM\System\ControlSet001\Services\MSSQL$MicrosoftBCM
HKLM\System\ControlSet001\Services\SQLAgent$MicrosoftBCM
Reinstall BCM
9) Check that this Registry D_Word value for Load Behavior is set to
3:HKLM\Software\Microsoft\Office\Outlook\Addins\Microsoft.BusinessSolutions.eCRM.OutlookAddin.Connect.1
key. If the value for LoadBehavior is somethingother than 3, make a backup
of the registry, edit LoadBehavior to set it to3, then restart Outlook
*MSKBs on the First Version of the BCM .net Add-In To Outlook To Date*
http://tinyurl.com/53nxp
Cannot Hide or Show the Business Contact Manager Toolbar in Outlook 2003
http://support.microsoft.com/default.aspx?scid=kb;en-us;828245&Product=out2003
Business Contact Manager menu items are missing in Outlook 2003
http://support.microsoft.com/default.aspx?scid=kb;en-us;840778&Product=out2003
You cannot create a new database for Business Contact Manager when you
start Outlook 2003
http://support.microsoft.com/default.aspx?scid=kb;en-us;828247&Product=out2003
You also might want to keep up with blogs like this one
http://blogs.officezealot.com/cardoza/
because Patricia Cordoza is keeping up with BCM developments for books and
articles, and also helping to liason with MSFT for the next version's
features.
hth and check the mpo.bcm group,
Chad Harris
______________________________________________
After instaling Business Contact Manager the option for
Business tools never show up.