| Author |
Topic |
|
harshal_in
Aged Yak Warrior
633 Posts |
 Posted - 2003-03-31 : 00:50:17
|
| hello all,I am having this strange problem on a client machine using XP and sql 2k client installed on it.the server is win 2k advanced server with sql 2k.the users use their windows authentication for using sql server.since yesterday on one of the machine it says login failure for user xyz but the user is logged in to windows with some other login say wyz.the login xyz is present in the domain but it is not what the user is logged in to windows.does anyone have any ideas why this is happening.I have sp3 installed.Regards,Harshal.Expect the UnExpected |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2003-03-31 : 05:44:24
|
| Are you using MS Access ? I've seen some funny things when Access decides to remember the userid used to create links etc.Sorry I can't help more ...*#&#* *#&#* *#&#* *#&#* Chaos, Disorder and Panic ... my work is done here! |
 |
|
|
szakszi
Starting Member
9 Posts |
Posted - 2003-03-31 : 05:55:35
|
| Or it could be a "standard" client (EM, QA) with the "Run as" option and wrong password.Or a client software with a built-in loginname and pwd (xyz).Have you checked the log and the running processes on that client?regards,Szakszi |
|
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2003-03-31 : 06:57:40
|
quote:
Are you using MS Access ? I've seen some funny things when Access decides to remember the userid used to create links etc.Sorry I can't help more ...*#&#* *#&#* *#&#* *#&#* Chaos, Disorder and Panic ... my work is done here!
I am using sql server 2000 as i have mentioned above.it is enterprise edition .Expect the UnExpected |
|
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2003-03-31 : 06:59:23
|
quote:
Or it could be a "standard" client (EM, QA) with the "Run as" option and wrong password.Or a client software with a built-in loginname and pwd (xyz).Have you checked the log and the running processes on that client?regards,Szakszi
thanks for the help but,Which log are u talking about? please elaborate.Expect the UnExpected |
|
|
|
szakszi
Starting Member
9 Posts |
Posted - 2003-03-31 : 07:12:59
|
| Event log. Sys, Sec, App log.And the (effected) client application log. If it exists, of course.....Szakszi |
|
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2003-04-01 : 04:01:11
|
| Harshal,My question was actually, what are you using as CLIENT - is it MS Access - connecting to your SQL 2K EE server ?*#&#* *#&#* *#&#* *#&#* Chaos, Disorder and Panic ... my work is done here! |
|
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2003-04-01 : 05:44:08
|
quote:
Harshal,My question was actually, what are you using as CLIENT - is it MS Access - connecting to your SQL 2K EE server ?*#&#* *#&#* *#&#* *#&#* Chaos, Disorder and Panic ... my work is done here!
Nope .I am using query analyser as a client to connect the server.regards,Harshal.Expect the UnExpected |
|
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2003-04-01 : 06:15:54
|
| Ok that is a bit strange.Sounds like maybe an OS problem. Is this only on 1 client ? A mate of mine reckons that the userid is kept somewhere in the page file, so clearing down the page file by re-booting. If that doesn't work, and it is only 1 client, consider a re-format and install IF YOU CAN - this is not a great answer, because you'll never know what the problem was (if it fixes it).Lets just state what happens:User boots PCUser log's on to domain (authenticated) XYZUser opens QAUser connects to Correct Server, using Windows AuthenticationLogon fails for user WYZ Is that correct ?...*#&#* *#&#* *#&#* *#&#* Chaos, Disorder and Panic ... my work is done here! |
|
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2003-04-01 : 06:37:31
|
quote:
User boots PCUser log's on to domain (authenticated) XYZUser opens QAUser connects to Correct Server, using Windows AuthenticationLogon fails for user WYZ Is that correct ?...*#&#* *#&#* *#&#* *#&#* Chaos, Disorder and Panic ... my work is done here!
SOrry but it is not possible to format that pc at this stage.I have tried rebooting the pc couple of times but with out any success.Is there any other way to clear the pages explicitly?there is only one client facing this problem.regards,Harshal.Expect the UnExpected |
|
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2003-04-01 : 08:10:45
|
| Pity about the format ...OK - can you just reinstall OS ?The idea about "cleaning down the page file" is very much a SITD (Shot-In-The-Dark). may be of no use, so don't focus on it too much.If it is only 1 client, it really sounds like an installation / OS / setup problem. See if you can just reinstall OS.Have you test by logging on with a totally different user on the problem PC, and then using the "problem id" on another "healthy" PC ?Also, maybe try and have them sign on with the ID that is trying to connect to SQL - ....All of these are SITD - HTH ...*#&#* *#&#* *#&#* *#&#* Chaos, Disorder and Panic ... my work is done here! |
|
|
|
|
strange login failure problem