| Author |
Topic |
|
dewacorp.alliances
452 Posts |
 Posted - 2007-08-22 : 20:32:22
|
| Hi allI found this interesting issue. This guy used to have access to one of the SQL server 2000 database. But now they even can't login to the server using query analyzer. In the SQL Logs said that "Login failed for user 'XXX\USER1'." Test with other users accessing that server and it the same thing. Any ideas?Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-08-22 : 20:58:04
|
| Well did you check if that login still exists on the SQL Server either as a user or in a group?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
dewacorp.alliances
452 Posts |
Posted - 2007-08-22 : 21:26:21
|
| That the first thing that I did. Check whether that account exist or not.The funny thing is actually if I assign that account into database works ok but not through a Windows group ?!?!This group is never change.Thanks |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-22 : 22:15:34
|
| Is the account a member of that group? If just added to the group, user may need relogin windows to get proper permission. |
|
|
|
dewacorp.alliances
452 Posts |
Posted - 2007-08-22 : 23:31:32
|
| The account is a member of the NT Group. It's used to be working before but for unknown reason it's just stop accessing the database using that group. But if I assign a new user to that group ... that user can access no problem ?!?! |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-22 : 23:52:42
|
| What's sql2k sp level? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-08-23 : 11:25:16
|
| It sounds like the user is not a part of the group anymore. Go to Active Directory to verify this.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
dewacorp.alliances
452 Posts |
Posted - 2007-08-24 : 04:21:16
|
quote:
Originally posted by rmiao
What's sql2k sp level?
SP3a |
|
|
|
dewacorp.alliances
452 Posts |
Posted - 2007-08-24 : 04:22:45
|
quote:
It sounds like the user is not a part of the group anymore. Go to Active Directory to verify this.
I did verify those account and they are all exist on that group ?!?! |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-24 : 23:58:18
|
| Apply sp4 if possible. |
|
|
|
mverma82
Starting Member
5 Posts |
Posted - 2007-08-27 : 11:09:37
|
| Did someone restore the database ?Manish |
|
|
|
|
Windows Authentication Issue