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
Hello,
This is a known issue and we will release a fix today.
David Hervieux
Hello,
We have released an update. Could you give it a try?
David Hervieux
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.
@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
OK but when I create a user and he starts RDM he gets this error.
login.JPG
I'm investigating...
Stéfane Lavergne
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
See the screenshot for the data source
Data_source.PNG
That looks perfect. If you click Test Server and Test Database what do you success one or the other or both?
Stéfane Lavergne
if you try with SQL Server Management Studio (SSMS) what do you get?
Stéfane Lavergne
12-10-2015 8-47-18 AM.png
When we test the database or the server we gets these errors
test_server.JPG
test_database.JPG
Could you please try the "Fix SQL Login" button
Stéfane Lavergne
12-10-2015 9-03-32 AM.png
User gets the same error after trying Fix SQL Login
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
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.