Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Remote server for MS Business Contact Manager 2010

30 May 2011   #1
GRoston

Windows 7 x64
 
 
Remote server for MS Business Contact Manager 2010

I would like to serve the database for BCM 2010 from an internet accessible server. This server also happens to be on my LAN.

First, I installed and configured the database on the server.

Using the server's LAN name and LAN IP:
I was able to successfully connect to the database when I used sqlcmd from my client machine. I was also able to successfully connect to the database when I used the BCM connection wizard from my client machine.

Using the server's internet name and internet IP:
I was able to successfully connect to the database when I used sqlcmd from my client machine. I was unable to connect to the database when I used the BCM connection wizard from my client machine. The error message is this, "The computer, <name>, is not available or does not contain any shared Business Contact Manager databases..." Using a packet sniffer on the server, I observed that no requests showed up on port 5356 when the connection request came from BCM.

These tests strongly suggest that
  • The firewall is properly configured
  • The database is properly configured
  • The BCM database is properly shared
So, my question is this: Is there some way to twist BCM's 'arm' such that it will connect to a database server not located on the same LAN as the client?

Thank you!


My System SpecsSystem Spec
.

31 May 2011   #2
Johnathan Lyman

Windows 7 Ultimate 64-bit
 
 

Quote   Quote: Originally Posted by GRoston View Post
I would like to serve the database for BCM 2010 from an internet accessible server. This server also happens to be on my LAN.

First, I installed and configured the database on the server.

Using the server's LAN name and LAN IP:
I was able to successfully connect to the database when I used sqlcmd from my client machine. I was also able to successfully connect to the database when I used the BCM connection wizard from my client machine.

Using the server's internet name and internet IP:
I was able to successfully connect to the database when I used sqlcmd from my client machine. I was unable to connect to the database when I used the BCM connection wizard from my client machine. The error message is this, "The computer, <name>, is not available or does not contain any shared Business Contact Manager databases..." Using a packet sniffer on the server, I observed that no requests showed up on port 5356 when the connection request came from BCM.

These tests strongly suggest that
  • The firewall is properly configured
  • The database is properly configured
  • The BCM database is properly shared
So, my question is this: Is there some way to twist BCM's 'arm' such that it will connect to a database server not located on the same LAN as the client?

Thank you!
You may also be having routing issues. The gateway/router may not be sending traffic from that port to the BCM server. Check your routing table and or port forwarding table.

What do you have the BCM server running on, out of curiosity?
My System SpecsSystem Spec
31 May 2011   #3
GRoston

Windows 7 x64
 
 

Johnathan,

Thanks for the reply. Since sqlcmd IS working when 'routed' via the internet, I do not think that the gateway/router is the issue, especially since I did configure it to route traffic to the BCM port to the server.

In my case, the 'server' is a fairly lame Windows XP box.
My System SpecsSystem Spec
.


09 Jun 2011   #4
Johnathan Lyman

Windows 7 Ultimate 64-bit
 
 

Quote   Quote: Originally Posted by GRoston View Post
Johnathan,

Thanks for the reply. Since sqlcmd IS working when 'routed' via the internet, I do not think that the gateway/router is the issue, especially since I did configure it to route traffic to the BCM port to the server.

In my case, the 'server' is a fairly lame Windows XP box.
I'm shooting in the dark at this point as I am unfamiliar with BCM. It is possible that the sqlcmd is pinging the server on a different or more well known port thus the firewall on said machine is allowing the sqlcmd traffic and not letting port 5356 through. Try disabling the Windows Firewall and or any other software firewalls you have on your machine. You could also have your port sniffed (lol at nerd joke) and see if it's really open: WhatsMyIP.org : Port Scanners/Sniffers.

Since traffic routing is not an issue, it should go straight to your bcm box.
My System SpecsSystem Spec
10 Jun 2011   #5
GRoston

Windows 7 x64
 
 

Johnathan - I am convinced that BCM is the problem - I am attempting to work around that by enabling VPN to my server.
My System SpecsSystem Spec
Reply

 Remote server for MS Business Contact Manager 2010




Thread Tools





Similar help and support threads
Thread Forum
Installing MS Outlook 2010 with Business Contact Manager
Can I install Outlook 2010 with Business Contact Manger on my new laptop Samsung 10.1" which has Windows 7 Starter installed. Also has a Skype preinstalled. As I want to use only for my business. Only E-mails and Skype. (Someone told me that it will not work. I do not want to spoil my new laptop)...
Microsoft Office
Business Contact Manager
I have upgraded to Windows 7PCs with Windows 7 professional and Outlook 2010 with Business Contact Manager 2010 from XP Professional V2002 Service Pack 3 and Outlook 2003 with Business Contact Manager 2003. When attempting to bring my Business Contact Manager database over from the XP PC I...
Microsoft Office
How to Backup Outlook 2010 and Business Contact Manager?
Hi all, does anybody know a simple way to backup outlook 2010 and also Business Contact Manager? I have tried following the help screens but they make no sense. Really appreciate some help on this one! Thanks in advance
Microsoft Office
Outlook 2010: Business Contact Manager Tutorial
Free Outlook 2010 Business Contact Manager Tutorial
Microsoft Office
microsoft business contact manager professional plus 2010
microsoft business contact manager professional plus 2010 wont install. I just recieved it today as part of the office 2010 pro plus suite and will not install. Any ideas welcome. thank you in advance
Microsoft Office
Business Contact Manager for Outlook 2010
More...
Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 15:21.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App