Help with the error: The Full-Text Service (msftesql) failed to logon

Hi I am trying to do a simple drop catalog command which is:

DROP FULLTEXT CATALOG <CATALOG_NAME> ;
GO

But I keep getting this error:

Msg 9956, Level 16, State 2, Line 4aThe Full-Text Service (msftesql) failed to logon. The system administrator must use a valid service account and password for the service.

Any ideas on what to do?
eecosmo01Asked:
Who is Participating?
 
Anthony PerkinsConnect With a Mentor Commented:
>>but how do I give it the permissions to do index'ing?<<
In order to create a catalog (and unrelated to the Full-Text service startup account) this is what Books Online has to say about using the sp_fulltext_catalog extended stored procedure:

<quote>
Permissions
The caller is required to be member of the db_owner role. Depending on the action requested, the caller should not be denied ALTER or CONTROL permissions (which db_owner has) on the target full-text catalog.
</quote>
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
I think you have a incalid username -password problem. Check the username/password fpr  the service msftesql, by default the username and password is that of the service 'SQL Server Database Engine'.

0
 
eecosmo01Author Commented:
I do not see this service in the the list of services nor do I see this user in list of logins under in my sql management app. How do I change this password?
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
Anthony PerkinsCommented:
>>I do not see this service in the the list of services<<
It is called Microsoft Search.
0
 
eecosmo01Author Commented:
I have searched for the solution already and have not come up with anything. This is why I am asking here. Try it yourself, there are NO results if you search for this error on goog/yahoo/live
0
 
Anthony PerkinsCommented:
Questions for you:
Which edition of SQL Server 2005 are your using?
Have you managed to find the Full-Text Service?
If you have, is the startup account a local administrator account?
0
 
eecosmo01Author Commented:
>>Which edition of SQL Server 2005 are your using?

I am using the Standard Edition.

>>Have you managed to find the Full-Text Service?

What do you mean by this? I am simply executing SQL commands such as:

DROP FULLTEXT CATALOG [TestCat] ;
GO

execute sp_fulltext_catalog 'TestCat','create'
GO

>>If you have, is the startup account a local administrator account?

Yes I startup using the local admin account which is why I am so confused by this error =(
0
 
Anthony PerkinsCommented:
>>Yes I startup using the local admin account<<
Aside from the fact that this for security reasons is not recommended, have you restarted the service since installing SQL Server or changing the account?
0
 
eecosmo01Author Commented:
I do agree that the security setting is not ideal but I do not have any sensitive data on this computer...

Anyhow so I change the 'SQL Server FullText Search (MSSQLSERVER)' service to be logged in as 'Local System' it works!

So how do I make it so that the ./Administrator user works?

0
 
Anthony PerkinsCommented:
Unfortunately you have to use a System Account.
0
 
eecosmo01Author Commented:
Serious? Then why does the service by defualt start as ./Administrator? Are there any problems by leaving it as a local system user? Thanks!
0
 
Anthony PerkinsCommented:
>>Are there any problems by leaving it as a local system user?<<
From the SQL Server Help:

<quote>
For the Full-Text Search service account, we strongly recommend using a low-privileged domain user account with only User rights and permissions on the local computer. Also, to ensure you are running the service with the lowest possible privileges, each instance of Full-Text Search should have a dedicated service account.

For security considerations, do not use LOCAL SYSTEM, LOCAL SERVICE, or NETWORK SERVICE as the service account to run MSFTESQL. This could provide an elevation of privileges for the Full-Text Search service.
</quote>
0
 
eecosmo01Author Commented:
Thanks, so if I use a Local System account it works, if I use anything else (I was using ./Administrator) then it doesnt.... I can create another account but how do I give it the permissions to do index'ing? I can't seem to find an option in the SQL Management Studio, better yet is there a way I can do this via a SQL Query?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.