BCM shared on SBS Server access from Domain Clients WinXP



  • 1. Can't install or uninstall BCM
    I'm (trying) to run the Office 2007 beta and everything is going swimmingly except for BCM. I don't use that functionality in SBA but I would like it to work so I can start experimenting with it. At present I can not uninstall or install or use or modify the BCM installation. I've even tried to uninstall all parts of MS Office and then start over. I can't get it to work in version 2003 or 2007. Does anybody have any ideas here? This topic has been hanging around for a couple of weeks now with no answers. My invitation is pending to the SBA 2007 group so I can't go there for answers. Ideas? Suggestions? Alternative Procedures? Thanx, ;-) Lonny
  • 2. Create own Lead Listboxentries
    Hi, there is no posibility to add some own Lead or other infos at the BCM. However the entries in the listoxes are not usfull for us. So how can I add my own Informations? Direct changes in sql database are not very practical. Is there a tool somewhere what I can use to do what I want or do I have to wait to V3? Michael
  • 3. how do i prevent other users from editing my business contacts?
    when using business contacts manager - each contact is flagged with the person who created the contact. how do i lock that contact down, so that other users can see but not edit it?

BCM shared on SBS Server access from Domain Clients WinXP

Postby FragHunter » Tue, 31 Oct 2006 17:27:27 GMT

Hi folks.

Ie installed BCM on our Small Business Server 2003 Premium Edition.
On the same machine I got an Exchange Server and Outlook 2003. It works
at the moment... I created a Database on a Client machine and exported
it. Then Imported to
the SBS machine. And added some rights on the SQL Database for a
specific User whom I want to access the Database. On the SBS Server is
a ISA 2006 installed... all inbound traffic is allowed
from internal network to the internal interface of the ISA Server.

But I got a Problem "discovering" the Databases on the Domain
Controller when trying to make
the database configuration on my client PC. I changed the ports in the
tested it with the following command:''osql -E -S

from here:  http://www.**--****.com/ 

It works. But the Database could not be found... In the registry of the
Domain Controller I left the SQLInstanceName Name field blank....

DO I have to change something else?

On my clients WIndows XP Firewall is deactivated... so this should be
no problem....
any further ideas?!?!? Thanks a lot for your help

Re: BCM shared on SBS Server access from Domain Clients WinXP

Postby Jason Ede » Tue, 31 Oct 2006 19:16:07 GMT

We found exactly the same thing when trying to install the BCM 2007 Beta 
  2 TR here onto an SBS server. The office version is the 2007 beta 2 TR 
as well, but still seem unable to connect. The instructions with the 
beta say to setup communication on port 5356, and I can connect on that 
port when try opening an sql connection, but not when trying to connect 
within the setup wizard. Also tried changing the port to 56183, but 
still no joy.


Re: BCM shared on SBS Server access from Domain Clients WinXP

Postby Luther » Tue, 31 Oct 2006 22:04:53 GMT

> In the registry of the

The Registry is only by BCM clients. Neither the database itself nor
sql srever will read those. The BCM client will read that entry.
Leaving it blank is "undefined" behavior. I don't know what BCM will
default to, but it should have "microsoftsmlbiz" if that is the name
of your instance.

I don't quite understand this:

Did you actually export to a BCM file and import that into
a database you created on the DC? Or did you backup
and restore?

Can you still run BCM on the DC, and use the database?
In that case, when you run the Sahring Wizard in BCM, does
the other user show up as having permission to use the database?

If the database exists in the instance. And the client user can
access the instance using osql, but not the database, then the
client user does not have permission to connect to the database.

Did you do this with the BCM Sharing Wizard, or directly
in sql?

Similar Threads:

1.BCM 2007 Shared Database on member Server 2008 in SBS 2008 Domain

2.BCM 2003 server (share) & BCM 2007 client compatibility


I have just had a very frustrating day.

So far I have learned that BCM 2003 uses TCP port 56183 and that BCM 2007 
uses TCP port 5356.

I have also discovered that BCM 2007 is hard coded to use port 5356.  
Whenever I attempt to connect BCM 2007 to a 2003 shared database it reports 
that it cannot connect.  However, I can connect without problems using the 
osql command and I can query the data successfully.

If I force BCM 2007 client to use port 56183 it connects but then it cannot 
see the database.  ie, it will not allow me to pick the 2003 database from 
the drop down list. 

All other 2003 clients connect and work seamlessly, but we have just 
acquired 2 x XP PCs with office 2007 & BCM 2007.

I guess I already know the answer, but does anyone else have this problem?  
Maybe someone might have a solution?

Thank you,

3.Connecting to BCM 2010 Shared DB on SBS 08 Server

I am trying to upgrade the BCM from 2007 and have he following issue.
The tool works fine creates the DB, restores the 2007 data an upgrades the 
The uisers have been given access.

However the SQL Express 2008 shows a region on US English and the clients 
are UK(British) English.  So the connect database is gryed out as the error 
message indicates cannot connect to data with a different region.

I have tried changing the database language to British but the clients still 
cannot connect to the server to use BCM 2010 data.

How can this be resolved as this did not happen with 2007.  I am using teh 
full release versions.

4.Outlook 2003 Client Access from External Sources to SBS Server


We have a SBS Server - Premium Edition running on our network, I need
to allow users from Extrernal (Internet) sources to be able to connect
to my server (running Exchange 2003 and ISA 2004) via their Outlook
Clients. How can I do that, and what all I setups I do need to do ?

I have seen this article and understand what access rules do I need to
do on ISA, but did not get what all setups,if any, do I need to do on

Please assist.

5.EXACTLY what happens when a domain user is granted access to shared BCM db

My goal is to share business contacts company-wide and integrate those
contacts into our production database.

Everything worked great for me (the developer) but now I can't give
access to other users


1) Installed BCM on an XP machine under our domain admin username
2) Shared the database and added myselft as a user with access
3) Copied the BCM database from the MSDE instance to a SQL2000 instance
on a SBS machine
4) Installed BCM on my XP machine
5) Edited my XP machine's registry to point to the new SQL 2000
instance name on port 1433
6) Selected Shared database on my machine and connected to the SQL 2000
db fine
7) Uninstalled BCM and MSDE from the original machine
8) Uninstalled MSDE from my machine and everything is still fine
9) Used the BCM contact tables to drive our full size production
10) Installed BCM on another XP machine, edited it's registry
11) Attempted to connect to same SQL 2000 instance on new machine, but
error is returned saying make sure BCM is running that the DB is
shared, etc.

Now, I'm assuming that if I had granted all domain users access to the
shared db on the original XP machine when I did my own name everything
would be ok.

The problem is I can no longer use the "Share Database" menu selection
in my copy of Outlook because it is setup as a shared database client.

Which brings me to the question in the subject: When you select "share
database" inside Outlook and add users what is happening there?  I need
to replicate it without the use of Outlook and I can't figure it out.

I've added the domain user in question as a login for SQL 2000 and a
user of the BCM database with the same roles as my (working) name.

No firewall is running on the server (even if it was I have access on
the same port from a different machine) 

Any ideas?

6. Outlook Error on XP Client in SBS 2003 Domain

7. Error accessing shared BCM database on remote server

8. sharing BCM db and SBS 2003



Who is online

Users browsing this forum: No registered users and 37 guest