New
#1
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!