As long as you know the hash value of the password.
I suggest you use the hash for password "123", without the quotes. This is the default password for the Administrator account.
All accounts are created in the table "User".
First run an SQL to extract all usernames:
SELECT [NAME] FROM [USER]
Then you can change the password for the user you want by running this SQL (example here is to change the Administrator password):
UPDATE [USER] SET PASSWORD='zYwpuN7tMj/hU4z720b8Ki6mHP1ngH8GKXCOoqbhOikZ3vPIN8Tn8sjgBnVo4yNoJ977Bck0bkdrbpVEQKkIpw==' WHERE NAME='Administrator'
There are two easy methods which you can use to run SQL statements against Microsoft's SQL Server.
1. Using the command line program (osql)
2. Using the SQL Server Management Studio (graphical UI)
To use osql, start a command prompt (start->run->cmd).
Type osql and hit Enter. If you see a return string like this "Error: No user selected. Try with -U or -E switches", it means you can run osql. If not, you will have to browse to the binary directory of Microsoft's SQL server and run it from there. On my system, the bin directory for MSSQL is C:\Program Files\Microsoft SQL Server\90\Tools\Binn.
Before you can execute any command against MSSQL, using osql, you need to know the server name, instance name, database name, and sa password. These info allow you to connect to the database against which you can then run SQL statements.
So, on my system, I do the following: osql -S localhost\sql1 -U sa -P paswd -d bp2x
Then I get the following prompt: 1>
Now I type my SQL command: UPDATE [USER] SET PASSWORD='zYwpuN7tMj/hU4z720b8Ki6mHP1ngH8GKXCOoqbhOikZ3vPIN8Tn8sjgBnVo4yNoJ977Bck0bkdrbpVEQKkIpw==' WHERE NAME='Administrator'
which shows on the screen as: 1> UPDATE [USER] SET PASSWORD='zYwpuN7tMj/hU4z720b8Ki6mHP1ngH8GKXCOoqbhOikZ3vPIN8Tn8sjgBnVo4yNoJ977Bck0bkdrbpVEQKkIpw==' WHERE NAME='Administrator'
2>
Now on line "2>" I type the command GO: 2> GO
When you hit Enter after the command GO, it should execute.
Now to run SQL with the MSSQL Management Studio, you have to download and install the application off microsoft's website. They have an Express version which is free.
Resetting username and password
Yes you can.
As long as you know the hash value of the password.
I suggest you use the hash for password "123", without the quotes. This is the default password for the Administrator account.
All accounts are created in the table "User".
First run an SQL to extract all usernames:
SELECT [NAME] FROM [USER]
Then you can change the password for the user you want by running this SQL (example here is to change the Administrator password):
UPDATE [USER] SET PASSWORD='zYwpuN7tMj/hU4z720b8Ki6mHP1ngH8GKXCOoqbhOikZ3vPIN8Tn8sjgBnVo4yNoJ977Bck0bkdrbpVEQKkIpw==' WHERE NAME='Administrator'
This defaults the password to 123.
Cheers,
Emile
Can you tell me how to run a
Can you tell me how to run a SQL? I don't know anything about SQL. Thanks.
How to run SQL statements against MS SQL server
No worries.
There are two easy methods which you can use to run SQL statements against Microsoft's SQL Server.
1. Using the command line program (osql)
2. Using the SQL Server Management Studio (graphical UI)
To use osql, start a command prompt (start->run->cmd).
Type osql and hit Enter. If you see a return string like this "Error: No user selected. Try with -U or -E switches", it means you can run osql. If not, you will have to browse to the binary directory of Microsoft's SQL server and run it from there. On my system, the bin directory for MSSQL is C:\Program Files\Microsoft SQL Server\90\Tools\Binn.
Before you can execute any command against MSSQL, using osql, you need to know the server name, instance name, database name, and sa password. These info allow you to connect to the database against which you can then run SQL statements.
So, on my system, I do the following:
osql -S localhost\sql1 -U sa -P paswd -d bp2x
Then I get the following prompt:
1>
Now I type my SQL command:
UPDATE [USER] SET PASSWORD='zYwpuN7tMj/hU4z720b8Ki6mHP1ngH8GKXCOoqbhOikZ3vPIN8Tn8sjgBnVo4yNoJ977Bck0bkdrbpVEQKkIpw==' WHERE NAME='Administrator'
which shows on the screen as:
1> UPDATE [USER] SET PASSWORD='zYwpuN7tMj/hU4z720b8Ki6mHP1ngH8GKXCOoqbhOikZ3vPIN8Tn8sjgBnVo4yNoJ977Bck0bkdrbpVEQKkIpw==' WHERE NAME='Administrator'
2>
Now on line "2>" I type the command GO:
2> GO
When you hit Enter after the command GO, it should execute.
Now to run SQL with the MSSQL Management Studio, you have to download and install the application off microsoft's website. They have an Express version which is free.
Last I checked it was downloadable on this web page:
http://www.microsoft.com/express/sql/download/default.aspx
The URL for the download is:
http://go.microsoft.com/fwlink/?linkid=65110
Cheers,
Emile