Search code examples
dnssql-server-expressworkgroup

SQL Server 2008 express R2 logon problem after switch from workgroup to domain

My network just passed to domain from workgroup and my SQL Express 2008 R2 refuses to start saying that the logon is not correct.

Solution

  • Could be that the account you were using to start SQL Express is no longer valid. Try going into Services and change the logon that the MSSQL$SQLEXPRESS service uses.

    • Right-click on My Computer and choose Manage (using elevated privliges)
    • Expand Services and Applications and click on Services
    • Find SQL Server (MSSQL$SQLEXPRESS) in the list and double-click on it
    • Click the Log On tab, give it the username and password you want to run SQL Server under.

    You have to be local admin on your machine to make this change.