none
windows account lost, anyway to enable mix mode authentication and login SQL server?

    Question

  • First, i think it  began with an Active Directory issue, but i don't find any queue for AD in this forum and this is also SQL server related so i post it here.

    i am currently stuck at an embarrassing situation i replied at:

    https://social.technet.microsoft.com/forums/windowsserver/en-US/fc830e06-c82f-4b62-aa81-a8ecc75684c8/password-changed-after-ad-dc-installation

    OK, i am not so familiar with AD operation, but when demoting AD, why it does not just revert to the local machine accounts saved before AD promotion? why does it just create a new local machine administrator account without much notices(maybe the wizard does noticed me somewhere, i don't remember clearly)? It does prompt me for a new local machine administrator password, i thought it just reset the old local machine administrator password, but it created a new account.

    Now, the sql server part: I see some one said i can just make some registry change to enable mix mode, and enable sa account. But its also said that sa password was set by the original sql server installation, so after enabling sa account by registry change, how do i know the sa password or can i just reset it.

    By the way, i had tried to set the sql server service account to the new local machine administrator account, but i still cannot login sql server with the new local machine administrator acount.


    update:anyway, i rebuilt master, which is almost the same as reinstall sql server 

    C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\SQLServer2012>Setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLSERVER /SQLSYSADMINACCOUNTS=guyu
    minglaptop\administrator /SAPWD= xxxxxxx

    • Edited by GuYuming Sunday, March 31, 2019 3:38 AM
    Sunday, March 31, 2019 1:00 AM

All replies