Forgot SA password, would like to get in using Windows Authentication RRS feed

  • Question

  • Someone installed SQL Server but forgot the SA password. I have no idea what other sysadmin logins might have been setup. I am hoping that mixed mode was chosen for the logins so that we can also use Window logins. How can I check that it is running on mixed mode, rather than just SQL Server login mode?

    Let's assume that it is running on mixed mode so that Windows logins are accepted. I added my Window login to the Administrator group and tried logging into SQL Server but that didn't work. The error was simply "Login failed for user <Domain\Login>. Would this be because SQL Server is accepting only SQL Server Authentication or because my Windows login is not in the right group?

    Tuesday, March 6, 2012 11:10 PM


All replies