Shared Business Contact Manager for Outlook 2007 database on an SQL 2005 Server

Microsoft OFFICE


  • 1. Entourage 2008
    In Entourage 2008 for Mac is there a way to send out an email automatically at regular intervals like once a week?
  • 2. word hangs up
    I have Office 2000 Professional and am running a stand alone with Windows XP. When I open Word, the page hangs up and will not respond. My other Office documents work. I have uninstalled and reinstalled two times at no avail with Word. On my tool bar in Word I have the letters FR in red. I don't remember seeing those before. My virus scan is Norton 360. Any ideas?
  • 3. Setting Yahoo mail as the default email application
    I have found multiple answers to setting the default email application in Windows. I would like to set Yahoo mail as my default, but it is not listed as an option in the Internet Properties email window. Only Outlook and Windows Live are listed. I called the Yahoo help desk and they were no help. Does anyone know how I can do this?

Shared Business Contact Manager for Outlook 2007 database on an SQL 2005 Server

Postby M.Siler » Fri, 07 Mar 2008 08:39:12 GMT

Please forgive the cross posting. I just don't know which would be the right 
group for this quesions. We are looking at using Business Contact Manager 
for Outlook 2007. We'd like to have a shared BCM database. We have an SQL 
2005 (active/passive) clustered server. I've read that BCM is an SQL 
database and will install (I think) SQL Express 2005 on each machine if they 
are running the BCM locally. Given we have a full SQL 2005 server is there a 
way to put the BCM database there?

I found the Database Admin Tool 
( http://www.**--****.com/ ) 
to install the BCM database on a computer that is not running Office 2007, 
but I'm not sure this is what I want to do for installation on an full 
version of SQL 2005?

Can anyone direct me to any articles that might help me with this task? 
Also, does anyone know how many people BCM can support before we should 
really consider going to Microsoft Dynamic CRM 3.0?


Re: Shared Business Contact Manager for Outlook 2007 database on an SQL 2005 Server

Postby jerryb » Sat, 21 Feb 2009 06:03:21 GMT


Since I see no further posts, is it safe to assume that Microsoft's
Outlook 2007 with Business Contact Manager: Database Admin Tool did all
that was expected without causing any problems on your SQL Server?


 XXXX@XXXXX.COM 's Profile:  http://www.**--****.com/ 
View this thread:  http://www.**--****.com/ 


Similar Threads:

1.Shared Business Contact Manager for Outlook 2007 database on an SQL 2005 Server

2.Data loss in BCM 2007 with shared SQL 2005 database

A client is trying to use BCM 2007. The database is on their SBS 2003 Server, 
running SQL 2005 WorkGroup Edition. Right now, there are really just two 
users on the LAN. The main user is doing testing and reports a problem with 
losing newly saved information. Her description is below. Does any of this 
ring a bell with anyone?

Thanks in advance
Myron Johnson 
RTA Information Technology - Tempe, Arizona, USA


"So what it is doing is losing newly saved information. I noticed it first 
when I would change what account a business contact was linked to. I would 
save and it would think for a minute and complete the save. However, when I 
went to see if it linked it to the new account it had done nothing. It is 
progressively getting worse. I am now noticing it in almost every area. I 
have also seen it do the exact same thing to accounts and business contacts 
when I: linked an email, added information to comments, changed a spelling 
typo, changed or added a category, etc. Every time when I went to try it 
again it would eventually work correctly, but sometimes it is on the second 
try and other times it takes 3 of 4 times. So far I haven noticed it 
completely loosing accounts or contacts, but there is so many I not sure if 
I would notice one gone. It all seems to be when things are being edited. 

Also very often when I have generated a list that I am editing items from 
the list will disappear and it will say nothing to display. An example is if 
I am in business contacts and have it arranged by categories and I open and 
change something in a contact, when I save it will bring me back to the 
original list but when I try to scroll to the next one the list disappears. 
To scroll I have tried to use my mouse, the scroll bar, and the arrows on the 
scroll bar. Nothing seems to make a difference. I have even tried to click on 
the list when I returned, thinking it trying to move me to a different area 
but it also didn help. I have to go to the accounts list and then back to 
the business contacts list to make it work. Sometimes my list will be the 
same, sometimes it is not. It seems to me the problems could be related 
because I am always editing when it goes crazy. But on the other hand, no one 
but John has been using CRM other than me editing, and he isn using it that 
much. I did ask him and he has not encountered the same problems. Sorry to 
give you such a tedious problem but I just scared it may cause big problems 
when everyone starts to use it. Please let me know if you need any more 
clarification or if I can help because I understand that issues like this 
aren always easy to find the source of."

3.Business Contact Manager database shared on SQL 2000

I installed BCM 2003 on on XP computer, shared it and then copied it to our 
SQL 2000 server.  I enable dnamed pipes and TCP/IP to use port 56183.  
However,  when I try to connect my users to the database they can not locate 
any databases on our server.  Any thoughts would be greatly appreciated.

4.Moving BCM 2007 Database to a SQL 2005 Server

One of our users has been testing BCM and we now want others to start
using it, they have just been using a local database but now I want to
move it to SQL Server. I thought I could just backup the database and
restore it on the server using the BCM Database admin tool. I first
created a new database on the server with the admin tool then backed
up his local database and restored this onto the server.
This seemed to work however although user1 was still the dbo of the
database he could not access the database but users that I shared the
database to could access it just not the dbo. In Studio Manager when I
right clicked on the database and click properties under database it
had the owner listed as administrator. Administrator is the user I ran
the admin tool as. Is this owner different from the dbo? I even tried
using the command sp_changedbowner to make sure the dbo is set
correctly and it now shows in Studio Manager as user1 instead of
administrator but the user still cannot access the db.
If I try and connect using sqlcmd -E -S 'servername'\'instance','port
I get the following error:
C:\>sqlcmd -E -S 'servername'\'instance','port no'
Msg 18456, Level 14, State 1, Server 'servername, Line 1
Login failed for user 'domain\user1'.
I have read that instead of restoring the database I could just export
the data then the dbo would be administrator. However I think I will
then have a problem where user1 will no longer be able to create new
fields in BCM which they need to be able to do.
Any help much appreciated.

5.Shared Business Contact Manager for Outlook 2007 database on an SQ

6. business contacts manager with SQL 2005

7. Shared Business Contact Manager for Outlook 2007 database on an SQ

8. Business Contact Manager 2007 and SQL Server 2008

Return to Microsoft OFFICE


Who is online

Users browsing this forum: No registered users and 91 guest