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 |
|
csphard
Posting Yak Master
113 Posts |
 Posted - 2004-05-18 : 12:25:31
|
| Can you change the sa password. I have been asked to do this. I'm not sure that i want to because we have applications that in the beginning were using it. I have since added a user/password and changed all the apps to use it. But i may have missed one. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-18 : 13:23:12
|
| You can change it with sp_password or inside Enterprise Manager by navigating to it and double clicking on it. Hopefully, none of your applications are using sa as this is very bad. Change the password and if any are still using it, you'll know pretty quickly. I would recommend changing it even if apps are still using it that way you can go correct the problem. Hopefully none of your apps are using sysadmin accounts or db_owner accounts either.Tara |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-05-18 : 18:40:11
|
| Run Profiler and look for failed logins when you change the password. Include the Host Name, Application Name, and ClientProcessID. This will allow you to quickly identify what host, application and PID the application is using with sa if you have any left. It's good to run this Profiler anyway just as a security audit.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
can you change the sa password