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 |
|
fturati
Starting Member
2 Posts |
 Posted - 2004-12-09 : 11:31:18
|
| hi all,i'm not sure why each time i open login properties for sql users (sql authentication) even to have a look at permissions and i press ok, enterpise manager asks me to confirm password, and if i write down the good known password, it refuses it; so i must type in the password in 'general' tab, then retype it at the confirmation password popup and everything goes fine since the next time i have to see someting about users.system is:Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4) Italian localized versions.any ideas?thanks in advance Paolo |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-12-09 : 16:15:43
|
| Install service pack 3a on the machine where you are having a problem, then install security patch 818. These can and should be installed on all machines that have the SQL Client tools installed.Tara |
 |
|
|
fturati
Starting Member
2 Posts |
Posted - 2004-12-10 : 01:53:56
|
| hi tara, thank you for your reply.as you can see machine is already sp3a + 818 (Microsoft SQL Server 2000 - 8.00.818)Do you think I have to re-apply them?Thank you again.Paolo |
|
|
|
rdaunce
Starting Member
7 Posts |
Posted - 2004-12-10 : 13:58:49
|
| I have had a problem on one of our SQL servers where the SA account was showing this behavior. I was able to fix it with this: [url]http://support.microsoft.com/?kbid=218172[/url]During the troubleshooting of this problem I also came across this, however it did not apply to my situation. Maybe it will help you:[url]http://support.microsoft.com/?kbid=826161[/url]--Bob |
|
|
|
|
|
|
login password