Post reply

SQL Server Windows Authentication Password reset - where ??

  • July 23, 2009 at 3:34 pm

    #156011

    I recently changed my server administrator password and now i am locked out of SSMS.

    Where do i need to go to reset the Windows Authentication password in SQL Server ?

    Thanks

  • July 23, 2009 at 3:57 pm

    #1029335

    Hello Ifila,

    To reset the SQL Server administrator password, you can login using a windows account belonging to the local administrators group on the windows machine where SQL server is installed. Login using Trusted authentication. This should allow you to reset the server administrator account.

    Hope that answers your question.

    Thanks

  • July 23, 2009 at 6:14 pm

    #1029391

    http://msdn.microsoft.com/en-us/library/ms365941.aspx

    Ok i tried the above link and now get an Access Denied error - 0x80070005

    The MS error msg refers to Windows server 2003 but i am on 2008 and this is NOT a batch job ?

  • July 23, 2009 at 9:15 pm

    #1029436

    The Windows passwords are reset in Windows. Admin tools on the server or domain

  • July 24, 2009 at 5:29 am

    #1029567

    I reset the domain\administrator password within active directory.

    The weird part is that if i create a new domain\generic userid with administrator access, it works fine.

    Thanks

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply