Server configuration for BCM 2013 shared database

Status
Not open for further replies.

wallisellener

Senior Member
Outlook version
Outlook 2013 64 bit
Email Account
Exchange Server
Dear All

I was not able to find a good install and configuration guide for BCM Database Tool 2013.

Could someone please post all the requirements for a new server on which a BCM shared database for Outlook 2013:

- supported operating system

- version of MSSQL Server

- any additional software required (Microsoft .NET Framework 3.5 SP1 ?)

-which user should be used when installing the BCM DB Tool (Administrator user or a local user with administrator rights)

-the user (Administrator or local user) which was used to install the BCM DB Tool should have SQL Admin rights?

Any additional remarks/infos are more than welcomed.

Regards

Wallisellenener
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
BCM shared will work on most OS and SQL - it now supports SQL 2012 and I know it works with SQL 2005 on Win2003 R2 (that's what I'm using)

Since I used it to upgrade an older db, I didn't need to install anything. What it needs, BCM tool for 2010 also needed.

I installed it using the Administrator account. What happened when you tried to install it using a local user account?

From the kb Description of the Business Contact Manager for Outlook Database Tool

Known issues and behavior changes

User cannot create new database when SQL Server 2012 services logged on as Network Service

If a user of the BCM Database Tool is using SQL Server 2012 on Windows Server 2008 and is logged in as a Network Service, they may see the following error message:

Cannot create a new database. The operation has been rolled back. Please make sure the database service is running.

The workaround is to log on as a Local System instead of as a Network Service.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Actually, that KB article covers the prereq question and most of the others. Based on the known issues, it also works with SQL2012, even though its not listed as supported.




The tool ensures that the necessary firewall ports are opened, that users are granted permission to the database, and that the SQL instance is configured to allow external connections. These operations require the user to be a local administrator. A supported version of SQL Server needs to be present in order to use this tool. Currently, this tool supports 2005 and 2008 versions of Microsoft SQL Server.






More information






Supported operating systems




This tool is supported on the following operating systems:


•Windows 8


•Windows 7


•Windows Server 2003 R2 x86 (32-bit)


•Windows Server 2003 R2 x64 editions


•Windows Server 2003 Service Pack 2 (SP2)


•Windows Server 2008 Service Pack 2 (SP2)


•Windows Vista Service Pack 2


•Windows XP Service Pack 3


•Windows Small Business Server 2008


•Windows Small Business Server 2003 Service Pack 1 (SP1)




Prerequisites




You must have Microsoft .NET Framework 3.5 SP1, Microsoft SQL Server 2008 SP2 or Microsoft SQL Server 2005 SP3 (32-bit only) installed.
 

wallisellener

Senior Member
Outlook version
Outlook 2013 64 bit
Email Account
Exchange Server
Hi Diane

Many thanks for the fast reply !

When configuring the MSSQL Server with a local user (user in Administrator Group) I was receiving the following error message when trying to create a new DB via BCM DB tool:

"Cannot create a new database. The operation has been rolled back. Please make sure the database service is running."

Currently I'm installing on a Win Server 2k8 SP1 and MSSQL Server 2008 SP2 the BCM DB Tool 2013 and everything using Administrator account.

I will update the thread after the process is completed.

Regards

W
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
That is the error in the KB that says the workaround is to log on as a Local System instead of as a Network Service. It said that applied to SQL 2012, not 2008 though.
 

wallisellener

Senior Member
Outlook version
Outlook 2013 64 bit
Email Account
Exchange Server
Using "Administrator" account worked. I was able to create and share a new database using the BCM DB Tool.

Now a new issue appeared: outlook 2013 can't connect to the database.

The Exchange version is 2010 and I'm using Outlook 2013.

The server where the shared DB is configured has all the tools installed in English. On my Notebook I have Outlook installed in german. Could this be an issue?

This is no network issue because the firewall is disabled.

I've checked this link: Configuring BCM to share a SQL server database - Slipstick Systems but unfortunately without success.

Any ideas what could be wrong?
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
I don't think its German, as long as the login to the laptop = a user alias in the shared db, it should work. (And the passwords match.)

I know one thing won't work, a Microsoft account login on Windows 8. My Microsoft account is the same as the address of my personal account in the domain the SQL server is in but it won't work. I wanted the sync features of the Microsoft account logon but it's not compatible with a shared db.
 

wallisellener

Senior Member
Outlook version
Outlook 2013 64 bit
Email Account
Exchange Server
I revised the steps from the link and it seems I have a password problem.

When executing >osql -E -S server\microsoftsmlbiz,port I receive a "Login failed for user Domain\firstname.lastname" message.

This is quite strange because I'm using the same password when logging on the Domain (both machines are in the same domain) and when sharing the database using the BCM DB Tool.

Is this a bug or ...?
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
It's possible it could be a bug - I haven't tried this build with a domain login yet. But, I'd be surprised because it uses most of the same code from the 2010 version.
 

wallisellener

Senior Member
Outlook version
Outlook 2013 64 bit
Email Account
Exchange Server
After some additional changes and tweaks I'm blocked with the following error:
> osql -E -S ip\MSSmallBusiness,port
[SQL Server Native Client 10.0]Cannot generate SSPI context

The same thing happens when trying to connect with the MSSQL Server managemenet Studio using Windows Authentication.

The reason why BCM can't find the shared database and this error message are related?

Is there any fast workaround to quickly get BCM running and connected to the shared DB?
 

wallisellener

Senior Member
Outlook version
Outlook 2013 64 bit
Email Account
Exchange Server
Diane many thanks for the fantastic support!

With your help I managed to find a workaround for the "SSPI context" issue.

I tested again the connection and here is the output:
> osql -E -S server\MSSmallBusiness,1433

1
When trying to configure BCM from Outlook and selecting the option: "Connect with a remote database" I can see the created/shared Database but I can't select it.

The database name is displayed "MSSmallBusiness", the version is "Oulook 2013" but the entry is greyed out and I can't complete the setup.

Any magical hints left?
 

wallisellener

Senior Member
Outlook version
Outlook 2013 64 bit
Email Account
Exchange Server
Maybe the error is related to the BCM version.

I have outlook 2013 installed and the BCM version is 4.00.12006.00

Could you please confirm if this is the compatible version with Outlook 2013?

Are there any other BCM versions available?
 

wallisellener

Senior Member
Outlook version
Outlook 2013 64 bit
Email Account
Exchange Server
Reviving this old thread because some installation issues:

- we are installing BCM for Office 2013 32 bit Installation or at least trying

- the installation is not successfull

An user setup would be: WIN7 32 bit with Office 2013 32 bit. Any additional software required?

What are the prerequisites for a BCM Client installation (user installation)?
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
R Outlook 365 update sets delete from server flag Using Outlook 1
J Importing N2K from a different Exchange Server Using Outlook 1
G Forward email body to other mail list directly from Exchange server Exchange Server Administration 1
T Outlook 2010 How to Delete “Orphaned” TO DO? ( Not on Exchange Server) Using Outlook 6
A Connect to server to views items Using Outlook 0
J Moved many emails to Outlook external folder, need to delete on Gmail server Using Outlook 14
icacream Enter your user name and password for the following server. Using Outlook 4
T How can Exchange be configured to sync/push one-way so that the server data can't be affected Exchange Server Administration 0
F outlook.com Exchane Server corrupts data Since September 2019 Using Outlook.com accounts in Outlook 6
llama_thumper Setting up forwarders on Exchange server Exchange Server Administration 0
W Encrypted connection to server refused Using Outlook 0
B Server errors Outlook 2007 Using Outlook 1
M Outlook 2016 Requesting data from server Using Outlook 0
R Copy Outlook Public Folders to a File Server Shared Folder Using Outlook 0
I IMAP - are emails dynamically fetched from server as required? Using Outlook 2
CWM030 Name Server's Exchange Server Administration 15
CWM030 Archiving ON the imap server Using Outlook 3
G How to have domain client use owa server instead of exchange server while connect to network Using Outlook 1
GaryW88 2016 Archiving IMAP keeping mail on Gmail Server Using Outlook 1
R Would creating a new profile cause Outlook to download all the old mails from the server? Using Outlook 1
P Microsoft Outlook is requesting data from the server Using Outlook 2
J Old unread emails on current date (MDaemon Server) Using Outlook 1
E Duplicate, nested account folders on ATT server Using Outlook 10
Cdub27 Your changes to this item couldn't be saved because Server Denied Operation (HTTP 403 Forbidden) Using Outlook 1
O Outlook 2016 0x800CCC0F 'The connection to the server was interrupted' Using Outlook.com accounts in Outlook 1
crazyboy Problems connecting to BCM on Server Using Outlook 2
M Problems Downloading Content from Server(s) Using Outlook 0
K IMAP Server Wants to alert you to the following: cannpt rename system folder Using Outlook 1
T Uploading Outlook 2016 Contacts to Exchange Server Drops "Company" field data in 30% of records Exchange Server Administration 4
Diane Poremsky Archiving Tools for Exchange Server Using Outlook 4
Diane Poremsky Changing the Message Size in Exchange Server Using Outlook 0
R Outlook 2007 - Shared Accounts and Resources without Exchange Server Using Outlook 0
J IMAP server Using Outlook 0
Diane Poremsky Exchange Server Updates March 2016 Using Outlook 0
J Your IMAP server wants to alert you to the following: cannot remove system folder Using Outlook 3
oliv- "Online mode with Exchange server" vs "online" Exchange Server Administration 2
W Deleting Emails from the Server in Outlook 2016 Using Outlook 2
B Outlook not deleting messages from server Using Outlook 0
I Random Chinese characters in email copied from a pst file. Exchange Server 2016 Public Folder Exchange Server Administration 1
M Outlook 2010 Error: Your IMAP server closed the connection Using Outlook.com accounts in Outlook 1
Diane Poremsky Save Sent Items in Shared Mailbox using an Exchange Server Cmdlet Using Outlook 0
K IMAP Subfolders missing after migrating to new server Using Outlook 0
Diane Poremsky Exchange Server and SMTP Servers Using Outlook 0
J Leave mail on server when Outlook off Using Outlook 0
B Can't Connect to Office365 Exchange Server Exchange Server Administration 2
Ascar_CT Outlook.com transition to Exchange Server on the back-end Using Outlook.com accounts in Outlook 0
E I have had a total server crash. Exchange Server Administration 2
N Control ID for Outlook 2013 “Recover Deleted Items From Server” Using Outlook 0
Diane Poremsky Common Outlook Outgoing Server (SMTP) Errors Using Outlook 0
Diane Poremsky Exchange Server Usage, Reporting, and Analysis Tools Using Outlook 0

Similar threads

Top