BCM 2007 Shared Database on member Server 2008 in SBS 2008 Domain
by Andrew » Thu, 21 Jan 2010 23:54:58 GMT
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/
RE: BCM 2007 Shared Database on member Server 2008 in SBS 2008 Domain
by S3lsZSBKb2luZXI » Sun, 07 Feb 2010 00:18:01 GMT
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.
Re: BCM 2007 Shared Database on member Server 2008 in SBS 2008 Domain
by slimtecit » Sat, 05 Jun 2010 00:10:31 GMT
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.
Similar Threads:
1.BCM 2007 database share problem in Server 2008
I've been trying to share the BCM 2007 contact database installed on a server
2008 pc with the other pc's in the same network environment.
When I go through the steps in the share database wizard within BCM 2007, it
denies me access. No idea why, because all lights are on green to share.
I get through the first step: "I want to share my database" and click next.
Then, in the next step, whether or not I wish to keep my current E-mail
Auto-Linking settings, after I click next again, it keeps telling me "Access
is denied."
Anybody any idea what I'm doing wrong here?
Thanks in advance for your input.
Kind Regards,
Marco
2.BCM Admin Tool on a Windows 2008 x64 Server running SQL 2008
I can't find any documentation that will support this.so I'm just curious as
to whether anyone has accomplished this before I attempt myself. I'm sure
there are others out there wondering the same or perhaps may have even
attempted this. I know I can run the admin tool with SQL 2005 x64. Thanks.
3.Install BCM on SBS 2008 Standard server
I wish to install Outlook BCM onto a SBS 2008 Standard server.
I have done this before onto a SBS 2003 Server.
Can you still use the same tools or has there be an update for a 64 bit
operating system.
4.Cannot seem to use BCM Database Tool on SQL Server 2008
I am trying to install BCM onto a sql 2008 server for shared usage. The
server is running Windows 2008 32 bit.
I have an instance "CSSSQL01\MSSMLBIZ" that I installed as a local admin
account "CSSSQL01\sqlsmlbizadmin" I can use SSME to connect to this
instance, using Windows Authentication (logged in as this user).
However, when I use Business Contact Manager for Outlook 2007 Database Tool
to try to Create a New Database, I receive this error message "Cannot
retrieve the list of SQL Server instance. Please make sure that SQL Server
2005 or SQL Server 2005 Express is installed and that the service is
running." Clicking OK closes the program.
Any ideas?
I only saw one other thread about this and it ended in August 2008 without
an answer.
Thank you,
chuck
5.BCM in a shared environment running on SQL Server 2008
Has anyone tried running Outlook 2007 with BCM on a shared SQL2008 database?
I.e. like as SQL2005 SP2 implementation but with SQL2008
TIA
Nigel Ainscoe
6. BCM 2007 on Windows Server 2008
7. Trying to connect BCM 2007 to SQL Server 2008
8. Integration BCM SBS 2008