You can execute:
EXEC sp_grantlogin [NT Authority\System]
And then add that account to the sysadmins role:
EXEC sp_addsrvrolemember [NT Authority\System], 'sysadmin'
-Sue
On 21 Feb 2007 06:43:18 -0800, myrights99@xxxxxxxxx wrote:
I came across the issue where NT Authority\System Account is been
removed from SQL Server 2000 (Security) & i have to add this back. SQL
Server Services is running under SYSTEM ACCOUNT. Any help how to add
back NT Authority\System Account will be appreciated & thanking in
advance.
Re: update index in background not running. ... in order to allow an .net web program to access the SQL server you have to ... add IIS_WPG account to the database, ... > exec sp_defaultdb N'NT Authority\System', ... (microsoft.public.sqlserver.fulltext)
RE: Use a Trusted Connection With OPENROWSET? ... The OPENROWSET is done in the context of the SQL Server account that is ... Most of the time it is the local machine account.... > EXEC master..sp_who2') AS a ... (microsoft.public.sqlserver.connect)
Re: The Microsoft Search service cannot be administered under the pres ... the BUILTIN\Administrator account as well as a member of the Sysadmin role? ...SQL Server Full-Text Search Does Not Populate Catalogs ... you or your server's sysadmin have removed the ...exec sp_defaultdb N'NT Authority\System', N'master' ... (microsoft.public.sqlserver.fulltext)
Re: Full Text Indexing not Populating ... You're welcome, JayB,...SQL Server Full-Text Search Does Not Populate Catalogs ...MSSQLServer Logon Account Through [NT4.0) Control Panel [or Win2K Component ...exec sp_defaultdb N'NT Authority\System', N'master' ... (microsoft.public.sqlserver.fulltext)
Re: Cant Administer ... Can you verify that the MSSearch account is running under the local system ... Has anyone modified the SQL Server service account through the ...system administrators role....exec sp_defaultdb N'NT Authority\System', N'master' ... (microsoft.public.sqlserver.fulltext)
