1.

Solve : MS Sql server 2005 login failed problem?

Answer» <html><body><p>Hi to all,<br/><br/>In my server , ms msql server 2005 installed and everything fine before few days, but now I have some new problem.<br/>the problem is after 9.30pm(approx...) when login ms sql server <a href="https://interviewquestions.tuteehub.com/tag/using-1441597" style="font-weight:bold;" target="_blank" title="Click to know more about USING">USING</a> 'sa' , the result is login failed user 'sa'.<br/><br/>in my c: drive have 8GB free space,<br/>the password is correct,<br/>the service is in 'started' status in services,<br/><br/>after server restarted everything fine , login successfully and working. then after 9.30pm again login problem.<br/><br/>So, Whats the problem? How to solve this.<br/>thanks<br/>Sakthi.No need to post the same question more than once. I deleted the duplicate thread.please provide the link which is solved post. then u may delete.Please post the failure event(s) from Application Log, System Log and/or Security Log.Quote from: mac_sak on May 22, 2012, 07:27:47 AM</p><blockquote>please provide the link which is solved post. then u may delete.<br/></blockquote><br/>Quote of the Month Finalist...thanks for your reply!<br/><br/>There is no event occur during ms sql server failure.<br/><br/>during night <a href="https://interviewquestions.tuteehub.com/tag/time-19467" style="font-weight:bold;" target="_blank" title="Click to know more about TIME">TIME</a>(9.30pm approx..) when i try to connect sql server <br/><br/>below line found in event viewer.<br/>Failure Audit , Event ID : 18456 Login failed for user 'sa'. [CLIENT: 10.10.1.47] <br/><br/>But <br/>The file E:\General\SysDrv32.exe contains W32/IRCBot.worm.c Virus. The file was successfully deleted.<br/>found in event viewer.<br/><br/>the following was occur during working time .<br/>BACKUP LOG WITH TRUNCATE_ONLY or WITH NO_LOG is deprecated. The simple recovery <a href="https://interviewquestions.tuteehub.com/tag/model-942" style="font-weight:bold;" target="_blank" title="Click to know more about MODEL">MODEL</a> should be used to automatically truncate the transaction log.<br/><br/><br/>Quote from: mac_sak on May 23, 2012, 08:41:00 AM<blockquote>The file E:\General\SysDrv32.exe contains W32/IRCBot.worm.c Virus. The file was successfully deleted.<br/></blockquote><br/>Uh-oh. Please try posting in the malware forum.I uninstall sql server 2005 and install 2008 R2 but the problem not solve. Finally i move the db to another machine. Now there is no problem regarding sa login failed. <br/><br/>But the previous machine have network related problem. in task <a href="https://interviewquestions.tuteehub.com/tag/manager-239636" style="font-weight:bold;" target="_blank" title="Click to know more about MANAGER">MANAGER</a> "wlcollector.exe" <a href="https://interviewquestions.tuteehub.com/tag/make-249948" style="font-weight:bold;" target="_blank" title="Click to know more about MAKE">MAKE</a> end process everything is fine. wlcollector.exe occupy the tcp port after certain time. Quote from: Rob Pomeroy on May 28, 2012, 02:05:49 AM<blockquote>Uh-oh. Please try posting in the malware forum.<br/></blockquote></body></html>


Discussion

No Comment Found

Related InterviewSolutions