BCM for Outlook database cannot be loaded Arthur Priver 5/27/2007 2:47:01 AM 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. -- Arthur Priver

Re: BCM for Outlook database cannot be loaded Luther <enowning[ at ]gmail.com> 5/29/2007 4:30:11 AM On May 26, 7:47 pm, Arthur Priver <ArthurPri...[ at ]discussions.microsoft.com> wrote: [Quoted Text] > 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. > -- > 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.

RE: BCM for Outlook database cannot be loaded Bryan 5/29/2007 3:32:01 PM 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 "Arthur Priver" wrote: [Quoted Text] > 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. > -- > Arthur Priver

RE: BCM for Outlook database cannot be loaded Arthur Priver 5/30/2007 3:15:01 AM 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? -- Arthur Priver "Bryan" wrote: [Quoted Text] > 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 > > "Arthur Priver" 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 > > 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. > > -- > > Arthur Priver

RE: BCM for Outlook database cannot be loaded Bryan 5/30/2007 1:42:01 PM 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. "Arthur Priver" wrote: [Quoted Text] > 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? > -- > Arthur Priver > > > "Bryan" wrote: > > > 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 > > > > "Arthur Priver" 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 > > > 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. > > > -- > > > Arthur Priver