Computer Hope

Microsoft => Microsoft Windows => Windows Server => Topic started by: mac_sak on May 22, 2012, 07:10:50 AM

Title: MS Sql server 2005 login failed problem
Post by: mac_sak on May 22, 2012, 07:10:50 AM

Hi to all,

In my server , ms msql server 2005 installed  and everything fine before few days, but now I have some new problem.
the problem is after 9.30pm(approx...)  when login ms sql server using 'sa' , the result is login failed user 'sa'.

in my c: drive have 8GB free space,
the password is correct,
the service is in 'started' status in services,

after server restarted everything fine , login successfully and working. then after 9.30pm again login problem.

So, Whats the problem? How to solve this.
thanks
Sakthi.

Title: Re: MS Sql server 2005 login failed problem
Post by: Allan on May 22, 2012, 07:20:39 AM

No need to post the same question more than once. I deleted the duplicate thread.

Title: Re: MS Sql server 2005 login failed problem
Post by: mac_sak on May 22, 2012, 07:27:47 AM

please provide the link which is solved post. then u may delete.

Title: Re: MS Sql server 2005 login failed problem
Post by: Rob Pomeroy on May 22, 2012, 08:36:38 AM

Please post the failure event(s) from Application Log, System Log and/or Security Log.

Title: Re: MS Sql server 2005 login failed problem
Post by: patio on May 22, 2012, 08:38:01 AM

Quote from: mac_sak on May 22, 2012, 07:27:47 AM

please provide the link which is solved post. then u may delete.

Quote of the Month Finalist...

Title: Re: MS Sql server 2005 login failed problem
Post by: mac_sak on May 23, 2012, 08:41:00 AM

thanks for your reply!

There is no event occur during ms sql server failure.

during night time(9.30pm approx..) when i try to connect sql server

below line found in event viewer.
Failure Audit  , Event ID : 18456 Login failed for user 'sa'. [CLIENT: 10.10.1.47]

But
The file E:\General\SysDrv32.exe contains W32/IRCBot.worm.c Virus.  The file was successfully deleted.
found in event viewer.

the following was occur during working time .
BACKUP LOG WITH TRUNCATE_ONLY or WITH NO_LOG is deprecated. The simple recovery model should be used to automatically truncate the transaction log.

Title: Re: MS Sql server 2005 login failed problem
Post by: Rob Pomeroy on May 28, 2012, 02:05:49 AM

Quote from: mac_sak on May 23, 2012, 08:41:00 AM

The file E:\General\SysDrv32.exe contains W32/IRCBot.worm.c Virus.  The file was successfully deleted.

Uh-oh.  Please try posting in the malware forum.

Title: Re: MS Sql server 2005 login failed problem
Post by: mac_sak on June 20, 2012, 11:58:15 PM

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.

But the previous machine have network related problem. in task manager "wlcollector.exe" make end process everything  is fine. wlcollector.exe occupy the tcp port after certain time.

Title: Re: MS Sql server 2005 login failed problem
Post by: Rob Pomeroy on July 19, 2012, 04:22:50 AM

Quote from: Rob Pomeroy on May 28, 2012, 02:05:49 AM

Uh-oh.  Please try posting in the malware forum.