2012年3月29日星期四

Full text searching in advanced services edition

I have installed the advanced services edition but cannot find out how to build and populate full text catalogs. Nothing shows on the MSSMSE tool and when I try to use a sql command to create a new catalog it says that the full text service is not installed. Am I missing something?

The Full-text Search menus in Management Studio have a dependency on SQL Agent, so they were excluded from Management Studio Express as SQL Express doesn't have SQL Agent.

As far as the error, it is completely possible that FTS is not installed as it is not part of the default installation of Express Advanced. If you did not choose to install FTS from the feature tree, it's not there. You'll need to launch the Express Advanced setup in maintenance mode and verify that you've installed all the components.

If you have installed all the components, then you should check the error log and relay the exact error so we can troubleshoot further.

Regards,

Mike Wachal
SQL Express team

-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1

没有评论:

发表评论