SQL-Server Authentication Error

Question

My SQLSERVEAGENT won't start despite trying all the possible solutions StackOverflow could offer. Then I tried: https://stackoverflow.com/a/21154886/5582033

Now, I can't even connect to my SSMS since it gives authentication error now. Any idea how I can access MSSQLSERVER again and my databases.

PS: I am using my local administrator account.

EDIT: I can't seem to rollback changes since 'restore to previous version' isn't working.

Error Message: TITLE: Connect to Server

Cannot connect to MY-PC\SQLEXPRESS.

ADDITIONAL INFORMATION:

Login failed for user 'XYZ\a.1289421'. (Microsoft SQL Server, Error: 18456)

Can you connect with any other accounts? As @BilalAyub points out, SQL Server expression does not include the SQL Agent. — David Rushton, Mar 01 '17 at 11:05

score 0 · Answer 1 · answered Mar 01 '17 at 10:25

0

You can try to rollback your changes followed by restarting agent and share the exact error message.

answered Mar 01 '17 at 10:25

Bilal Ayub

Looks like you are using SQL Express edition that doesn't support SQL Agent service. – Bilal Ayub Mar 01 '17 at 10:30
Okay, and how to connect to the server? – someone Mar 01 '17 at 10:38
If you are getting login failure error while starting your sql service than use valid login or localsystem as startup account – Bilal Ayub Mar 01 '17 at 11:25

1 Answers1