> Okay I did get it to work here is how I did it.
>
> I first created a local SQL Express database using the BCM wizard tool. I
> then copied over the .mdf and .ldf to my SQL 2005 Enterprise Ed. server and
> attached them. I think the database was called MSSmallBusiness.
>
> I then added login permission to SQL Server for the first user account
> trying to connect to BCM for example domain\justin. I then changed the owner
> of the database from whatever to domain\justin.
>
> Next I ran the sql commands to share the database as stated in the white
> paper. If you don't run these sql commands BCM will not find any valid
> databases on the SQL Server. I would have too look but there are two primary
> commands, the first being a command changing a shared setting to true and the
> others being some stored proc prefixed with ir_ and taking a parameter of
> domain\user that gives users rights to the shared db.
>
> Also of note is that I had to restart services (sql server, sql browser)
> multiple times and was not doing this before. Make sure IPAll has a TCP Port
> of 5356. My particular database has a TCP Dynamic Port setting of 1457 as
> well.
>
> I think the biggest problem was the sql commands on the database. BCM not
> only needs to find databases on a SQL Server but BCM must run special checks
> on databases to make sure they are either owned by someone special or have a
> particular schema.
>
> Anyone from MS want to comment on the process BCM goes through to find valid
> DB's.
>
> Thanks -
>
>
>
> "Nanjuan Shi (MSFT)" wrote:
> > Hi,
> > Could you please check to see there are firewall services running on your
> > machine?
> > If there are firewall running, can you please verfiy:
>
> > 1. Firewall does allow exceptions;
> > 2. There is firewall exception for sql server's TCP Port? In the white
> > paper, there is a step 3 on how to do that.
>
> > Please note that if there are multiple firewall services running, you may
> > need to enable firewall exception on all of them.
>
> > Thanks.
>
> > "J Chastain" wrote:
>
> > > My instance is another name and can't be changed. I figured this might be a
> > > problem but the whitepaper claims that it isn't. I followed that darn
> > > whitepaper to a tee for everything and still no go - BCM can't find the db
> > > server.
>
> > > I set the TCP port number under IPAll in SQL Network Config to 5356 - again
> > > as the whitepaper states. Still no go. SQL 2005 is working fine in every
> > > other scenario.
>
> > > Do I have to allow a port exeception on the db server to 5356?
>
> > > Again : does anyone know a hack to get this working? I am going nuts over
> > > here!
>
> > > Many thanks in advance.
>
> > > "Lon Orenstein" wrote:
>
> > > > Check to make sure the SQL instance is called MSSMLBIZ and that port 5356 is
> > > > open. Those were the two problems I found...
>
> > > > HTH,
> > > > Lon
>
> > > > ___________________________________________________________
> > > > Lon Orenstein
> > > > pinpointtools, llc
> > > > L...[ at ]pinpointtools.com
> > > > Author of Outlook 2007 Business Contact Manager For Dummies
> > > > Author of the eBook: Moving from ACT! to Business Contact Manager
> > > > 800.238.0560 x6104 Toll Free (U.S. only) +1 214.905.0401 x6104
> > > >www.pinpointtools.com
>
> > > > "PierreDa" <Pierr...[ at ]discussions.microsoft.com> wrote in message
> > > >news:DDDC719C-ABA7-4235-9E2E-B6E23537BDFA[ at ]microsoft.com...
>
> > > > > Hi,
>
> > > > > I have the same problem.
> > > > > First I install outlook with BCM 2007 on the server and it was working
> > > > > well
> > > > > but I had problem to connect with an other machine (other language).
> > > > > I decide to put the DB on my SQL server 2005, follow the guide (I think !)
> > > > > and can't connect any more!
>
> > > > > Does exist a test to see if BCM can see the DB ? And why we don't have the
> > > > > same possiblitilty as with SQL studio to browse to find the DB !!!
>
> > > > > Any help out there ?
>
> > > > > Pierre
> > > > > "J Chastain" wrote:
>
> > > > >> I have a SQL Enterprise Edition 2005 Database server that I am trying to
> > > > >> get
> > > > >> BCM to use and I have been unsuccessfull so far. When I choose the
> > > > >> "existing
> > > > >> database" option and enter the server name and instance name I get a
> > > > >> error
> > > > >> message "Cannot find any Business Contact manager databases on computer
> > > > >> xx\xx. For more info...."
>
> > > > >> The document lists that BCM supports SQL Standard SP1 & Workgroup edition
> > > > >> but how can it not support Enterprise Edition....
>
> > > > >> Is there any reg keys I can alter to point BCM to my database server? Any
> > > > >> hacks? I would like to use my existing db but I don't know how to make it
> > > > >> work.
>
> > > > >> Any help on this subject would be greatly appreciated.- Hide quoted text -
>
> - Show quoted text -