Job in SQL Server Agent owned by a Domain\account fails. [SQLSTATE 4200][Error 8198]  
Author Message
loganboyd





PostPosted: Top

SQL Server >> Job in SQL Server Agent owned by a Domain\account fails. [SQLSTATE 4200][Error 8198]

Hello,
I have a Windows Server 2003 with SQLServer2000, SP4.
I created a Job in SQL Server Agent that should save a database. This
works when I use a local account on the respective Server.
But when using a domain account the job fails almost immediately (8
sec).
The domain account used is Sysadmin in SQLServer and belongs to the
Administrators group on the local server.
I checked the www already and there is some talk but no solution.
All these hints to "pre-windows 2000 groups" do not apply since this
is Windows Server 2003, enterprise edition, Service Pack 1.

The stored procedure which obviously is exceuted in the background and
which calls Windows API functions also fails in Query Analyzer:
xp_logininfo 'domain\account'

1 row(s) affected

Server: Msg 8198, level 16, State 24, Procedure xp_logininfo, Line 58
Could not obtain information about Windows NT group/user 'domain
\account'.

Please only answer if you do have a remedy enabling me to use a domain
account.
Thank you

SQL Server270