Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have an sql server 2008 installed. there are about 6 databases created and running on this server I often get message like "SA account is locked out"

is there any specific reasons for this account being locked out?

is there any other place I need to check the reasons ( I checked the eventviwer but could not get much information)

Edit: i found this information in teh eventviewer backups. Is this the cause?

SQL Server failed to communicate with filter daemon launch service 

(Windows error: The service cannot be started, either because it is disabled or because it has no enabled devices associated with it. ). Full-Text filter daemon process failed to start. Full-text search functionality will not be available.

share|improve this question
    
do you still need to use mixed authentication? It's probably easily resolvable by using windows authentication only –  Jim B Apr 28 '10 at 12:02

2 Answers 2

Make sure the Audit Failed Logins is set on the SQL Server properties. Then you can check the SQL Server Logs to see where and/or when the connection is being attempted that locks the SA account.
I agree with Jim B though if you can switch to Windows Auth that would fix this.

share|improve this answer

Open Sql Server Configuration Manager. Click SQL Server Services on the left hand side. In the list on the right you will see all the services that SQL has on your box. What does SQL Full-text Filtering say for Status and Log on As?

It sounds like it will be stopped and also if you double click it in the properties box that pop-up under Log On select Local Service

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.