Can connect on VPN but not on network

[Guest]

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?

 

[Guest]

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

 

[Luther]

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



- Show quoted text -

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

 

[Guest]

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

 

[Luther]

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






- 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?

 

[Guest]

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.

 

[Guest]

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]

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.









- 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.

 

[Luther]

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.









- 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.