GP Security Error: The user could not be added to one or more databases

(0) Share

Report

Posted on by Napolo

750

I am getting the below error when trying to give access to the Test companies for a single user. Only one user is affected, but this user can receive access for the live companies.

Does anyone have any troubleshooting suggestions? I found something online that has to do with verifying SQL Server setup, but the link with instructions is no longer available. I don't receive my SQL Server query training until November. Any help would be appreciated.

*This post is locked for comments

All responses (9)

Answers (1)

Marsha Pavelich 630 on at

Like (0)

Report

RE: GP Security Error: The user could not be added to one or more databases

I have tried all of the suggestions and I am still getting the error message. Any other suggestions?
twelvestrikes 3,657 on at

Like (0)

Report

RE: GP Security Error: The user could not be added to one or more databases

Hi ecujak

Check that the DYNSA owns the DYNAMICS and company databases.

If not, change the db owner to DYNSA.

In SQL Mgt studio, check under Properties > User Mapping. The default schema should be dbo for your user.
Community Member Microsoft Employee on at

Like (0)

Report

RE: GP Security Error: The user could not be added to one or more databases

yes, I tried that. Says i own schemas and will not allow me to delete.
Napolo 750 on at

Like (0)

Report

RE: GP Security Error: The user could not be added to one or more databases

Hi,

I was able to get it to work following the steps in this link.

support.microsoft.com/.../929601
Community Member Microsoft Employee on at

Like (0)

Report

RE: GP Security Error: The user could not be added to one or more databases

Same, This still didn't work for me.
Community Member Microsoft Employee on at

Like (0)

Report

RE: GP Security Error: The user could not be added to one or more databases

Hi. The fix did not work for me. Any other suggestions?

Thanks
Napolo 750 on at

Like (0)

Report

RE: GP Security Error: The user could not be added to one or more databases

Thank you Sandip!

This is exactly what I needed :)
Napolo 750 on at

Like (0)

Report

RE: GP Security Error: The user could not be added to one or more databases

Thank you, Sandip!

This is exactly what I needed;)
Verified answer

sandipdjadhav 18,265 on at

Like (1)

Report

RE: GP Security Error: The user could not be added to one or more databases

Hi Nicole,

Follow below KB.

https://support.microsoft.com/en-us/kb/929601

Thanks much

Sandip Jadhav