BCM W/ SQL Sever Enterprise Edition

[J Chastain]

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.

 

[PierreDa]

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

 

[Lon Orenstein]

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
(e-mail address removed)
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]

Hi,

Thank.
No, my SQL Server 2005 instance is HQSQLSRV ...
And I follow the document saying "when you connect to the remote server use
COMPUTERNAME\SQLINSTANCENAME !!

But it doesn't work for me !!

Hope some one from Microsoft can help ...

Using and configuring BCM is a NIGHTMARE !!

For instance if you install BCM and uninstall you cannot install it back
anymore !!
I spent hours to try with no success.

I'll create an other topic !

Regards

 

[J Chastain]

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.

 

[Nanjuan Shi (MSFT)]

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]

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 -

 

[Luther]

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 -







- Show quoted text -

I know from past experience that BCM checks values in a database's
OrgTable to validate that it is a usable database; e.g. is the db a
version number it can work with, is sharing turned on.