Error Granting user access to Company

[DBan13]

I receive the following error messages when I try to grant access to a company for a new user. I can create the user, I only receive the following messages when granting access to a company:


[Microsoft][ODBC SQL Server Driver][SQL Server] User or role ‘username’ already exists in the current database.

The stored procedure smUsrCmpnyAccssChckAccssCHG returned the following results: DBMS: 15023, Great Plains: 0.

I have tried the following:

1. Start Great Plains, and then log in as the sa user.
2. Click Tools, point to Setup, point to System, click SQL Options, clear both boxes, and then click OK.
3. Click Tools, point to Setup, point to System, click User Access, click to highlight the user, clear the box for the company you are trying to grant access to, and then click OK.
4. At the server that is running Microsoft SQL Server, in Enterprise Manager, expand Databases, expand the company database, and then click Users. Right-click the user and then click Delete.
5. In Great Plains, click Tools, point to Setup, point to System, click SQL Options, and then click to mark both boxes.
6. Click Tools, point to Setup, point to System, click User Access, click to highlight the user, click to mark the box for the company you are trying to grant access to, and then click OK.

I have also tried running the Grant SQL script on the Dynamics and Company DBs.

A few months ago, an outside contractor came in a changed the name of one of our company DBs for us. A few weeks ago I noticed that the owner of the company DB was no longer DYNSA, but this particular person. I changed the owner back to DYNSA. The problem began around the same time as the DB name change. I am at a loss as to what else to try. Any ideas?

Thank you,
Dban13

 

[klewis10367]

Just go into SQL without changing the Great Plains sql boxes and remove the user in question from the database you are trying to give access to. Then go into great Plains and give them access.

 

[DBan13]

Thanks for the reply. A couple of questions: Should I remove the user from the dynamics DB as well as the Company DB's (we have 7 company DBs)? Can I do this while users are in the system or should I wait until everyone is out of the system?

 

[klewis10367]

Just the databases that are giving you the errors. You do not want too remove them from Dynamics. You will use SQL Enterprise Manager and go to Security, find the sql login and open the user up and deselect their access to the company that is giving the error.

 

[klewis10367]

Users can be in the system.