I have an account that is setup for
Windows authentication. The account is used by SSRS for running reports and has various permissions in multiple databases. I need to convert this account to use
SQL Server authentication.
I don't see a way to change it in SSMS. Is there a way to "flip a switch" and make it use
SQL Server authentication?
For details as to why I want do this, see this question.