Re: full-text population problem

From: Hilary Cotter (hilaryk_at_att.net)
Date: 07/25/04 

Date: Sun, 25 Jul 2004 08:22:59 -0400

can you look in the application log for event messages from MSSearch or
MSSCI?

Most often this problem is caused by

1) changing the SQL Server service account through control panel instead of
Enterprise Manager
2) changing MSSearch's service account to a local or domain account instead
of keeping in local system
3) removing the builtin\administrators group from the system administrators
role.

to fix 1 refer to
http://support.microsoft.com/default.aspx?scid=kb;en-us;277549
to fix 2 click Start, point to settings, click control panel, double click
administrative tools, double click on services, double click Microsoft
Search, click the Logon tab, and select Local System, clear the Allow the
service to interact with the desktop, click on Apply and ok, and accept all
defaults
to fix 3 execute the below tsql in Query Analyzer

--Grant [NT Authority\System] a logon to SQL Server:
EXEC sp_grantlogin [NT Authority\System]
--Add that account to the sysadmins role:
EXEC sp_addsrvrolemember @loginame = [NT Authority\System] , @rolename =
'sysadmin' 

-- 
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Mohamed Salah" <msalah_din@yahoo.com> wrote in message
news:u5Ls8eicEHA.3944@tk2msftngp13.phx.gbl...
> I have a problem in full population for a full text index.
> When I run the population; these are the results
> - Population duration : 3-5 seconds.
> - item count : 0
> - catalog size : 0
> - unique key count : 1
> although I have 7 million of records in that table
>
> I need explanation please.
> Than you
>
> **********************************************************************
> Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
> Comprehensive, categorised, searchable collection of links to ASP &
ASP.NET resources...

Relevant Pages

  • RE: Upgrade from 2005 to 2008: Invalid Credentials
    ... it seems that this issue was related to NETWORK SERVICE account for SSIS service could not be validated on DC. ... Please first go to your Services pane, double click your SQL Server Integration Services, switch to the Log On tab to check if the service account is NETWORK SERVICE account. ... Install SQL Server 2008 from the Command Prompt ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.setup)
  • Re: SPN Requirement
    ... The service account for SQL Server needs to be a domain ... account to allow Write Public Information rights but I'd ... The SQL Network Interface library could not register the Service Principal ... Name for the SQL Server service. ...
    (microsoft.public.sqlserver.security)
  • Re: Question about "Distribution clean up: distribution" Job
    ... I granted the SQL Server Service Account "Full Control" over ... the Snapshot Folder and the job has been running successfully ever since. ... Then I went into the job step and copied the command it was ...
    (microsoft.public.sqlserver.replication)
  • Re: xp_cmdshell failed to execute because current security context
    ... INFO: databasename: xp_cmdshell failed to execute because ... SQL Server running under has appropriate privilege. ... Server service account does not have all the relevant permissions not the sql ... ontario, canada ...
    (microsoft.public.sqlserver.server)
  • Re: Question about "Distribution clean up: distribution" Job
    ... I am guessing that the SQL Server Agent service account is not what ... rights to remove folders under P:\ReplData. ... Then I went into the job step and copied the command it was ...
    (microsoft.public.sqlserver.replication)
Loading