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

(0) Share

Report

Posted on by Napolo

766

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

I have the same question (0)

All responses (9)

Answers (1)

Verified answer

sandipdjadhav 18,306 on at

Like (1)

Report

Hi Nicole,

Follow below KB.

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

Thanks much

Sandip Jadhav

Was this reply helpful? Yes No
Napolo 766 on at

Like (0)

Report

Thank you, Sandip!

This is exactly what I needed;)

Was this reply helpful? Yes No
Napolo 766 on at

Like (0)

Report

Thank you Sandip!

This is exactly what I needed :)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Thanks

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Same, This still didn't work for me.

Was this reply helpful? Yes No
Napolo 766 on at

Like (0)

Report

Hi,

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

support.microsoft.com/.../929601

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
twelvestrikes 3,657 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Marsha Pavelich 632 on at

Like (0)

Report

I have tried all of the suggestions and I am still getting the error message. Any other suggestions?

Was this reply helpful? Yes No