Just installed BCM 2007 on Vista. The shared database is on the server. I
can connect to the shared database over VPN from home but not when I'm docked
at the office and on the network. My business partner has XP and can connect
without problems either on the network or over VPN.

Any suggestions?

Update:

When I first start Outlook 2007 while connected to our domain locally, the
Business Contact Manager status is "Online". This remains true until Outlook
itself actually connects to Microsoft Exchange. Why would this happen while
on the domain but not over VPN?

"Robert T." wrote:

> Just installed BCM 2007 on Vista. The shared database is on the server. I
> can connect to the shared database over VPN from home but not when I'm docked
> at the office and on the network. My business partner has XP and can connect
> without problems either on the network or over VPN.
>
> Any suggestions?

On Nov 16, 6:28 am, Robert T. <Robe...@discussions.microsoft.com>
wrote:
> Update:
>
> When I first start Outlook 2007 while connected to our domain locally, the
> Business Contact Manager status is "Online". This remains true until Outlook
> itself actually connects to Microsoft Exchange. Why would this happen while
> on the domain but not over VPN?
>
>
>
> "Robert T." wrote:
> > Just installed BCM 2007 on Vista. The shared database is on the server. I
> > can connect to the shared database over VPN from home but not when I'm docked
> > at the office and on the network. My business partner has XP and can connect
> > without problems either on the network or over VPN.
>
> > Any suggestions?- Hide quoted text -
>
> - Show quoted text -

This is the same machine that can connect over VPN but not on the
office LAN?

Yes. It is my laptop. Dell M90. I switch between LAN at the office and VPN
at home.

"Luther" wrote:

> On Nov 16, 6:28 am, Robert T. <Robe...@discussions.microsoft.com>
> wrote:
> > Update:
> >
> > When I first start Outlook 2007 while connected to our domain locally, the
> > Business Contact Manager status is "Online". This remains true until Outlook
> > itself actually connects to Microsoft Exchange. Why would this happen while
> > on the domain but not over VPN?
> >
> >
> >
> > "Robert T." wrote:
> > > Just installed BCM 2007 on Vista. The shared database is on the server. I
> > > can connect to the shared database over VPN from home but not when I'm docked
> > > at the office and on the network. My business partner has XP and can connect
> > > without problems either on the network or over VPN.
> >
> > > Any suggestions?- Hide quoted text -
> >
> > - Show quoted text -
>
> This is the same machine that can connect over VPN but not on the
> office LAN?
>

On Nov 19, 6:21 am, Robert T. <Robe...@discussions.microsoft.com>
wrote:
> Yes. It is my laptop. Dell M90. I switch between LAN at the office and VPN
> at home.
>
>
>
> "Luther" wrote:
> > On Nov 16, 6:28 am, Robert T. <Robe...@discussions.microsoft.com>
> > wrote:
> > > Update:
>
> > > When I first start Outlook 2007 while connected to our domain locally, the
> > > Business Contact Manager status is "Online". This remains true until Outlook
> > > itself actually connects to Microsoft Exchange. Why would this happen while
> > > on the domain but not over VPN?
>
> > > "Robert T." wrote:
> > > > Just installed BCM 2007 on Vista. The shared database is on the server. I
> > > > can connect to the shared database over VPN from home but not when I'm docked
> > > > at the office and on the network. My business partner has XP and can connect
> > > > without problems either on the network or over VPN.
>
> > > > Any suggestions?- Hide quoted text -
>
> > > - Show quoted text -
>
> > This is the same machine that can connect over VPN but not on the
> > office LAN?- Hide quoted text -
>
> - Show quoted text -

First question is can the laptop in the office see the server machine?
Type this in a command window:
ping nameofdatabasemachine

If that works, try connecting to the database without BCM. Type this
in a command window:
sqlcmd -E -S "nameofdatabasemachine\mssmlbiz,5356" -Q "select
substring(name,1,20), state_desc from sys.databases"

That should return a list of databases, or some explanation of why it
cannot connect.

Also, when you connect over the VPN, does the VPN software attach your
laptoip to the domain? If not, in the office you could try not logging
onto the domain, and trying to reach the database as a workgroup
machine. Is the problem limited to BCM--can you reach other network
resources like shared folders and printers on the domain?

Luther,

I could ping the server just fine over VPN but not logged into the domain.
Also, when on the domain I tried your sqlcmd and it came back with "Sqlcmd:
Error: Microsoft SQL Native Client " Unable to complete login process due to
delay in opening server connection.


As far as the VPN software, we are just using Windows VPN (whatever comes
with Vista). I am told that it does connect me to the domain.

When it comes to network resources like shared folders and printers, I
believe that part works fine. I can see our S: and T: drives and printers
just like my coworker who's on XP.


"Luther" wrote:

> On Nov 19, 6:21 am, Robert T. <Robe...@discussions.microsoft.com>
> wrote:
> > Yes. It is my laptop. Dell M90. I switch between LAN at the office and VPN
> > at home.
> >
> >
> >
> > "Luther" wrote:
> > > On Nov 16, 6:28 am, Robert T. <Robe...@discussions.microsoft.com>
> > > wrote:
> > > > Update:
> >
> > > > When I first start Outlook 2007 while connected to our domain locally, the
> > > > Business Contact Manager status is "Online". This remains true until Outlook
> > > > itself actually connects to Microsoft Exchange. Why would this happen while
> > > > on the domain but not over VPN?
> >
> > > > "Robert T." wrote:
> > > > > Just installed BCM 2007 on Vista. The shared database is on the server. I
> > > > > can connect to the shared database over VPN from home but not when I'm docked
> > > > > at the office and on the network. My business partner has XP and can connect
> > > > > without problems either on the network or over VPN.
> >
> > > > > Any suggestions?- Hide quoted text -
> >
> > > > - Show quoted text -
> >
> > > This is the same machine that can connect over VPN but not on the
> > > office LAN?- Hide quoted text -
> >
> > - Show quoted text -
>
> First question is can the laptop in the office see the server machine?
> Type this in a command window:
> ping nameofdatabasemachine
>
> If that works, try connecting to the database without BCM. Type this
> in a command window:
> sqlcmd -E -S "nameofdatabasemachine\mssmlbiz,5356" -Q "select
> substring(name,1,20), state_desc from sys.databases"
>
> That should return a list of databases, or some explanation of why it
> cannot connect.
>
> Also, when you connect over the VPN, does the VPN software attach your
> laptoip to the domain? If not, in the office you could try not logging
> onto the domain, and trying to reach the database as a workgroup
> machine. Is the problem limited to BCM--can you reach other network
> resources like shared folders and printers on the domain?
>

More information:

Outlook did not connect to the exchange server this morning and is asking
for my password. What's funny is that BCM shows as Online. This is at the
office, not VPN.

"Luther" wrote:

> On Nov 19, 6:21 am, Robert T. <Robe...@discussions.microsoft.com>
> wrote:
> > Yes. It is my laptop. Dell M90. I switch between LAN at the office and VPN
> > at home.
> >
> >
> >
> > "Luther" wrote:
> > > On Nov 16, 6:28 am, Robert T. <Robe...@discussions.microsoft.com>
> > > wrote:
> > > > Update:
> >
> > > > When I first start Outlook 2007 while connected to our domain locally, the
> > > > Business Contact Manager status is "Online". This remains true until Outlook
> > > > itself actually connects to Microsoft Exchange. Why would this happen while
> > > > on the domain but not over VPN?
> >
> > > > "Robert T." wrote:
> > > > > Just installed BCM 2007 on Vista. The shared database is on the server. I
> > > > > can connect to the shared database over VPN from home but not when I'm docked
> > > > > at the office and on the network. My business partner has XP and can connect
> > > > > without problems either on the network or over VPN.
> >
> > > > > Any suggestions?- Hide quoted text -
> >
> > > > - Show quoted text -
> >
> > > This is the same machine that can connect over VPN but not on the
> > > office LAN?- Hide quoted text -
> >
> > - Show quoted text -
>
> First question is can the laptop in the office see the server machine?
> Type this in a command window:
> ping nameofdatabasemachine
>
> If that works, try connecting to the database without BCM. Type this
> in a command window:
> sqlcmd -E -S "nameofdatabasemachine\mssmlbiz,5356" -Q "select
> substring(name,1,20), state_desc from sys.databases"
>
> That should return a list of databases, or some explanation of why it
> cannot connect.
>
> Also, when you connect over the VPN, does the VPN software attach your
> laptoip to the domain? If not, in the office you could try not logging
> onto the domain, and trying to reach the database as a workgroup
> machine. Is the problem limited to BCM--can you reach other network
> resources like shared folders and printers on the domain?
>

On Nov 21, 6:48 am, Robert T. <Robe...@discussions.microsoft.com>
wrote:
> More information:
>
> Outlook did not connect to the exchange server this morning and is asking
> for my password. What's funny is that BCM shows as Online. This is at the
> office, not VPN.
>
>
>
> "Luther" wrote:
> > On Nov 19, 6:21 am, Robert T. <Robe...@discussions.microsoft.com>
> > wrote:
> > > Yes. It is my laptop. Dell M90. I switch between LAN at the office and VPN
> > > at home.
>
> > > "Luther" wrote:
> > > > On Nov 16, 6:28 am, Robert T. <Robe...@discussions.microsoft.com>
> > > > wrote:
> > > > > Update:
>
> > > > > When I first start Outlook 2007 while connected to our domain locally, the
> > > > > Business Contact Manager status is "Online". This remains true until Outlook
> > > > > itself actually connects to Microsoft Exchange. Why would this happen while
> > > > > on the domain but not over VPN?
>
> > > > > "Robert T." wrote:
> > > > > > Just installed BCM 2007 on Vista. The shared database is on the server. I
> > > > > > can connect to the shared database over VPN from home but not when I'm docked
> > > > > > at the office and on the network. My business partner has XP and can connect
> > > > > > without problems either on the network or over VPN.
>
> > > > > > Any suggestions?- Hide quoted text -
>
> > > > > - Show quoted text -
>
> > > > This is the same machine that can connect over VPN but not on the
> > > > office LAN?- Hide quoted text -
>
> > > - Show quoted text -
>
> > First question is can the laptop in the office see the server machine?
> > Type this in a command window:
> > ping nameofdatabasemachine
>
> > If that works, try connecting to the database without BCM. Type this
> > in a command window:
> > sqlcmd -E -S "nameofdatabasemachine\mssmlbiz,5356" -Q "select
> > substring(name,1,20), state_desc from sys.databases"
>
> > That should return a list of databases, or some explanation of why it
> > cannot connect.
>
> > Also, when you connect over the VPN, does the VPN software attach your
> > laptoip to the domain? If not, in the office you could try not logging
> > onto the domain, and trying to reach the database as a workgroup
> > machine. Is the problem limited to BCM--can you reach other network
> > resources like shared folders and printers on the domain?- Hide quoted text -
>
> - Show quoted text -

I don't know the details but "online" to Outlook should mean connected
to Exchange, and online to BCM should mean connected to primary
database--as opposed to the offline database, if that's enabled.

On Nov 21, 6:35 am, Robert T. <Robe...@discussions.microsoft.com>
wrote:
> Luther,
>
> I could ping the server just fine over VPN but not logged into the domain.
> Also, when on the domain I tried your sqlcmd and it came back with "Sqlcmd:
> Error: Microsoft SQL Native Client " Unable to complete login process due to
> delay in opening server connection.
>
> As far as the VPN software, we are just using Windows VPN (whatever comes
> with Vista). I am told that it does connect me to the domain.
>
> When it comes to network resources like shared folders and printers, I
> believe that part works fine. I can see our S: and T: drives and printers
> just like my coworker who's on XP.
>
>
>
> "Luther" wrote:
> > On Nov 19, 6:21 am, Robert T. <Robe...@discussions.microsoft.com>
> > wrote:
> > > Yes. It is my laptop. Dell M90. I switch between LAN at the office and VPN
> > > at home.
>
> > > "Luther" wrote:
> > > > On Nov 16, 6:28 am, Robert T. <Robe...@discussions.microsoft.com>
> > > > wrote:
> > > > > Update:
>
> > > > > When I first start Outlook 2007 while connected to our domain locally, the
> > > > > Business Contact Manager status is "Online". This remains true until Outlook
> > > > > itself actually connects to Microsoft Exchange. Why would this happen while
> > > > > on the domain but not over VPN?
>
> > > > > "Robert T." wrote:
> > > > > > Just installed BCM 2007 on Vista. The shared database is on the server. I
> > > > > > can connect to the shared database over VPN from home but not when I'm docked
> > > > > > at the office and on the network. My business partner has XP and can connect
> > > > > > without problems either on the network or over VPN.
>
> > > > > > Any suggestions?- Hide quoted text -
>
> > > > > - Show quoted text -
>
> > > > This is the same machine that can connect over VPN but not on the
> > > > office LAN?- Hide quoted text -
>
> > > - Show quoted text -
>
> > First question is can the laptop in the office see the server machine?
> > Type this in a command window:
> > ping nameofdatabasemachine
>
> > If that works, try connecting to the database without BCM. Type this
> > in a command window:
> > sqlcmd -E -S "nameofdatabasemachine\mssmlbiz,5356" -Q "select
> > substring(name,1,20), state_desc from sys.databases"
>
> > That should return a list of databases, or some explanation of why it
> > cannot connect.
>
> > Also, when you connect over the VPN, does the VPN software attach your
> > laptoip to the domain? If not, in the office you could try not logging
> > onto the domain, and trying to reach the database as a workgroup
> > machine. Is the problem limited to BCM--can you reach other network
> > resources like shared folders and printers on the domain?- Hide quoted text -
>
> - Show quoted text -

Not being able to ping the server while on the domain is the lowest
level problem. You'll need to resolve that before BCM can find its
database.