zomby

October has come and I don't see this in the latest releasenotes. Any news?

Fingers crossed

I have to agree, still waiting for the solution, checking on every update.

Hi Jonathan,

Seems to work, thank you.

Now only the Jump support is missing.

Zomby

Hi Jonathan,

This seems to solve the issue, but it's not a generic solution.

I have 2 issues:

1. I am store the username and password in Keepass. The username is entered in UPN format, and the NETBIOS domain was filled in. If I just changed the Username format to "{User}@{Domain}", it tried to login with firstname.lastname@NETBIOSDOMAIN.

I had to remove the "DOMAIN" setting from keepass to make it work.

2. This account is used in other places, it would be better if it can work with the default setting, if the username is in UPN format {USERNAME}@{DOMAIN}.{TLD) auto switch to UPN. (maybe doesn't work for others...)

It can be detected by after @ , there is a FQDN not just a NetBIOS domain name without dot.

Please note that the NETBIOS login is different in my case.

Example

NETBIOS DOMAIN NAME: DOMAIN

SamAccountName: username

UserPrincipalName: firstname.lastname@differentdomain.tld

I am trying to use firstname.lastname@differentdomain.tld to log in, when it's not working.

DOMAIN\username works.

As far as I see if I enter firstname.lastname@differentdomain.tld (UPN) to log in, FreeRDP tries to use:

DIFFERENTDOMAIN.TLD\firstname.lastname which doesn't work.

HI zomby,

What OS are you launching your connections from?

We have found some issues with RDP8 (which FreeRDP uses) and Server 2012 R2 (and possibly Windows 8.1).

I am tried it from Windows 10 x64 Enterprise 1703

Yes, I think it's Kerberos using CredSSP. No client certificate is used.

Didn't checked, but I think, the authentication method is the same. The only difference is that instead using NETBIOSDOMAIN\samAccountName, I am using UserPrincipalName ( user@domain.tld ) to log in.

NetBIOS domain and UPN domain can be diffrerent. As far as I see the client just converts user@domain.tld to DOMAIN.TLD\user which is not the same. That is still NetBIOS login, which may or may not work.

Oh sorry. I forgot to answer.

No, it's not related to Hyper-V, I didn't tried it.

I am logging in to a normal RDP server using NLA, but the username is the UPN. (username@domain.net format ) It is the UserPrincipalName property in AD.

The UPN is different from the samAccountName.

This was the first two sessions I had tried freeRDP (UPN issue is the other). Neither worked :S. I use the Hyper-V session as a jump host.

The reason: Customer doesn't allow local connections in VPN and we need enhanced session to make jump work.

Unable connect to Hyper-V enhanced session. The error message is:

Unable to connect to host <hostname>

Where <hostname> is the host name I am try to connect to.

After switching to FreeRDP, the rdp session can't logon with UserPrincipalname

As far as I see it converts user@domain.com to DOMAIN.COM\user but that's not a real UPN login. The user part can be different, just for example.

Just tested it, as far as I see it doesn't seems to support Modern Authentication (ADAL) yet. We have Azure AD MFA setup...

The error message:

Unable to connect to the database!

Failed to authenticate the user NT Authority\Anonymous Logon in Active Directory (Authentication=ActiveDirectoryIntegrated).

Error code 0xCAA2000C; state 10

AADSTS50076: Due to a configuration change made by your administrator, or because you moved to a new location, you must use multi-factor authentication to access 'https://xyz.abc.com/'.

Trace ID: 615cbd65-3659-4faa-ac69-1a34431c1cfa

Correlation ID: a03aac05-567d-493a-935e-ebc1a5b9843a

Timestamp: 2017-02-15 21:47:42Z

Hi Stefane,

Thanks for making it! I am more than happy to test it.

Zoltan

Hi David,

Any news on this? For us it would be an important feature to use AzureAD accounts on AzureSQL

+1 on this, Active Directory integrated authentication would be a great security improvement with Azure SQL

Any news?

Yes, the error message is:

"Unable to connect to the server!

Server closed the connection."

The connection works well with the same data (Server, username, password, database) using the desktop version of RDM.

I had sent the logs using Settings/logs/Sent Trace to Support.

I get a following error message trying to connect our Azure SQL database:

Unable to connect to the database!

Server closed the connection.

Do a jump session counts as a RDP session on the Jump host? I assume yes, so the 2 concurrent RDP limit applies, if you don't have the RDP session host installed.

I found a bug with SSH shell, since about 8.9.5.x (I am not sure), the SSH Shell freezes the whole program if the application doesn't have focus for a time.

It simply the whole RDM is not responding at all and I have to kill it. It happens very often, but only if an SSH shell is used or active.

I didn't found the exact way to reproduce it now, sometimes a simple switch to an another program and switch back causes the issue. Last time I left open the SSH Shell running and locked the desktop and the RDM was frozen.

LoadConnections [AzureSQL]...

Offline Mode : ReadOnly

Caching Type : IntelligentCaching

Current cache version: 0x0000000000000000

OfflineManager.GetDataSourceSettings : 872 ms

OfflineManager.LoadConnections...

LoadConnectionsFromOfflineFile : 448 ms

Preloaded: 285

Offline cache version: 0x0000000000000133

OfflineManager.LoadConnections : 542 ms

LoadConnectionsFromDataSource...

LoadDataSourceSettingsFromDataSource...

GetDataSourceSettings : 414 ms

LoadDataSourceSettingsFromDataSource : 1787 ms

OfflineManager.Save : 341 ms

---------------------------

OfflineManager.OfflineMode : ReadOnly

ConnectionManager.DataSource.OfflineMode : ReadOnly

ConnectionManager.DataSourceSettings.OfflineMode : ReadOnly

SecurityManager.CustomSecurity.OfflineMode : ReadOnly

ConnectionManager.DataSource.SupportOfflineMode : True

---------------------------

GetConnections...

Database.GetConnections...

Reading connections from database : 0 ms

Decrypt (multi-threaded) : 0 ms

Deserialize (multi-threaded) : 1 ms

Process entries (overhead) : 8 ms

Connection cache version: 0x0000000000000133

Fetched 0 sessions

Fetched 0 removed sessions

Database.GetConnections : 91 ms

GetConnections : 115 ms

PrepareConnectionList : 0 ms

DoMergeConnections : 10 ms

LoadConnectionsFromDataSource : 2515 ms

LoadConnections [AzureSQL] : 4282 ms

TreeView.LoadConnectionList...

GetGroupInfos : 0 ms

BeginUpdate...

ApplyGroupCustomImages : 0 ms

LoadConnectionInTreeNode : 109 ms

PreCreateGroups : 33 ms

BeginUpdate : 54 ms

TreeView.LoadConnectionList : 215 ms

LoadTrayiconContextMenu : 7 ms

My RDM is also starts slower than before:

LoadConnections [AzureSQL]...

Offline Mode : ReadOnly

Caching Type : IntelligentCaching

Current cache version: 0x0000000000000000

OfflineManager.GetDataSourceSettings : 617 ms

OfflineManager.LoadConnections...

LoadConnectionsFromOfflineFile : 527 ms

Preloaded: 285

Offline cache version: 0x0000000000000133

OfflineManager.LoadConnections : 619 ms

LoadConnectionsFromDataSource...

LoadDataSourceSettingsFromDataSource...

GetDataSourceSettings : 1616 ms

LoadDataSourceSettingsFromDataSource : 2738 ms

OfflineManager.Save : 322 ms

---------------------------

OfflineManager.OfflineMode : ReadOnly

ConnectionManager.DataSource.OfflineMode : ReadOnly

ConnectionManager.DataSourceSettings.OfflineMode : ReadOnly

SecurityManager.CustomSecurity.OfflineMode : ReadOnly

ConnectionManager.DataSource.SupportOfflineMode : True

---------------------------

GetConnections...

Database.GetConnections...

Reading connections from database : 0 ms

Decrypt (multi-threaded) : 0 ms

Deserialize (multi-threaded) : 0 ms

Process entries (overhead) : 5 ms

Connection cache version: 0x0000000000000133

Fetched 0 sessions

Fetched 0 removed sessions

Database.GetConnections : 196 ms

GetConnections : 210 ms

PrepareConnectionList : 0 ms

DoMergeConnections : 7 ms

LoadConnectionsFromDataSource : 3980 ms

LoadConnections [AzureSQL] : 5426 ms

TreeView.LoadConnectionList...

GetGroupInfos : 0 ms

BeginUpdate...

ApplyGroupCustomImages : 0 ms

LoadConnectionInTreeNode : 94 ms

PreCreateGroups : 31 ms

BeginUpdate : 40 ms

TreeView.LoadConnectionList : 178 ms

LoadTrayiconContextMenu : 8 ms

Hi,

I do have a request for the SSH Shell part. Usually I use the shell to manage routers and sometimes I need to copy text to the clipboard using the mouse. If the text is longer than a page, scrolling is required. Currently the scrolling speed is very slow, it takes a lot of time to scroll.

Is it possible to make the scrolling like Putty? I has 2 scrolling speed determined by how much you move the mouse up.

What I would recommend is to use latest beta and uncheck the "remember and automatically open last used database on startup" option in Keepass.

My second recommendation is to enable "Enter master key on secure desktop" in Options/Security in Keepass. This way you can be sure that keepass will get the focus during the password entering.

edited by zomby on 4/18/2013

André has fixed the issue with keepass in V8.2.4.0(beta)

With "remember and automatically open last used database on startup" DISABLED, it works perfectly now.

Thank you André for the very fast response!