I have previously asked this question and then it got deleted because there was no response. I am re posting this question (as recommended by a moderator) and the answer that I have figured out so that others may benifit from my $200 call to Microsoft.
I am running BCM 2007 on a SQL 2005 Express database install and have the database shared. This is running in a domain environment. I am able to connect to the shared database perfectly from any computer running on the local network in our Main office. We have two branch offices and they are connected via VPN tunnels and are on different subnets. When I attempt to connect to the shared database from one of the computers in these offices I get an error (see attached photo) :
"Cannot fine computer <computername>. Confirm that the remote computer exists and that it is available on the network."
From this same computer, I can ping the database computer just fine. I have tried connecting via ip and computer name but get the same error.
I'm not sure what is blocking BCM from connecting to the shared database.