Reset Password SA MS SQL ***

[vasyater2]

If you have forgotten your password you can reset the MS SQL query.

GO ALTER LOGIN [sa] WITH DEFAULT_DATABASE=[master] GO USE [master] GO ALTER LOGIN [sa] WITH PASSWORD=N’NewPassword’ MUST_CHANGE GO 

[MentaL]

[Kasistar]

hard translated...:

"if you forgit your SQL password from user SA dont use this query cause u will lose it"

o.O

[vasyater2]

hard translated...:

"if you forgit your SQL password from user SA dont use this query cause u will lose it"

o.O

Sorry for the bad English it's all Google hits

[St34lth4ng3l]

sp_password NULL,'new_password','sa'
go

Shorter one

[inetpub]

yes but you have to run that command from server admin or user with permissions to edit it. If someone have only one account then its harder ^^

[St34lth4ng3l]

Than: format you harddrive, open the window, throw the pc out of the window and jump after....because normally no one forget's his passwords ...

[Kasistar]

point A...: there is a little thing... "remember user"....

point B...: there is something, called "textfile".... useable to write something into there.. maybe p0rno links, conversations and maybe, really only maybe, SQL logins also

point C...: if that wont help, go post #6

[DragonLord]

... because normally no one forget's his passwords ...

That is absolutely wrong.
I want to see you remember 32-64 byte long random non repetitive passwords.
e.g. _huSpethAtUfUcR+p!s$nef9=u_U@#trA+RUC&uda#$dRUKefEstU6a&W9ph-gU&

[St34lth4ng3l]

That is absolutely wrong.
I want to see you remember 32-64 byte long random non repetitive passwords.
e.g. _huSpethAtUfUcR+p!s$nef9=u_U@#trA+RUC&uda#$dRUKefEstU6a&W9ph-gU&

save it into a crypted file or check just the remember checkbox

[henrydesouza]

Hi vasyater2

Here are some possible solutions to your problem:-

1. Open the SQL Server express management studio
2.Connect to SQL Server using windows authentication
3.Right click the server name and choose properties
4.Go to security tab. Change server authentication to “SQL Server and Windows Authentication mode”
5.Click OK and restart SQL Server
6.Go to SQL Server studio management express
7.Expand the server and choose security and expand logins
8.Right click on SA, from properties modify the password and confirm password
OR

To reset the sa password, you can make the following:
1. Login to the SQL Server box as the Administrator.
2. Run SQL Server Enterprise Manager.
3. Right-click the server name and choose ‘Edit SQL Server Registration properties’.
4. Choose ‘Use Windows authentication’ and click OK button.
5. Expand a server, expand a Security and click Logins.
6. Double-click the sa login and specify new password on the General tab. (enable Login to)
Or You Can Use

USE [master]
GO
ALTER LOGIN [sa] WITH DEFAULT_DATABASE=[master],
DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=ON, CHECK_POLICY=ON
GO
USE [master]
GO
ALTER LOGIN [sa] WITH PASSWORD=N’<insert_new_password_here>’ MUST_CHANGE
GO
or

From a command prompt
OSQL -S <insert_servername_here> -E
1> EXEC sp_password NULL, ‘<insert_new_password_here>’, ‘sa’
2> GO

Further you can check these methods to gain access to you SQL Server Database

wikihow.com/Perform-MS-SQL-Server-Password-Recovery-of-SA-and-Other-SQL-Users-by-a-Software

Regards
henrydesouza

[Kasistar]

hard that you grab out an old threat... pls close it

[vasyater2]

Hi: 8: