0

we recently promoted a Windows 2008R2 server to domain controller. We then found that it hosted a SQL Server 2008R2 Express database instance. If we try to login to the DB with the domain admin credentials we get a login error 916. We are also unable to enable the 'sa' user due to error 15151.

Any help will be greatly appreciated. Alex.

asked Dec 5, 2015 at 10:12

1 Answer 1

0

Found it! I was able to create a privileged user while putting the DB in single-user mode. Here is the link: http://v-consult.be/2011/05/26/recover-sa-password-microsoft-sql-server-2008-r2/

answered Dec 5, 2015 at 10:19
1

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.