The amazing adventures of Doug Hughes

I recently needed to add a full text index on a table in a Microsoft SQL database. However, any time I tried to enable full text indexing on my database I received this obnoxious error: “The Microsoft Search service cannot be administered under the present user account.”

I Googled this message and didn’t come up with anything that seemed to help. I was able to deduce that this message (and several related messages) crop up when the user account under which MSSQL is running doesn’t have permission to access the Microsoft Search service.

Most of the advice I saw was to access the SQL Server properties though Enterprise Manager. From this, click on the Security tab and change the startup account to the System account and restart the SQL server. After this, you needed to repeat this process and change it back to the user account you want to run the SQL server under.

The reason you’re supposed to do this is that apparently when you change the account under which SQL Server runs from the properties panel, SQL Server adds the provided user account as an administrator for the Search service. Most of these problems seem to come from changing the SQL Server user account in from the Services control panel, which will not cause the Search service to be updated correctly.

This was a distinct possibility for my server so I tried this. Unfortunately it didn’t work.

After a bit more creative Googling, I found this link, which unfortunately requires you to register and log in. So, after registering (and probably committing myself to a life of even more spam), I logged in and read what turned out to be a message board post.

About half way down someone named “georgedo” posted the following steps to follow. There was no explanation as to what these steps were supposed to actually do. I decided to blindly follow the instructions and see what happened. (You might not want to try this at home.)

The steps were as follows:

  1. Search for the file named “ftsetup.exe” on the SQL server and note it’s location. I found mine under “C:Program FilesMicrosoft SQL ServerMSSQLBinn”.
  2. Open a command prompt to the path found in step 1.
  3. Execute this command: “ftsetup.exe sqlserver 0 1 0 0 0 4 “. I have no idea what this is supposed to do.
  4. The instructions said to note the result from this command. I don’t know why. It didn’t seem to matter. Mine returned this message: “FulltextSetup returned error code: 0x0”.
  5. At this point I diverged slightly from the instructions. I did a search for the file “sqlfth75.dll ” and noted it’s location.
  6. Open a command prompt to the path found in step 5.
  7. Run this command: “regsvr32 sqlfth75.dll “
  8. Restart the Microsoft Search and MSSQLSERVER services.

I followed those steps. Much to my amazement, it worked!

So, the moral of the story is that you should blindly trust people on the web who seem to know what they’re talking about. Well maybe not. Luckily, in this case it worked out for me. If you’re having the same problem you might want to try this too. If you have problems, track down “georgedo” and pester him!

Comments on: "Problems Creating Full Text Index in MSSQL 2000 on Windows Server 2003" (14)

  1. jared chandler said:

    i had a similar experience working with full-text search and the noise-words files. (you can use a blank noise words file only if it contains a single new line character, if it’s completely blank, it will be ignored and an internal one will be used by default) i finally found a solution posted on some newsgroup. i felt like i was one of maybe a dozen people who’d ever asked and required an answer to this question. under SQL2000 full-text was a freaky mystery shrouded in darkness.. SQL2003 is much better.

    Like

  2. Ufff !!!! After hours and hours
    Finaly, this work for me too. Thanks 🙂

    Like

  3. Brilliant!! After searching for hours for a solution to my "the microsoft search service cannot be administered under the present user account" this finally worked. The registering of the dll produced an error but that didn’t matter as it was step 3 that worked a treat.

    Like

  4. Too weird…blind leading the blind 🙂

    rack up another happy customer, thanks.

    Like

  5. Worked for us also.

    Like

  6. Hi Doug,

    I tried all the steps but no luck for me.

    I got the sqlfth75.dll in three diffrent locations and I registered from all the tree locations still no luck.

    1. C:SQL2KSP4x86fulltext
    2. C:Program Files(x86)Microsoft SQL Server 80COM
    3. D:SQL2Ksp4x86fulltext

    I will be glad if you email me back at asiyafhussain@hotmail.com
    Best
    Ashley

    Like

  7. Worked! What the heck would I do without Google?

    Like

  8. John Smith (Leeds) said:

    The “ftsetup.exe sqlserver 1 0 0 0” reinstalls the search service and is the thing that make it.

    See http://support.microsoft.com/?kbid=827449

    Like

  9. [SokSa]Icy said:

    Bless your heart! I’ve been trying to find a solution to that problem since this morning. And no document, no knowledge base article worked. This solution DID!!!

    Cheers mate 🙂

    Like

  10. Ravi kumar said:

    it worked For me , i am happy Now

    Happy Happy

    Like

  11. I spent so much time searching Google for a solution, thank you so much for posting this.

    Like

  12. beautiful

    Like

  13. Gabriel Andres Brancolini said:

    Start Microsoft Search Service with Admin account and thats all.

    Like

  14. Heather Masterson said:

    For all the folks who did not have success with these steps, what eventually worked for me is posted here:

    https://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=4058903&SiteID=17

    It was a doozey!

    Best,
    Heather

    Like

Comments are closed.

Tag Cloud

%d bloggers like this: