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 |
|
Blastrix
Posting Yak Master
208 Posts |
 Posted - 2002-04-01 : 18:07:19
|
| Some fool installed SQL Server with no sa password on our webserver. I went to put in a password, but found out that you can't do that through the security directory. How do you change/give the sa a password other than at install?Thanks |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-04-01 : 18:46:13
|
| Are you talking about the logins node under "Security" in EM ? I don't see a problem, I can see it fine here.Damian |
 |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-04-01 : 23:41:35
|
| Or if you are just looking for a way to change your password. you can use sp_password (this will work thru Query Analyzer though). Check BOL for more information .HTH-------------------------------------------------------------- |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-04-02 : 00:47:56
|
| Why can you not do it there? What message is it giving you?-Chad |
|
|
|
Blastrix
Posting Yak Master
208 Posts |
Posted - 2002-04-02 : 09:59:33
|
| When I right click on the sa login in the Logins node, there is no properties menu option, and when I double click on it nothing happens as with other logins. |
|
|
|
yakoo
Constraint Violating Yak Guru
312 Posts |
Posted - 2002-04-02 : 10:37:53
|
| Make sure you are logged on to SQL as a System Administrator [connect to the box with the user sa and blank password]. You then should be able to choose 'Properties' from the drop-down menu when right-clicking on the user sa. Once you do that you should be able to change the sa password as you would any other users password.Edited by - yakoo on 04/02/2002 10:39:20 |
|
|
|
|
|
|
Help! No sa Password!