Office 2003 & Sqlservr.exe Question

[Zephyr]

Hello,

I installed MS Office 2003 Pro and after checking Task
Manager, I notice that Sqlservr.exe is running as a new
service. Can someone tell me what this service is for?

The reason I ask is twofold. First, it takes up a large
amount of memory. After starting my system, Sqlservr is
using approx. 15MB but after using the system for a bit,
it's memory usage starts to climb, especially after using
Outlook 2003 (memory usage went up to 35MB).

Secondly, after checking the Event Viewer, I see a number
of warning entries related to MSSQL$MicrosoftBCM. I found
a Knowledge Base article (828246) that say's this warning
is the result of File & Printer sharing not being
installed. Problem is, File & Printer Sharing is
installed on my system. Should I reinstall F&P Sharing?

Since installing MS Office 2003, I've started to have
system stability issues and am wondering if it could be
related to SQLservr.exe? Out of curiosity, I stopped the
SQLservr.exe service but then Outlook wouldn't work so
unfortunately, it appears I can't disable the SQLservr
service.

Has anyone else experienced system stability problems
after installing Office 2003?

Thanks!

 

[SA]

Zephyr:

You must have installed the Business Contact Manager for Outlook as part of
your install (It appears to be so because of the MSSQL$MicrosoftBCM)
references in the Event Viewer). That Add On program uses SQL Server,
which is a powerfull database program to manage the data related to Business
Contacts. That is the only reason SQLServr would be running. Otherwise it
is not a part of the default install of Office 2003.

You don't state what the warnings or errors are related to the
MSSQL$MicrosoftBCM instance that is running on your system. If you could
note those, then possibly you'd receive more clear answers to resolving the
problem. Normally SQL Server will not cause in and of itself any stability
problems that I'm aware of related to overall systems. However, if you are
receiving warnings then you should look into those.

If you uninstall the Business Contact Manager, it will uninstall the SQL
Service and Outlook will operate without that service running.

 

[Guest]

Thanks for the info Steve.

Yes, I did install the BCM for Outlook so at least I now
understand why SQLServr is running. I guess I should have
figured out that's what the BCM sttod for in
MSSQL$MicrosoftBCM

Here is the error message from the Event Viewer:

Event Type: Warning
Event Source: MSSQL$MICROSOFTBCM
Event Category: (8)
Event ID: 19011
Date: 2/15/2004
Time: 10:11:28 AM
User: N/A
Computer: SYSTEM1
Description:
The description for Event ID ( 19011 ) in Source (
MSSQL$MICROSOFTBCM ) cannot be found. The local computer
may not have the necessary registry information or
message DLL files to display messages from a remote
computer. You may be able to use the /AUXSOURCE= flag to
retrieve this description; see Help and Support for
details. The following information is part of the event:
(SpnRegister) : Error 1355.

As I mentioned, I did find a KB article that describes
this and it's relationship to File & Printer Sharing not
being installed. I do have it installed though.

Thanks again!

 

[SA]

Z:

Here's the relevant KB article. The warning is probably inconsequential
since you appear to be running on a single workstation.

http://support.microsoft.com/default.aspx?scid=kb;en-us;303411&Product=sql

 

[Kurt Friis Hansen]

On Sun, 15 Feb 2004 14:33:32 -0800,

Thanks for the info Steve.

Yes, I did install the BCM for Outlook so at least I now
understand why SQLServr is running. I guess I should have
figured out that's what the BCM sttod for in
MSSQL$MicrosoftBCM

Here is the error message from the Event Viewer:

Event Type: Warning
Event Source: MSSQL$MICROSOFTBCM
Event Category: (8)
Event ID: 19011
Date: 2/15/2004
Time: 10:11:28 AM
User: N/A
Computer: SYSTEM1
Description:
The description for Event ID ( 19011 ) in Source (
MSSQL$MICROSOFTBCM ) cannot be found. The local computer
may not have the necessary registry information or
message DLL files to display messages from a remote
computer. You may be able to use the /AUXSOURCE= flag to
retrieve this description; see Help and Support for
details. The following information is part of the event:
(SpnRegister) : Error 1355.

As I mentioned, I did find a KB article that describes
this and it's relationship to File & Printer Sharing not
being installed. I do have it installed though.

I've experienced the same problem. It only seems to exist, when I
start Outlook in "Startup". The symptoms are:

1. The message you have in logs.
2. The menu item "Business functions" (whatever your local name is)
missing.
3. The BCM "Link" toolbar is missing (mine is called: "Sammenkæd med
oversigt" - so I'm guessing the name here

If you close down Outlook, and restart Oulook manually, the problem
has gone, and the missing items are now present (until you close your
machine - at least in my case).

The culprit seems to be the MSDE/SQL2000 database installed locally.
It takes some time to initialize, and the Business Contact Manager is
probably not prepared to wait long enough.

It would be nice, if someone could confirm my assumptions...

-----Original Message-----
Zephyr:

You must have installed the Business Contact Manager for Outlook as part of
your install (It appears to be so because of the MSSQL$MicrosoftBCM)
references in the Event Viewer). That Add On program uses SQL Server,
which is a powerfull database program to manage the data related to Business
Contacts. That is the only reason SQLServr would be running. Otherwise it
is not a part of the default install of Office 2003.

You don't state what the warnings or errors are related to the
MSSQL$MicrosoftBCM instance that is running on your system. If you could
note those, then possibly you'd receive more clear answers to resolving the
problem. Normally SQL Server will not cause in and of itself any stability
problems that I'm aware of related to overall systems. However, if you are
receiving warnings then you should look into those.

If you uninstall the Business Contact Manager, it will uninstall the SQL
Service and Outlook will operate without that service running.

[cut...]

Regards

Kurt Friis Hansen
Flypaper for spammers: (e-mail address removed)