January 24, 2005 at 6:51 am
I seem to recall a thread on this subject before but cannot locate it. I am getting the error "ODBC error 8198 (42000) Could not obtain information about Windows NT group/user" when executing xp_sendmail using the @query parameter. SQL mail works, SQL Agent mail works, and xp_sendmail works when I remove @query. This particular server is NT 4 and is on another domain, and the only thing that might have changed would be adding MS security fixes. Anyone have any ideas? Thanks.
Linda
January 24, 2005 at 7:38 am
Someone may have inadvertantly broken the trust between the two domains...I'd check that out first, here's a link to a MS article on this particular problem... http://support.microsoft.com/?kbid=834124
January 24, 2005 at 8:26 am
Thank you. Actually I found that same article in my "archives" (folder stuff 🙂 because the error occurred last year on another server, but it mysteriously cleared up. I'm going to check with the Admin group to see what's up. I have a hunch you're right....
Linda
January 31, 2005 at 6:10 am
For anyone who may be interested, I found the problem. There is a MS article # 839405 called "You may receive an access violation exception when you try to use SQL Mail on a multiprocessor computer" that was the issue. The fix was to add a MAPIInitialize Flags registry key. Hope this is helpful to others experiencing the same problem 🙂
Linda
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply