How to fix the Error 18456(Login problem)

Question

How to fix the Error 18456(Login problem)

dm_tapas

Hall of Fame

Points: 3515
More actions
June 29, 2011 at 3:40 am

#240691

Error :
Login failed for user 'xyz' .(Microsoft SQL Server , Error: 18456)
I forgot The sa password , and also windows login is not working. How to overcome the issue.
Please suggest.

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

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

Lowell SSC Guru Points: 323518 More actions · Answer 1

if you have physical access to the server(laptop?), the first thing to do is right click SSMS...run as...administrator and see if that gets you in.

after that, you might need to try to use the DAC (dedicated administrative connection?administration? admin?) if it has been set up, otherwise I think you'll have to stop the server and start it from SQLcmd and add yourself as an administrator

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

dm_tapas Hall of Fame Points: 3515 More actions · Answer 2

OKAY, But how.... Can you please describe briefly? I will be thankful to you.

Lowell SSC Guru Points: 323518 More actions · Answer 3

dm_tapas (6/29/2011)
OKAY, But how.... Can you please describe briefly? I will be thankful to you.

What did you try?

did you try right clicking on SQL S3erver Managment Studio, selecting "run As Administrator?" did that work?

did you click the link i posted on using SQLCMD? here it is again:

http://blogs.ameriteach.com/chris-randall/2009/12/11/sql-server-2008-forgot-to-add-an-administrator-account.html

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!