2012年3月9日星期五

Full text HELP!

Can anyone tell me why this doesnt work:
1- full text service is running under local system account
2- sql server is running under a domain account
3- local admin consists of both (domain admins and system)
4- correct priviledges are given to the folders (sql
folders)
5- sql is in CLUSTER (4 nodes / 4 virtual servers)
When i create a catalog it works. When i populate it.. it
says that it populated with sucess but value maintains 0 ?
I have the article (microsoft) where it tells me builtin
admins need to be in the logins.. i have tryed with
builtin admin AND nt authority system (seperatly) and
still doesnt work... it worked ONCE but then never worked
again.. it populates with no errors but the value mantains
0
event viewer gives me the following warnings: 3036 3035
and 3024 but when i reaseached them i get the article
about the builtin admins and ms search running under local
system acount which is already the case...
Can anyone help me? Is full text supported in cluster?
what can i do to fix this problem?
this basically means that MSSearch is unable to access SQL Server to
retrieve the rows it wishes to index.
Most frequently this problem is caused when you modify the MSSQL Server
account using control panel instead of Enterprise Manager. Check out this kb
article for more info:
http://support.microsoft.com/default...b;en-us;277549
This is SQL 7 but it still applies
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"" <anonymous@.discussions.microsoft.com> wrote in message
news:2dbfa01c46a87$29eca3c0$a501280a@.phx.gbl...
> Can anyone tell me why this doesnt work:
> 1- full text service is running under local system account
> 2- sql server is running under a domain account
> 3- local admin consists of both (domain admins and system)
> 4- correct priviledges are given to the folders (sql
> folders)
> 5- sql is in CLUSTER (4 nodes / 4 virtual servers)
> When i create a catalog it works. When i populate it.. it
> says that it populated with sucess but value maintains 0 ?
> I have the article (microsoft) where it tells me builtin
> admins need to be in the logins.. i have tryed with
> builtin admin AND nt authority system (seperatly) and
> still doesnt work... it worked ONCE but then never worked
> again.. it populates with no errors but the value mantains
> 0
> event viewer gives me the following warnings: 3036 3035
> and 3024 but when i reaseached them i get the article
> about the builtin admins and ms search running under local
> system acount which is already the case...
> Can anyone help me? Is full text supported in cluster?
> what can i do to fix this problem?

没有评论:

发表评论