Add users

avatar

LS,
In RDM 11.0.6.0 you can select integrated security and create SQL server login when you want to add a user but in 11.0.12.0 you can only select integrated security.
When I now want to add a user he don't create it in the database and he cannot use RDM.

Create_user_11.0.12.0.png

Create_user_11.0.6.0.png

All Comments (15)

avatar

Hello,
This is a known issue and we will release a fix today.

David Hervieux

avatar

Hello,
We have released an update. Could you give it a try?

David Hervieux

avatar

After installing 11.0.14.0 I still don.t have the two options select integrated security and create SQL server login. I only have the option select integrated security.

avatar

@Sebastiaan - We no longer have the "create SQL Server Login" option.

Why? Since it lead to confusion. If an admin forgot to select the option the system wouldn't create the user and unless that user already existed + privileges properly granted the new user couldn't logon or use RDM. The only workaround would be to delete the user and recreate with the option selected.

Note: We now have a "Fix SQL User" button (essentially executes step #2-4 below), SQL Server data source only

So how does it work now that there is no "create user option"? It's always implied with checking.

1 - create the RDM user
2 - does login exists? no, create it either integrated or not depending on the option selected
3 - does user exist in the database? no - create it
4 - is the user mapped? no - link user and login
5 - grant access rights depending in Admin/Non-Admin

The bug in 11.0.12.0, that was fixed in this build, was the fact the steps #2-4 were never executed. All should be good now.

Best regards,

Stéfane Lavergne

avatar

OK but when I create a user and he starts RDM he gets this error.

login.JPG

avatar

I'm investigating...

Stéfane Lavergne

avatar

What does your data source look like?

I'm assuming that the user D100\chriss was configured with "integrated security"checked. Are you specifying the username/password in the data source? For integrated security users this is not permitted, you must select "integrated security" and create a security context for the given user. See link below, this is a SQL Server limitation, there is no easier way around it.

http://help.remotedesktopmanager.com/index.html?tipsandtricks_runas_rdm.htm


Stéfane Lavergne

12-10-2015 8-33-23 AM.png

avatar

See the screenshot for the data source

Data_source.PNG

avatar

That looks perfect. If you click Test Server and Test Database what do you success one or the other or both?

Stéfane Lavergne

avatar

if you try with SQL Server Management Studio (SSMS) what do you get?

Stéfane Lavergne

12-10-2015 8-47-18 AM.png

avatar

When we test the database or the server we gets these errors

test_server.JPG

test_database.JPG

avatar

Could you please try the "Fix SQL Login" button

Stéfane Lavergne

12-10-2015 9-03-32 AM.png

avatar

User gets the same error after trying Fix SQL Login

avatar

Are you available for a support session? I could get the support team to schedule a support call to help you move forward on this issue.

Just a double check, you are running v11.0.14.0 correct?

Best regards,

Stéfane Lavergne

avatar

We find it out what the problems was the user that I've added was deleted from the AD and a couple of weeks they added it again to the AD the sql database kept the ssid and didn't update it to the new one.