How to change the installation windows account for SQL Server Express from old corrupt windows user to new one.

Question

User-1080297099 posted

I installed SQL Server Express 2017 back in 2017 with my Microsoft user account/login to my Windows 10 computer.

The profile became corrupt somehow and I can no longer log into windows with that profile.
I'm having to create a new profile and transfer everything over.

How can I make the new profile an administrator and give access to everything in SQL Server Express 2017 as the original windows user I used to install SQL Server Express.

Answer 1

User-1080297099 posted

I figured out.
Log in to SQL Server as SA and make the new windows user and administrator.