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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-03 : 09:05:58
|
Peyton writes "Help!I recently changed my blank sa password to something new. However, an application we're running was written to use the sa account with a blank password (bad, I know.) I need a few days to figure out how to fix this, so in the meantime I wanted to change the sa password back to blank using the following command from the dos prompt:osql -U sa -Q "sp_password '<old password>','','sa'" HOWEVER, the password did not change to blank as I expected! I tried to log in with no password but couldn't. I tried the old password, two quotes: '', and a few other things, but can not log in! What's my new sa password?Thanks!-Peyton" |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-07-03 : 09:58:54
|
| If that is, in fact, how you typed in your command, then your password should be blank. I am guessing you might have put a single space for new password though.Do you have any other accounts with sysadmin priviledges? If you do, then use that account to change your password again... This time around use NULL instead of '' to remove your sa password:osql -U <sysadmin account> -Q "exec sp_password @new = NULL, @loginame = 'sa'"Edited by - izaltsman on 07/03/2002 09:59:51 |
 |
|
|
|
|
|
|
|
Changed password command gone wrong!