Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strange behavior on SQL Server
Message
From
11/05/2006 11:56:56
Peter Wagner
Point Informática Ltda.
Limeira, Brazil
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Database:
MS SQL Server
Miscellaneous
Thread ID:
01120880
Message ID:
01121012
Views:
9
I will check it tomorrow and see what it could be.
Thanks.

>You should check the Win2K3 event log for a detailed explanation of the error. Once we had a problem like this and it had to do with a user account that was deleted from windows 2003 server.
>
>>The client has a SQL Server 2K in a Windows Server 2003.
>>Sometimes when the stations try to login to the database it returns a message that says it’s a invalid login name or invalid password, but the user are using the right login name and password.
>>Most part of the time it works fine (90-95% of the time).
>>
>>After a few days I went to the client and tried to open the Query Analizer (QA), I typed the login name and the password (I was on windows Server 2003 and they use Windows and SQL Server Security for authentication), and it returned to me the same error message.
>>I tried to open the QA from the SQL Enterprise Manager and it opens the QA, but if I try to open QA directly it returns the error message, of and invalid login name or password.
>>
>>That day I solved (??) the problem after a reboot in Windows Server, but for me it’s not a real solution, and I haven’t found any idea why it’s happening and what could be done, in fact that day the problem passed after the reboot.
>>Sometimes it’s enough just to stop and start the SQL Server, but sometimes it's necessary to reboot the Windows Server.
>>
>>This problem occurs in a random way and I haven’t found why.
>>
>>I would like to know why it’s happening and what could be done without hawing to stop/start SQL Server and/or reboot the windows server.
>>Any ideia ?
>>
>>Thanks in Advance.
>>
>>Peter
Previous
Reply
Map
View

Click here to load this message in the networking platform