Error 8198: Could not obtain information about Windows NT group/user

Hi, we have a job that has been running for over 1 year. A few days
ago it stopped sending out an e-mail once the processing is done.
However, the job still runs and shows that it has been sucessful. I
have traced the problem to the select statement in the xp_sendmail
command below. When I comment out he query line, the command works
fine. The error I get is also below. Thanks in advance.
EXEC master..xp_sendmail
@.recipients = 'me@.company.com',
@.query = 'select COUNT(1) FROM DPEVENTD',
@.width = 160, @.no_header = 'TRUE',
@.subject = 'Test'
ODBC error 8198 (42000) Could not obtain information about Windows NT
group/user 'DOMAINNAME\me.
BTW, we have SQL2000 on Win2000/SP4. Thanks again.Is the job owner sa or a windows account ? That error usually means that SQL
could not get info back from a domain controller about the windows account.
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Joe Kim" <palestine2000bc@.yahoo.com> wrote in message
news:386f7047.0307251717.323ab1a6@.posting.google.com...
Hi, we have a job that has been running for over 1 year. A few days
ago it stopped sending out an e-mail once the processing is done.
However, the job still runs and shows that it has been sucessful. I
have traced the problem to the select statement in the xp_sendmail
command below. When I comment out he query line, the command works
fine. The error I get is also below. Thanks in advance.
EXEC master..xp_sendmail
@.recipients = 'me@.company.com',
@.query = 'select COUNT(1) FROM DPEVENTD',
@.width = 160, @.no_header = 'TRUE',
@.subject = 'Test'
ODBC error 8198 (42000) Could not obtain information about Windows NT
group/user 'DOMAINNAME\me.
BTW, we have SQL2000 on Win2000/SP4. Thanks again.|||This error caused because of the mixed Windows NT and
Windows 2000 domain environment. You probably have both
Windows 2000 and NT servers in the same domain. You need
to have your account to be added into the 'Pre-Windows
2000 Compatible Access' group in the domain. The server
has to be rebooted after the change is made to take effect.
I have ran into the same issue some time ago.
Hope it helps.
>--Original Message--
>Hi Jasper, I set the user to sa on Friday and yes, the
xp_sendmail
>works now. However, if I run xp_sendmail code from my
desktop, I
>still get the same message. I would leave things the way
they are,
>but my manager wants me to fix this problem. Any idea
what I should
>do next? Microsoft has close to nothing on this. Thanks
for your
>help!
>"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in
message news:<uD4uYu5UDHA.2268@.TK2MSFTNGP11.phx.gbl>...
>> Is the job owner sa or a windows account ? That error
usually means that SQL
>> could not get info back from a domain controller about
the windows account.
>> --
>> HTH
>> Jasper Smith (SQL Server MVP)
>> I support PASS - the definitive, global
>> community for SQL Server professionals -
>> http://www.sqlpass.org
>> "Joe Kim" <palestine2000bc@.yahoo.com> wrote in message
>> news:386f7047.0307251717.323ab1a6@.posting.google.com...
>> Hi, we have a job that has been running for over 1
year. A few days
>> ago it stopped sending out an e-mail once the
processing is done.
>> However, the job still runs and shows that it has been
sucessful. I
>> have traced the problem to the select statement in the
xp_sendmail
>> command below. When I comment out he query line, the
command works
>> fine. The error I get is also below. Thanks in advance.
>> EXEC master..xp_sendmail
>> @.recipients = 'me@.company.com',
>> @.query = 'select COUNT(1) FROM DPEVENTD',
>> @.width = 160, @.no_header = 'TRUE',
>> @.subject = 'Test'
>> ODBC error 8198 (42000) Could not obtain information
about Windows NT
>> group/user 'DOMAINNAME\me.
>> BTW, we have SQL2000 on Win2000/SP4. Thanks again.
>.
>|||Your suggestion certainly did the job. Thanks for your help.
BTW, for those who are going through the same problem, you need to
restart your database server for it to be able to detect the changes
on the Domain Controller.
"Coskun" <cxd349@.yahoo.com> wrote in message news:<000701c355eb$e8525050$a401280a@.phx.gbl>...
> This error caused because of the mixed Windows NT and
> Windows 2000 domain environment. You probably have both
> Windows 2000 and NT servers in the same domain. You need
> to have your account to be added into the 'Pre-Windows
> 2000 Compatible Access' group in the domain. The server
> has to be rebooted after the change is made to take effect.
> I have ran into the same issue some time ago.
> Hope it helps.
>
> >--Original Message--
> >Hi Jasper, I set the user to sa on Friday and yes, the
> xp_sendmail
> >works now. However, if I run xp_sendmail code from my
> desktop, I
> >still get the same message. I would leave things the way
> they are,
> >but my manager wants me to fix this problem. Any idea
> what I should
> >do next? Microsoft has close to nothing on this. Thanks
> for your
> >help!
> >
> >"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in
> message news:<uD4uYu5UDHA.2268@.TK2MSFTNGP11.phx.gbl>...
> >> Is the job owner sa or a windows account ? That error
> usually means that SQL
> >> could not get info back from a domain controller about
> the windows account.
> >>
> >> --
> >> HTH
> >>
> >> Jasper Smith (SQL Server MVP)
> >>
> >> I support PASS - the definitive, global
> >> community for SQL Server professionals -
> >> http://www.sqlpass.org
> >>
> >> "Joe Kim" <palestine2000bc@.yahoo.com> wrote in message
> >> news:386f7047.0307251717.323ab1a6@.posting.google.com...
> >> Hi, we have a job that has been running for over 1
> year. A few days
> >> ago it stopped sending out an e-mail once the
> processing is done.
> >> However, the job still runs and shows that it has been
> sucessful. I
> >> have traced the problem to the select statement in the
> xp_sendmail
> >> command below. When I comment out he query line, the
> command works
> >> fine. The error I get is also below. Thanks in advance.
> >>
> >> EXEC master..xp_sendmail
> >> @.recipients = 'me@.company.com',
> >> @.query = 'select COUNT(1) FROM DPEVENTD',
> >> @.width = 160, @.no_header = 'TRUE',
> >> @.subject = 'Test'
> >>
> >> ODBC error 8198 (42000) Could not obtain information
> about Windows NT
> >> group/user 'DOMAINNAME\me.
> >>
> >> BTW, we have SQL2000 on Win2000/SP4. Thanks again.
> >.
> >