Hello,
When I run an incremental/full job for a full text
catalog on win 2k , SQL 2K sp3a cluster server, i am
getting this in the SQL error log
Login failed for user domain\servername$
We recently removed the local admin group having syadmin
access to the server.
I changed the Job owner to the SQL Startup account, even
then it is using the above login. Why is that ?
I couldnt be able to grant the login access as i am not
able to see in the list of users...
Where is this login, can i change something to fix ?
Thanks
- Saravana
can you add this account to the system administrator role?
if not exists (select * from master.dbo.syslogins where loginname = N'NT
Authority\System')
exec sp_grantlogin N'NT Authority\System'
exec sp_defaultdb N'NT Authority\System', N'master'
exec sp_defaultlanguage N'NT Authority\System', N'us_english'
GO
exec sp_addsrvrolemember N'NT Authority\System', sysadmin
GO
"SK" <anonymous@.discussions.microsoft.com> wrote in message
news:1420b01c41808$d9e0f460$a601280a@.phx.gbl...
> Hello,
> When I run an incremental/full job for a full text
> catalog on win 2k , SQL 2K sp3a cluster server, i am
> getting this in the SQL error log
> Login failed for user domain\servername$
> We recently removed the local admin group having syadmin
> access to the server.
> I changed the Job owner to the SQL Startup account, even
> then it is using the above login. Why is that ?
> I couldnt be able to grant the login access as i am not
> able to see in the list of users...
> Where is this login, can i change something to fix ?
> Thanks
> - Saravana
>
没有评论:
发表评论