Unable to save the user in the database

Disabled

Published 10 years ago

Hi!

We are creating a new Microsoft SQL Database from nothing. Since it wasn't working, I did this:

-Took the backup of the other database
-Imported into the new database
-Create Admin user for this database
-Remove all customer entries
-Create new entried
-Applies security

Then, I create a second user, but can't link to RDM. I get the message: Unable to save the user in database. User does not have permission to perfom this action.

My user have full access to RDM, apply security on Entried, but can't add user to the database (I double checked, the user has been created on the SQL server and assigned to this database as dbo)

Thanks

All Comments (2)

Jeff Dagenais

Published 10 years ago

Hello,

Have you created your database from RDM using an account who has the appropriate privileges (like SA as example)?

Best regards,

Jeff Dagenais

christian02

Published 10 years ago

Thanks for the reply, the initial database has been created with the administrator.

If I compare the other database I took backup from, the user SA isn't in the security/users list.I tried first creating an empty database, but I wasn't able to connect any user on it. That's why I started with from my actual database.

Also, on the admin user I can connect in RDM database, I added table access: attachment, connections, databaseinfo, groupeinfo, userinfo, usersecurity (copied from another user)