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

We have recently upgraded our servers to 2008. Small Business Server 2008 with Windows Server 2008 (32) as a member server. The member server is running Sql 2005 Standard and Sql 2008 Standard. Clients are all running Windows 7.

I am currently having issues with a shared BCM 2007 database on this member server. All was working perfectly before the upgrades. I created a new database with BCM database tool. I then restored a backup tacken from the old 2003 server. I then shared the database with the tool adding the users.

All works 100% for all users who are network administrators (even if they were NOT included in the databse share!?). However, users who are standard users cannot connect to the shared database. The error message says "Cannot find BCM database on computer".

I tried logging into the same PC with different user names. It only work for the administrators. I could make all users in my domain administrators and then they can connect but I feel this should not be neccessary.

Does anyone have a better idea than making everybody administrators?

I have asked this question on ther forums but no-one seems to have an answer.


Submitted via EggHeadCafe - Software Developer Portal of Choice 
Windows Forms .NET DataGrid ComboBox Columns And Custom Row Coloring
 http://www.**--****.com/ 

I am having the EXACT same issue, down to the T.   We took the same upgrade 
path you did about a month ago and still haven't found the solution.  If I 
figure it out I will let you know.

 Andrew Parker wrote on 01/20/2010 09:54 ET 
wit
databas
wer
fin
the

 http://www.**--****.com/ 
 Ok I had done the same migration as above and had the same problems with user
 not able to connect unless the domain users where added to the server loca
 admin group. I solved the issue by doing the following
 I was migrating from BCM 2007 hosted on a SBS 2003 Server with BCM 2007 Admi
 Tools Utility, so created a backup and moved the backups to the new server
 I installed the Admin tools onto the new SBS 2008 Server
 I created a new blank database in the default SBS 2008 sql instanc
 (SBSMONITORING)
 Then I imported the backup created off the old server into the newly create
 database with BCM Admin Tools
 From there you have to UNSHARE all the shared users in the Admin tools tha
 where granted access on the old server as they all get imported, and hence ar
 no longer valid on the new server even though the usernames might b
identical
 Then RESHARE the new database in admin tools for the domain users on the ne
 server you want to grant access for
 Then it allows Server 2008 domain users to access the shared database i
 Business Contact Manager on the client PC's.