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

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

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

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

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

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 for2: Remote server for MS Business Contact Manager 2010
Thread Forum
Solved Installing MS Outlook 2010 with Business Contact Manager Microsoft Office
Outlook 2010: Business Contact Manager Tutorial Microsoft Office
Business Contact Manager 2010 - various issues Microsoft Office
2010 Business Contact Manager and Windows 7 Microsoft Office
Business Contact Manager for Office 2010 Microsoft Office
microsoft business contact manager professional plus 2010 Microsoft Office
Business Contact Manager for Outlook 2010 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 07:29 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33