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 |
|
jodyreenan
Starting Member
3 Posts |
 Posted - 2004-08-05 : 10:15:00
|
| I have a customer with an SQL Server 2000 database using Mixed Mode authentication and a password on the sa account. The users can access the database from a VB6 application without a problem for a few days. However, every few days they receive a "login failed for user sa" error. I reset the password on the sa account and they can access the db through the app again. But then a couple days later the same problem occurs.Any idea why the sa password would keep resetting itself. I have many other customers with the exact same setup that don't have this problem. |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-05 : 11:50:18
|
| You need to setup Profiler and trace permission changes to find out what's changing it.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-05 : 14:14:12
|
| Why is your application using sa? !!!That is so messed up. I'm so sick of developers doing this, although usually it's with COTS only. How as a DBA am I supposed to control security if an application needs to use it?Someone is obviously changing the password without telling anyone what the new password is. SQL Profiler will show it.Tara |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-08-05 : 14:19:04
|
quote:
Originally posted by tduggan
Why is your application using sa? !!!That is so messed up. I'm so sick of developers doing this, although usually it's with COTS only. How as a DBA am I supposed to control security if an application needs to use it?Someone is obviously changing the password without telling anyone what the new password is. SQL Profiler will show it.Tara
Chiiiiiiiiiiiiiiiillllllllllllllllllit's their 1st post.....But Tara is right..it's very dangerous....But I'm curious...if they changed it, how are you able to connect?Do you have another sa level account that you use?If not, how did you reste it?Is this a trick question?Is this part of the interview?Brett8-) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-05 : 14:27:20
|
| I'll never chill about applications using sa. Lazy developers not wanting to learn how to do security in SQL Server. Do they just give out local admin to all of their servers too so that all uses can do whatever they want? At my last job (government), we had a ton of COTS packages. Probably half of them used sa. Every time we wanted to change the sa password, we'd have to change the connection strings for those apps to use the new password. Some sa passwords we couldn't change, as sa was hard coded into the app.Tara |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-08-05 : 15:51:34
|
| I still want to know about the password reset....Brett8-) |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-05 : 16:49:37
|
| Well, one thing we do know. It does not reset itself.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-08-05 : 21:42:49
|
Is this the entire error message? You might have a different issue aside from the resetting of password. There might be some not-so-obvious reason.quote:
Originally posted by jodyreenan
I have a customer with an SQL Server 2000 database using Mixed Mode authentication and a password on the sa account. The users can access the database from a VB6 application without a problem for a few days. However, every few days they receive a "login failed for user sa" error. I reset the password on the sa account and they can access the db through the app again. But then a couple days later the same problem occurs.Any idea why the sa password would keep resetting itself. I have many other customers with the exact same setup that don't have this problem.
|
|
|
|
|
|
|
|
|
sa password resets