Re: New install of Windows 2003 EE sp1 and Sql Server 2000 sp3 full text problem

thanks for the response.. I have checked and the accounts are as they should
be. this is already a production box so stopping and restarting the sql
service is not an option right now..

hope someone else has run into this and can help me out.
thanks
shannon
"John Kane" <jt-kane@xxxxxxxxxxx> wrote in message
news:ex%23hQHbUFHA.3188@xxxxxxxxxxxxxxxxxxxxxxx
> Shannon,
> You should also confirm if the startup account for the SQL Server service
> (MSSQLServer) has been altered via Win2K's Component applet vs. being
> altered via SQL Server Enterprise manager. The later is the only place
> where
> if one server is altered then both services security context is altered.
> See
> the following two KB articles for more info:
>
> 317746 (Q317746) PRB: SQL Server Full-Text Search Does Not Populate
> Catalogs
> http://support.microsoft.com/default.aspx?scid=kb;en-us;317746
>
> 277549 (Q277549) PRB: Unable to Build Full-Text Catalog After You Modify
> MSSQLServer Logon Account Through [NT4.0) Control Panel [or Win2K
> Component
> Services]
> http://support.microsoft.com/default.aspx?scid=KB;EN-US;277549
>
>
> Hope this helps!
> John
> --
> SQL Full Text Search Blog
> http://spaces.msn.com/members/jtkane/
>
>
> "Shannon Ramirez" <dba@xxxxxxxxxxxxxxx> wrote in message
> news:u1WLC9aUFHA.2096@xxxxxxxxxxxxxxxxxxxxxxx
>> no.. i'm the database guy and I didn't alter it.
>> I've just doubled checked.. default db is master and it belongs to the
>> sysadmin role.
>>
>> anything else you can think of that I shoudl check
>> "John Kane" <jt-kane@xxxxxxxxxxx> wrote in message
>> news:O%23QYzjaUFHA.3176@xxxxxxxxxxxxxxxxxxxxxxx
>> > Shannon,
>> > Have you or anyone else removed or altered the login
>> > BUILTIN\Administrators
>> > ? If so, can you either re-establish it or reset the defaults back to
>> > master
>> > database with sysadmin rights? If not (for security reasons), you may
> want
>> > to implement the following T-SQL code as the external MSSearch service
>> > (should be running under the system account) needs sysadmin rights when
>> > accessing SQL Server:
>> >
>> > exec sp_grantlogin N'NT Authority\System'
>> > exec sp_defaultdb N'NT Authority\System', N'master'
>> > exec sp_defaultlanguage N'NT Authority\System','us_english'
>> > exec sp_addsrvrolemember N'NT Authority\System', sysadmin
>> >
>> > Thanks,
>> > John
>> > --
>> > SQL Full Text Search Blog
>> > http://spaces.msn.com/members/jtkane/
>> >
>> >
>> > "Shannon Ramirez" <dba@xxxxxxxxxxxxxxx> wrote in message
>> > news:u6kXJPaUFHA.1200@xxxxxxxxxxxxxxxxxxxxxxx
>> >> I have a newly installed Windows 2003 EE sp1 with Sql Server 2000 sp3
>> >> machine. I restored a database to the machine that had several full
> text
>> >> catalogs in it. I'm trying to go in and do a rebuild on the catalogs.
>> > When
>> >> I do this.. I get the error:
>> >>
>> >> Error 7635: The Microsoft Search service cannot be administered under
>> >> the
>> >> present user account.
>> >>
>> >> The Sql Server Agent is being started with the system account.
>> >>
>> >>
>> >> I've tried this on a windows 2003 sp1 standardard machine with sql
>> >> 2000
>> > sp3.
>> >> I get the same error. It's making me belive that perhaps sp1 put some
>> >> security on that needs to be changed...
>> >>
>> >> can someone help me get Full Text going agian.
>> >> Thanks
>> >> Shannon
>> >>
>> >>
>> >
>> >
>>
>>
>
>


.

Relevant Pages

  • Re: SQL account rights
    ... Please advice what is the best, suitable rights rather than domain admin ... Warren Brunk - MCITP - SQL 2005, ... Add it as a login to the SQL Server ... files, or backups, make sure that the service account has Full ...
    (microsoft.public.sqlserver.security)
  • Re: User authentication
    ... There are 2 SQL Server 2005 ... 1 SQL Server 2000 installed on another server ... Windows account instead to run backup jobs. ...
    (microsoft.public.sqlserver.clients)
  • Re: SQL 2000 Server gets hacked
    ... Thank you Beth. ... > placed a strong password on the 'sa' account?) ... Your SQl Service itself shouldn't be running as a ... (SQL Agent requires more, but not SQL Server). ...
    (microsoft.public.sqlserver.security)
  • Re: SQL 2000 Server gets hacked
    ... Thank you Beth. ... > placed a strong password on the 'sa' account?) ... Your SQl Service itself shouldn't be running as a ... (SQL Agent requires more, but not SQL Server). ...
    (microsoft.public.sqlserver.security)
  • Re: Microsoft Search service cannot be administered under the present user error SP3
    ... - Have not modified Administrator account, but i ran the SQL script anyway. ... SQL account is not a local administrator. ... > has this server ever been upgrade from SQL Server 7.0 or is this SQL ...
    (microsoft.public.sqlserver.fulltext)
Quantcast