Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
swatib
Posting Yak Master
173 Posts |
 Posted - 2006-09-21 : 00:20:10
|
I forgot the password of a user created for a database. How could I get it again?ThanksNjoy Life  |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-09-21 : 00:22:48
|
you can't but you can reset it using sa
KH |
 |
|
|
swatib
Posting Yak Master
173 Posts |
Posted - 2006-09-21 : 00:24:38
|
| HOw?Njoy Life |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-09-21 : 00:27:45
|
run EM, login as sa and go to security and reset the password for the user
KH |
|
|
|
Cooldmitriy
Starting Member
5 Posts |
Posted - 2006-10-11 : 13:38:44
|
| What is a password for "SA" account? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-10-11 : 14:34:00
|
| "What is a password for "SA" account?"Hahahahahaha! The one you carefully wrote down and locked in the safe for the very rare occasion when you would ever have to use the SA account to get yourself out of a big hole!Kristen |
|
|
|
dewacorp.alliances
452 Posts |
Posted - 2006-10-11 : 20:15:06
|
| By default sa account when you installed is blank unless you change. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-10-11 : 22:28:46
|
| you need SA privilege to do this not necessarily the sa accountare you the DBA for the server? if no, ask your DBA to reset it for you HTH--------------------keeping it simple... |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-10-11 : 23:12:50
|
| You can change it with the sp_password stored procedure.Of course, you'll have to login first...CODO ERGO SUM |
|
|
|
|
|
|
Forgot DB user password