Unable to access shared database

[David E. Solie]

I have a client running BCM 3.0 with Office 2007 SBE and XP Pro SP2. Office
2007 and BCM SP1 have been installed. The shared DB is hosted on a DT which
is hard wired to the router. The 2 NB's are using a wireless connection to
the network. Windows level file and print sharing work fine.

This problem occured after the user profile was corrupted on one of the
NB's. We created a new profile with a different name and copied the
documents & pst files over to the new profile. The NB is now unable to access
the BCM database. The sequence is as follows:

1. Created the new user in BCM on the host machine and assigned a temp pw.
2. Use the "Create or Select BCM database" on the NB and type in the name
of the host CPU.
3. The host CPU comes back and says the local and remote paswwords do not
match and asks to change them. Setting of the remote to match the local
password is successful but after a period of time, a "cannot access the
database server on computer xyz" error message appears.

One interesting item is that it does not seem to make a difference what user
name is set up on this notebook, it will not complete the connection to the
shared database.

The second notebook is still able to access the shared database and for
testing purposes, all firewalls have been turned off. Do you have any
suggestions?

thanks,
David E. Solie

 

[Luther]

I have a client running BCM 3.0 with Office 2007 SBE and XP Pro SP2.  Office
2007 and BCM SP1 have been installed.  The shared DB is hosted on a DT which
is hard wired to the router.  The 2 NB's are using a wireless connection to
the network.  Windows level file and print sharing work fine.  

This problem occured after the user profile was corrupted on one of the
NB's.  We created a new profile with a different name and copied the
documents & pst files over to the new profile. The NB is now unable to access
the BCM database.  The sequence is as follows:

 1. Created the new user in BCM on the host machine and assigned a temppw.
 2. Use the "Create or Select BCM database" on the NB and type in the name
of the host CPU.
 3. The host CPU comes back and says the local and remote paswwords do not
match and asks to change them.  Setting of the remote to match the local
password is successful but after a period of time, a "cannot access the
database server on computer xyz" error message appears.

One interesting item is that it does not seem to make a difference what user
name is set up on this notebook, it will not complete the connection to the
shared database.

The second notebook is still able to access the shared database and for
testing purposes, all firewalls have been turned off.  Do you have any
suggestions?

thanks,
David E. Solie

A new Mail profile shouldn't change Windows authentication if BCM was
already working for that login with a shared db.

The Windows username and password have to match on the server and
client is the absic requirement. You can set those manually and avoid
BCM's password UI. If they are the same, and BCM still won't connect,
see if the user can connect to the database without BCM; e.g. try
connecting with sqlcmd or Sql Mgtm Studio.