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

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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: Finding total used space
    ... If you run sp_helpfile against each database you will get a report. ... exec sp_helpfile 'master' ... the file space for a database is actually used. ... > Is there a table somewhere in master or somewhere, ...
    (microsoft.public.sqlserver.security)
  • Re: SQL2000 UserPermissions for Database
    ... database 'databaseA', owner 'dbo'. ... meanwhile i have created Newsp_helplogins under master and this will ... but then userx cannot exec this too. ...
    (microsoft.public.sqlserver.security)
  • Error 21776:
    ... use master ... exec sp_addsrvrolemember 'DOMAIN\ug_ITSec_SQL', 'securityadmin' ... However, when I then click on the Login and check out the database access, I ...
    (microsoft.public.sqlserver.security)
  • Re: Error 21776:
    ... use master ... exec sp_addsrvrolemember 'DOMAIN\ug_ITSec_SQL', 'securityadmin' ... Then after, trying to grant that new login db_owner permissions, for ... However, when I then click on the Login and check out the database access, ...
    (microsoft.public.sqlserver.security)
  • Re: db_denydatawriter
    ... perhaps this also gives read write access on the database to this user? ... Resrictive permissions overrides in its own level. ... However, if she has sysadmin right, then she'll be able to modify that data. ... Is it possible she has some admin rights which override DenyWriter (though ...
    (microsoft.public.sqlserver.security)