User cannot connect SQL datasource after AD rename

Correct, deleting the user in RDM will result in the loss of the personal settings and such.

FYI, we don't support since it's such a corner case but we should be able to do it manually. We have three components here (SQL login, SQL user & RDM user).

You've said:
I already checked the security settings in the SQL server and renamed the AD user there.

So I'm assuming you mean the SQL login, if not run the following:
use master;
GO

ALTER LOGIN [domain\oldname] WITH NAME = [domain\newname];
GO
Rename the SQL user
use database_name;
GO

ALTER USER [domain\oldname] WITH NAME = [domain\newname];
GO

-- make sure that the renamed user is mapped to the renamed login
-- not sure if this is needed but just to be safe, it might have been
-- done with the login rename (step #1)
ALTER USER [domain\newname] WITH LOGIN = [domain\newname];
GO
Rename the RDM user
use database_name;
GO

update [dbo].[UserSecurity]
set Name = 'domain\newname'
where Name = 'domain\oldname'
GO
Does that resolve the issue?

Thank you for your detailled explanation.

I've run all three scripts in SQL Manager.
The user can now open RDM without any errors, so the issue ist resolved.


Best regards

Marc

Marc,

Good to here, thank you for the response.

Best regards