Re: Full Text Indexing on Microsoft SQL Server 2000 with Windows XP Pro

johndoe_at_driver.net
Date: 11/11/04 

Date: Thu, 11 Nov 2004 01:14:23 -0600

Thanks. I went in there and I found the Auditing level set to None which
explains why I was not receiving any errors. I set the Auditing to all and
errors were logged during an attempt to populate. It turns out that it was
failing per the Built in Administrator account not existing.
http://support.microsoft.com/kb/317746 After following those instructions
and repopulating I now have 10 items in my Item Count :)

The Help was Greatly Appreciated. I would have never found the Auditing
levels without your help.

"John Kane" <jt-kane@comcast.net> wrote in message
news:eB$koX6xEHA.3024@TK2MSFTNGP14.phx.gbl...
> JohnDoe,
> Yes, it is. (see SQL Server 2000 BOL title "Features Supported by the
> Editions of SQL Server 2000").
> Have you or anyone else made any changes to the SQL Server (MSSQLServer)
> service startup account &/or password via WinXP's Component Services? If
> so,
> then you MUST "re-make" the change via the Enterprise Manager's server
> security tab as this is the only place where the two services'
> (MSSQLServer
> & MSSearch) security are synced up. See KB article 277549 (Q277549) PRB:
> Unable to Build Full-Text Catalog After You Modify MSSQLServer Logon
> Account
> Through [NT4.0) Control Panel [or Win2K Component Services] at
> http://support.microsoft.com/default.aspx?scid=KB;EN-US;277549 for more
> info.
>
> Note, you can also post FTS related questions to the newsgroup:
> microsoft.public.sqlserver.fulltext.
> Regards,
> John
>
>
>
> <johndoe@driver.net> wrote in message
> news:OJ840R5xEHA.4052@TK2MSFTNGP10.phx.gbl...
>> I am wondering if FUll Text Indexing is suported with MS SQL Server 2000
>> Developer Edition on XP Pro SP2 . I have the service installed and setup.
> I
>> have created several catalogs with data but when they are done populating
>> they show up with an Item Count of 0 and a Unique Index of 1 despite the
>> fact that there are 10+ records with extremely different data in the 3
>> columns that are being indexed.
>>
>> I am not seeing any unusual messages in the Event Viewer also. I have
>> uninstalled and reinstalled already and the Server is running under an
>> Administrator User
>>
>>
>> Reposted because it seems like .server is inactive or Outlook just
>> refuses
>> to poll it for messages
>>
>>
>
>

Relevant Pages

  • Re: Tracing sql server user logins
    ... Now for your question: base auditing ... > GroupName sysname NULL, ... SQL Server does not audit by ... >>Failure causes only failed login attempts to be audited. ...
    (microsoft.public.sqlserver.security)
  • Re: Question on C2 Log
    ... I am now analyzing the trace, ... >> auditing all logins no matter it is successfully or failed? ... >> Audit Level you wanted. ... click SQL Server and Windows. ...
    (microsoft.public.sqlserver.security)
  • Re: failed login attempts
    ... The Hostname of the client computer is captured (for sure in ... You can indeed turn on failed login auditing via a ... You can also capture this information with ... Microsoft SQL Server doesn't have built-in failed logins ...
    (microsoft.public.sqlserver.security)
  • RE: SQL Worm
    ... You may want to enabling login auditing in SQL Server. ... Also to identify the culprit process/workstation you can use the ...
    (microsoft.public.sqlserver.security)