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

  • 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.

    Saturday, March 14, 2020 9:31 PM

All replies

  • User-1080297099 posted

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

    Saturday, March 14, 2020 9:40 PM