On Nov 3, 12:26 pm, David E. Solie
<DavidESo...[ at ]discussions.microsoft.com> wrote:
[Quoted Text] > 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
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.
|