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

[Andrew Parker]

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.eggheadcafe.com/tutorial...41-dfdad4ea0b4a/windows-forms-net-datagr.aspx

 

[Kyle Joiner]

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.

 

[slimtecit]

Andrew Parker wrote on 01/20/2010 09:54 ET

We have recently upgraded our servers to 2008. Small Business Server 200 wit
Windows Server 2008 (32) as a member server. The member server is running Sq
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 membe
server. All was working perfectly before the upgrades. I created a ne databas
with BCM database tool. I then restored a backup tacken from the old 200
server. I then shared the database with the tool adding the users

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

I tried logging into the same PC with different user names. It only work fo
the administrators. I could make all users in my domain administrators an the
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 Choic
Windows Forms .NET DataGrid ComboBox Columns And Custom Row Colorin
http://www.eggheadcafe.com/tutorial...641-dfdad4ea0b4a/windows-forms-net-datagr.asp

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.