Migrate users to a new domain
Hello, I have a same problem. Just there is one specific change that we are moving from "domain.local" to "domain.cz" so netbios name is the same "domain"
we have RDM version 2020.3.19 and using MS SQL.
Olda
RDM is very slow in updating hosts properties
Hello,
thank you for your help. Cleanup I already did before asking for help so I tried new beta version with Allow Entry State locks option disabled and it looks promising. I will test it more but after 2 days I does not see any problem I had before. What exactly means that I disabled this option?
Best regards, Oldrich
RDM is very slow in updating hosts properties
Hello,
we use Remote Desktop Manager Enterprise edition, version 13.0.6.0 with MS SQL database like data source. We use RDM more then 4 years and it looks like it is getting slower and slower. Now we have there more then 1800 hosts. Often I have to wait more then 6 seconds to open host properties and also when I change some host properties and I confirm it, it take some seconds to save (RDM freezes till properties are saved).
We are 10 people using same data source, but there is no difference when there is just one user or there are 10 users. MS SQL is standard version 2012 and other databases are running well.
Please, cloud anybody help me with this problem? It is possible that 1800 hosts is too much or there could be some other problem? If I have to wait everytime many seconds it is very annoying.
Today I also tried to disable offline cache and there is no difference.
Best regards, Oldrich
Problem with user creation
answer to your last message:
If I understand well: in SQL server you need to have your account in two places
1) /security/logins/
2) /databases/RDM_DB_name/security/users
I have account just in first place, because I use other database on server. In this case I can't create new user with this "create SQL login option" but on other hand if I don't use this option, there will be no account on second place mentioned above. So solution in this case is, that I will not use this create option and I have to create account by myself on second place? I'm asking just because it look to me like very common case ....
Olda
Problem with user creation
BTW If user doesn't have these three permissions in Rights (insert, edit, delete) but belongs to some security groups which have permissions to insert, edit and delete it will be logical to block user and doesn't let him to insert, edit or delete anything. It looks strange to see error message in case when software knows that user doesn't have permission to edit anything.
Problem with user creation
If user already has his login in SQL server (because he is using some different DB on server), I create new RDM database and then I try to create new user (with disabled option Create SQL Server login and user) in RDM client which is authenticating with account already having login in SQL server, user is not able to access database because he has no access to database.
How to do it right if user has login but he hasn't account in DB_NAME/Security/Users/? I know that I can create user on my own. I just want to know if there is some way how to do it with RDM or I have to solve this common situation by myself.
Olda
Problem with user creation
so it looks I misunderstood some RDM settings. Now I see that every user must have in his permission rights for add, edit and delete. I hoped that it is enough to give permission in security group. So it looks like points 1 and 2 are solved. Just point 3 with creating user in RDM which already has login on SQL server but he does not have account in RDM database security/users
Problem with user creation
- I will try in with clearing the cache. Just it looks to me little bit strange because we use just read only cache
- I see that there are some grant/deny permission, What I don't understand that it is not functioning even when I create user once more from zero. User is member of security group with create and delete permissions.
- problem is that if I clear option "Create SQL Server Login and User", user is created in RDM but it is not created in RMD_database/security/users so user is not able to connect this data source (user has login on database server because he is using different database on server, but there is no user definition in this new specific RDM database). Configuration option is creating both or nothing. In our case we need to create just user inside this RDM databse.
Problem with user creation
Hello,
it is not this case. problem with error message is just during saving new session. User can browse all data and it is the same even if I delete user in RDM, after I delete user through SQL studio (in RDM database and also in server login list) and then I recreate user once more with RDM (without error) and still I'm not able to create or delete. User can just browse existing sessions. I can resolve this problem by giving to this user db_owner on RDM database, but it is not good solution.
Second problem is that if I create second RDM database on same SQL server I cannot create same user which already exists in first database (user uses domain authentication) with error "Unable to save user in the database ! The server principal '................' already exists"
Problem with user creation
Hi,
we use RDM with MS SQL backend. We face trouble after moving RDM database to new SQL server. In many cases when I create new user in writes him error message when he is trying to add or delete something(when he adds new session, he see error -error is attached- but after confirming this error message he is able to see new session - but nobody else see this session). He is able to browse existing sessions without problem.
Because of this problem I tried to create new database on same SQL server, but when I try to create users in this new database, RDM is showing error message: "Unable to save user in the database ! The server principal '................' already exists". It is logical that login already exists because same user was created in first database.
Thank you for your help,
Olda