BCM for Outlook database cannot be loaded

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Arthur Priver - 27 May 2007 03:47 GMT

I have 8 users starting to use a shared Business Contact Manager 2003
database. The database is on a local computer, since I am not able to store
it on the SBS2003 server. I had all 8 users connected to the shared database
at one point. The users now occasionally get the following message:
"Business Contact Manager for Outlook database cannot be loaded.
This action cannot be completed because Business Contact Manager cannot
access the database.
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection."
I made sure all of the users had Windows accounts on the host computer.
Later in the day, I was able to see the database from all the computers. I
do not know why the users sometimes see this error message, and whether it
may recur. Any thoughts? Thank you.

Signature

Arthur Priver

Reply to this Message

Luther - 29 May 2007 05:30 GMT

On May 26, 7:47 pm, Arthur Priver
<ArthurPri...@discussions.microsoft.com> wrote:

> I have 8 users starting to use a shared Business Contact Manager 2003
> database. The database is on a local computer, since I am not able to store
[quoted text clipped - 11 lines]
> --
> Arthur Priver

I haven't run into that message before when the users have valid
accounts, which is the case if the same user could connect later, but
you are pushing the limit on how much load the database can handle.
MSDE has a limit of five concurrent connections (and one user may have
more than one connection per BCM sesssion). After five, the other
database access requests are queued up, and its possible that with
eight busy users, the queue is full and connections are dropped.
That's the extent of my knowledge of this, but someone else may have
more insight into how MSDE behaves under heavy load.

Reply to this Message

Bryan - 29 May 2007 16:32 GMT

Can you find any pattern? Perhaps when too many people are trying to hit the
db at the same time? With that many users I'd think you'd prefer to put it on
the sbs . server. This link gets you a tool to help you create the db. There
is also a kb article bcm.doc (don't have the link handy)

http://www.microsoft.com/downloads/details.aspx?FamilyID=b8e7aa0f-f593-4fb4-b822
-dd662af1a6cb&displaylang=en

> I have 8 users starting to use a shared Business Contact Manager 2003
> database. The database is on a local computer, since I am not able to store
[quoted text clipped - 9 lines]
> do not know why the users sometimes see this error message, and whether it
> may recur. Any thoughts? Thank you.

Reply to this Message

Arthur Priver - 30 May 2007 04:15 GMT

I will see how to put the database on the SBS srver - that is my goal. If
more than five users have the contact folder open, are they using up MSDE
connections?

Signature

Arthur Priver

> Can you find any pattern? Perhaps when too many people are trying to hit the
> db at the same time? With that many users I'd think you'd prefer to put it on
[quoted text clipped - 16 lines]
> > do not know why the users sometimes see this error message, and whether it
> > may recur. Any thoughts? Thank you.

Reply to this Message

Bryan - 30 May 2007 14:42 GMT

I don't know the exact limitations of MSDE, but I do know you can share the
db on an sbs server cause I've just gotten that to work. Just make sure that
SBS is at R2 & Use the db creation tool in the link below.

> I will see how to put the database on the SBS srver - that is my goal. If
> more than five users have the contact folder open, are they using up MSDE
[quoted text clipped - 20 lines]
> > > do not know why the users sometimes see this error message, and whether it
> > > may recur. Any thoughts? Thank you.

Reply to this Message