Unable to add new users to shared Business Contact Manager database using the Database Tool

Hello,

I'm attempting to add users to a shared Business Contact Manager database using the BCM Database Tool and I'm getting the following error:
"The current user does not have permission to grant other users permission to connect to the sql server. Please give current user grantlogin privilege on the SQL server."
This worked for the last few months after it was set up.  The server is running WIndows Server 2003 Standard SP2.  I read a similar post in EE that said to make the current user (domain administrator) a sysadmin for the database by checking the box in SQL Management Studio while logged in as the sa account.  I've done this but the situation is the same.  I also attempted to add the users manually in SQL Management Studio and grant permissions that way, but it gives an error that the user already exists although I  don't see it anywhere.
Any help is appreciated.
Thanks,
bluelangroupAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

scrathcyboyCommented:
"make the current user (domain administrator) a sysadmin for the database by checking the box in SQL Management Studio while logged in as the sa account.  I've done this but the situation is the same."

You don't want to give a user domain ADMIN privileges if it is not needed. This is telling you what to do --
"Please give current user grantlogin privilege on the SQL server."

So you need to go to the SQL server, login as ADMIN, and assign this user grant login privileges just for that application, not for global windows privileges.  If you are getting an error, it is because his current profile has become corrupted.  You will have to find that profile, by user name or login name, and delete it.  Then you can remake it and give him the correct privileges.  Most likely an issue of profile corruption.
0
bluelangroupAuthor Commented:
OK, so I added a brand new user by creating it in SQL Management Studio without using the BCM Database Admin Tool and gave it the same permissions as existing BCM users, and it works fine for this user.  So the problem seems to only be with adding users via the BCM Database Admin Tool.  The problem is, when I try to add a user in SQL Management Studio that I had previously tried and failed to add via the Admin Tool, I get an error that says the user already exists.  I checked all the users and logins defined in Management Studio and these users do not show up.  So please let me know how I can find and delete the orphaned users so I can re-create them.

Thanks.
0
scrathcyboyCommented:
"So please let me know how I can find and delete the orphaned users so I can re-create them."

Remember that the program links to SQL databases depend on a lot of factors -- the SQL DLL links on all computers must be the same as the SQL version and DLL files on the server.  It is possible the when BCM was installed, the SQL database links were not the same as on the server.  If the SQL connect versions are different from workstations to the server, you will get all kinds of incompatibilities like you see.

Changing to admin won't help if the SQL database links are not connecting right from server to the work stations.  This is a complex problem.  You can uninstall BCM and reinstall it, but it still may not sync with the SQL server versions.  Can you call BCM support and have them resolve version incompatibilities?

Short of this, you will probably have to make all accounts with the SQL tools, but that almost orphans BCM.  What I am saying is that you are dealing with a complex interconnected system, and you will need either BCM or SQL direct help to resolve it.  We can't do it here remotely without ability to test.
0
bluelangroupAuthor Commented:
Thanks for the help with this.  As it turned out, these were domain accounts that, unknown to me, were created by renaming old accounts.  These old domain accounts were in the BCM database under a different name but, of course, with the same SID.  So it gave an error when adding these user accounts since they already existed, althought under a different login name.  So it had nothing to do with BCM or what tool is used to create users.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
scrathcyboyCommented:
please close the question by awarding points to any answer that helped
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Software

From novice to tech pro — start learning today.