Getting SQL error when trying to give user(s) company access 2

[ZeppelinL]

Hello,

I'm trying to give some users access to a company. When I do this, I get a SQL Server error: 'User or role '<user>' already exists in the current database.' Click OK, I then get the next error: 'The stored procedure smUsrCmpnyAccssChckAccssCHG returned the following results: DBMS: 15023, Great Plains: 0.

If any one has any ideas or solutions. I'd really appreciated it.

I know my way around Great Plains, it's just the SQL Server just I have trouble with.

Thanks a lot,
Z

 

[barbola]

1. Launch Dynamics/eEnterprise and login as the sa user.

2. Go to Setup|System|SQL Options and unmark both boxes, choose OK.

3. Go into Setup|System|User Access and unmark the box for the company you are trying to grant access to, choose OK.

4. At the Microsoft SQL Server, go into Enterprise Manager under Databases and select the new database. Go into Groups/Users file and pull up the user and right click on it and choose Delete.

5. Go back into Dynamics/eEnterprise and go into Setup|System|SQL Options and mark both boxes.

6. Now go into Setup|System|User Access and mark the box for the company you wish to grant access to.


Thanks!
Barb E.