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.