It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×58
×37
×18
×2
×1
×1

question asked: Aug 12 '14, 11:47 p.m.
question was seen: 4,822 times
last updated: Mar 23 '15, 6:44 a.m.

Related questions

SQL Server Forgot SA Password, How to Reset It ?

0
Andrew Dunaway (11●1●1) | asked Aug 12 '14, 11:47 p.m.
edited Aug 12 '14, 11:50 p.m.
Hello all! How can I reset SA password for SQL Server 2008?

I just logined to my SQL Server 2008 with SQL Server Authentication but was stuck at the message saying "Login failed for user 'sa'. (Microsoft SQL Server, error:18456)". I had 3 failed login attempts. I think I have forgotten my SA password. Worse, Windows Authentication mode is also unavailable for unknown causes. Now how can I reset my SA password? I am a SQL Server novice and know little about SQL commands. Please help! Thanks in advance!

One answer

Most liked answers ↑|Newest answers|Oldest answers

1
permanent link
Ralph Schoon (63.5k●3●36●46) | answered Aug 13 '14, 3:18 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
This is kind of not a real Jazz question, as this is more related to a vendor specific infrastructure product. I would suggest to search the internet for that one. Here some other results googled from this forum, with a solution that helped me:
https://jazz.net/forum/questions/100828/sql-server-password-recovery

Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.