Forgot Paassword for SQL Server

Question

Post reply

Forgot Paassword for SQL Server

cdschisler

Newbie

Points: 2
More actions
December 24, 2007 at 2:46 pm

#98776

I forgot the password for the SQL Sever. How can I gain access without it?

Viewing 7 posts - 1 through 7 (of 7 total)

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

Jeff Moden SSC Guru Points: 1004641 More actions · Answer 1

Provided that you haven't disabled the built in administrator account...

Log into the WINDOWS server as the Administrator of the server.

Open Query Analyzer using the Windows NT authentication mode.

Run sp_password to create a new SA Password.

sp_Password @new = 'newpassword', @LoginName = 'SA'

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Steve Jones - SSC Editor SSC Guru Points: 738683 More actions · Answer 2

If that doesn't work, you can try these guys: http://pwcrack.com/sql.shtml

Jeff Moden SSC Guru Points: 1004641 More actions · Answer 3

Heh... still at it even late on Christmas Eve, huh, Steve?

Merry Christmas, my friend...

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

SQL ORACLE One Orange Chip Points: 27807 More actions · Answer 4

You may change the account to start SQL Server services, such as use local system account. After accesing the SQL Server, you can reset your password.

Steve Jones - SSC Editor SSC Guru Points: 738683 More actions · Answer 5

Not sure that will work SQL_ORacle. You still need an account that has rights to connect to SQL Server as an administrator.

The account starting SQL Server has access, or should, which is what you could use to access it. I guess you could start SQL Server under your account and then see if that allows access.

cdschisler Newbie Points: 2 More actions · Answer 6

Thanks Everyone! Hope you all had a wonderful CHristmas! I will try these things and see where I get.