can not establish BCM 2010 connection to Shared DB on SQL 2008 Express

Status
Not open for further replies.

BWend

Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Hi all,

first of all I did not want to post any repeating posts.. but I looked up any forum and all possible answers... but still found no solution for the planned company setup.

First of all we did test out the BCM 2010 on our local LAN using a Desktop WIN7/64 Professional with SQL 2008 Express SP1 and the BCM Database tool installing a MSSMLBIZ DB Instance and a BCM Database...

after making sure that :

> .. DB Tool and BCM use the same language - in our CASE "EN"

> .. the default Port 5356 is configured correctly in the Firewall

> .. the MSSMLBIZ Instance the Named Pipes and TCP/IP protocoll ist enabled and configured to use the Port 5356

> .. all Server users and PW match the local user / PW on the Client PC

We got the solution to work and are quite happy with the functionality for us as a small company.

But now our boss did want to have the BCM Database available even when not in the office (he is not satisfied with the offline standard solution...
ur Approach:

We did buy a virtual server Windows Server 2008 R2 Datacenter edition with a hosting provider and did install as above the SQL 2008 Express Server and the BCM Database tool to create the Database.

checked the firewall settings and the user settings... but can still not establish a connection with the Database from any of the clients / users.

We can ping the server via name or IP no issues

even using the SQL Command on any of the client PC's:
sqlcmd -E -S tcp:xxx.xxx.com\MSSMLBIZ,5356 does show an established connection to the DB instance

However the BCM connection dialog does allways show the same error message no DB no matter if using the server name or the IP Adress or even together with the Port "xxx.xxx.com\MSSMLBIZ, 5356".

Does anybody has any idea on what else could be wrong or what other settings (port, shares, etc) need to be adapted?

Thanks for any help.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
one thing i did not try and i don't know if anyone else did, is a hosts file for the internet ip of the netbios name. For example, the server is called RT004, and the internet ip is 204.205.206.14 - you'd put that in the hosts file in this format

205.205.206.14 RT004
 

BWend

Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
one thing i did not try and i don't know if anyone else did, is a hosts file for the internet ip of the netbios name. For example, the server is called RT004, and the internet ip is 204.205.206.14 - you'd put that in the hosts file in this format

205.205.206.14 RT004
Dear Diane,

thanks for your fast replies, I tried the DNS table host first but with no success.

Next thing I will try within the next couple of days to establish a VPN tunnel between the Virtual hosted Server and one of the clients.

Bernd
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
thanks - i din't think it would work, but it was the best option. given the choice between vpn and offline data, i'd take offline data all the time, but for people who are on the road, dialing in to sync up and refresh would be a good option.
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
S Not able to establish Outlook on Windows server, office email, yahoo account Using Outlook 1
M Need to establish Outlook 2010 as default email program. Using Outlook 7
T How to establish Soap Connection Outlook VBA and Custom Forms 5
P BCM conditional formatting BCM (Business Contact Manager) 5
B Outlook Business Contact Manager with SQL to Excel, User Defined Fields in BCM don't sync in SQL. Can I use VBA code to copy 1 field to another? BCM (Business Contact Manager) 0
D BCM 2013 not functioning as BCM 2010 Example no drop down for communications history Using Outlook 0
J No access to a Database BCM BCM (Business Contact Manager) 3
J Marketing task MS BCM BCM (Business Contact Manager) 10
S BCM Compulsory field, New opportunity Outlook VBA and Custom Forms 0
A BCM does not work anymore! BCM (Business Contact Manager) 1
G Windows Update Causes BCM Database Access Problem? BCM (Business Contact Manager) 4
A BCM does not work with Windows 10 1703 any more BCM (Business Contact Manager) 3
S BCM Auto Backup Data and Customizations BCM (Business Contact Manager) 6
S BCM Project Task Order BCM (Business Contact Manager) 1
T Lost access to remote BCM database BCM (Business Contact Manager) 4
crazyboy Problems connecting to BCM on Server Using Outlook 2
J Problems connecting to BCM BCM (Business Contact Manager) 16
T BCM 2010 randmoly going offline BCM (Business Contact Manager) 0
M At last a BCM alternative... Outlook Customer Mngr 365! BCM (Business Contact Manager) 0
S BCM view customization BCM (Business Contact Manager) 1
L Cannot Connect to BCM database BCM (Business Contact Manager) 9
A Cannot connect to BCM database BCM (Business Contact Manager) 3
K BCM Reports: Timeout Expired BCM (Business Contact Manager) 0
K BCM hide subfolders BCM (Business Contact Manager) 1
Diane Poremsky Restoring BCM Database After Upgrading Windows New Slipstick.com Articles 0
J Unable to link email messages in BCM using a single microsoft office 365 account in outlook 2013 BCM (Business Contact Manager) 1
Diane Poremsky Trial/Beta program for BCM replacement BCM (Business Contact Manager) 8
A BCM crashes immediately after start BCM (Business Contact Manager) 2
A Two Problems with BCM BCM (Business Contact Manager) 0
J BCM 2013 displays wrong form for account and business contact BCM (Business Contact Manager) 1
A Latest updates kill BCM 2013 BCM (Business Contact Manager) 0
C Where are BCM User Customizations located? BCM (Business Contact Manager) 9
Diane Poremsky Outlook 2016: No BCM New Slipstick.com Articles 0
Diane Poremsky Outlook 2016: No BCM BCM (Business Contact Manager) 17
wallisellener BCM and MSSQL2012 BCM (Business Contact Manager) 2
M Can I use BCM projects for this BCM (Business Contact Manager) 1
R BCM Reporting of repeat calendar entries BCM (Business Contact Manager) 0
Eduardo Macias BCM 2013 with SQL Express 2014 BCM (Business Contact Manager) 5
A Upgrade BCM System from 2010 to 2013 BCM (Business Contact Manager) 0
A BCM crashes after Windows 10 update BCM (Business Contact Manager) 1
C BCM Text Boxes & tabs are too short when downloading to Office 365 BCM (Business Contact Manager) 0
jChambler Cant install BCM on windows 10 BCM (Business Contact Manager) 12
S BCM screen Layout BCM (Business Contact Manager) 7
Diane Poremsky BCM Errors after Upgrading to Windows 10 New Slipstick.com Articles 1
J Missing BCM TAB Main Menu - 2007 BCM (Business Contact Manager) 2
M Modifying BCM Database using Access BCM (Business Contact Manager) 1
jChambler BCM not installing properly with Outlook 360 BCM (Business Contact Manager) 3
S BCM crash Atheros Addin 2010 Using Outlook 1
R Installing BCM BCM (Business Contact Manager) 0
crazyboy Copying BCM database from backed up mounted image to new drive BCM (Business Contact Manager) 2
Similar threads


















































Top