User must change password at next logon doesn't appear to work when using Azure SQL Server
User must change password at next logon doesn't appear to work when using Azure SQL Server
Hi,
We are using Azure SQL Server as the database for our data source and whenever we create a new user and select the user must change password at next logon it doesn't appear to work.
What happens is the user logs on and the form pops up for them to change the password but when they try to do so they get the following error
The server principal "username" is not able to access the database "master" under the current security context.
Cannot open database "master" requested by the login. The login failed.
Login failed for user "username"
We have also noticed that the same error message is shown when the user tries to change their password via the 'Change Current User Password' option on the administration tab.
Cheers,
All Comments (3)
Hello,
Have you created a database user or you have created your user using integrated security?
What version of RDM are you using?
Best regards,
Jeff Dagenais
We are using version 12.5.2.0 of RDM.
We created our database as below
[1] We created a blank database in Azure.
[2] Created a new data source in RDM using the DB admin username and password.
[3] Clicked the upgrade tab and clicked update database, which created all the tables in our blank database.
[4] Then went into RDM users and created a new user and ticked the create SQL server login and user, plus user must change password at next logon.
Thank you for reporting the issue, it has been resolved and will be available in the next release.
Best regards,
Stéfane Lavergne