adding database user in BCM 2007

[Blake]

Remote computer will not connect. Trying to connect my desktop with my
laptop. Have followed BCM instructions completely. Have changed user
names, computer names, passwords - all with no success. Have reinstalled
BCM. Am continually told that I have not been granted access or that the
password is incorrect.

Am suspicious the problem relates to both computers being set up under the
same user name. Have tried changing the logon name for the remote computer
but the error messages always refer to the original user logon name which
remains on the remote computer as the "registered computer user" name which
apparently cannot be changed. Any ideas will be greatly appreciated.

 

[Lon Orenstein]

Are you using XP Home on one or both of these PC's? That won't work... I
would also try to make both users Administrators to make sure permissions
are OK.

HTH,
Lon

___________________________________________________________
Lon Orenstein
pinpointtools, llc
(e-mail address removed)
Author of Outlook 2007 Business Contact Manager For Dummies
Author of the eBook: Moving from ACT! to Business Contact Manager
www.pinpointtools.com

 

[Blake]

XP Pro is on both. I am sole administrator on both machines. The
instructions are so simple. I have read and reread and tried and retried.
No luck. Can't imagine what I'm doing wrong.

 

[Luther]

XP Pro is on both. I am sole administrator on both machines. The
instructions are so simple. I have read and reread and tried and retried.
No luck. Can't imagine what I'm doing wrong.






- Show quoted text -

Let's remove BCM from the picture to narrow in on the problem.

You must have exactly the same login and password on both machines.

I assume you have BCM working on the desktop and a database, and that
you have successfully run the sharing wizard to share your database.

Try this from a command prompt window:
OSQL -E -S nameofdesktoppc\MSSMLBIZ,5356 -d MSSmallBusiness

If that doesn't succeed, then the error may indicate what the problem
is.

If it works, you will get a prompt. Type "exit" to leave osql.

 

[Luther]

XP Pro is on both. I am sole administrator on both machines. The
instructions are so simple. I have read and reread and tried and retried.
No luck. Can't imagine what I'm doing wrong.






- Show quoted text -

Let's remove BCM from the picture to narrow in on the problem.

You must have exactly the same login and password on both machines.

I assume you have BCM working on the desktop and a database, and that
you have successfully run the sharing wizard to share your database.

Try this from a command prompt window:
OSQL -E -S nameofdesktoppc\MSSMLBIZ,5356 -d MSSmallBusiness

If that doesn't succeed, then the error may indicate what the problem
is.

If it works, you will get a promt. Type "exit" to leave osql.

 

[Blake]

Luther,

1. if I use the same login on both computers the set up stops on the remote
computer because that "login already has shared access." I must
misunderstand what you mean.
2. your command prompt suggestiion produced a result of "1>"
3. I have set up the database on the local computer and have run the sharing
wizard numerous times hoping it might make a difference. No luck.

 

[Luther]

1. if I use the same login on both computers the set up stops on the remote
computer because that "login already has shared access." I must
misunderstand what you mean.

By login, I mean the Windows login.

For example, your Windows login should "Blake", with the same
password, on both machines.

I don't understand what you mean by "set up stops". Do you mean
connecting BCM on the laptop, to the database on the desktop?

2. your command prompt suggestiion produced a result of "1>"

If that happened on the laptop, then you have permission to access the
database on the desktop.

3. I have set up the database on the local computer and have run the sharing
wizard numerous times hoping it might make a difference.

I don't know what "local" means in context. You need to to run the
sharing wizard in BCM on the desktop, then connect BCM on the laptop
to the shared database on the desktop.