April 25, 2003 at 10:38 am
I am experiencing a weird e-mail problem on my servers that have SP3 on them. If I use the @query parameter with xp_sendmail, I get the following error: "ODBC error 8198 (42000) Could not obtain information about Windows NT group/user 'BCDOM\SQLServer'. [SQLSTATE 01000]".
This worked fine on these servers before SP3 was applied and it works other servers with SP2. For right now, I will just create a stored proc to save the query in a varchar and use the @message parameter instead.
Has anyone heard of this?
Thanks,
Kathi
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
April 28, 2003 at 8:00 am
This was removed by the editor as SPAM
April 28, 2003 at 8:33 am
April 28, 2003 at 8:56 am
Even though the same error message is mentioned in the articles, neither one addresses my issue. I have modified my proc to use a cursor to read each row and build a message string instead of using @query.
Thanks,
Kathi
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
February 7, 2006 at 2:54 pm
Has ANYBODY ever actaully solved this issue. I have done everything in the article and nothing works.
The strange thing is, on 2 of about 30 SQL Servers here are doing it and they were all setup identicle to one another.
This is driving me NUTS!!!!
February 22, 2006 at 7:09 am
Well, may not relate, but we had a similar problem with certain sql servers unable to resolve the sql mail email address. On the servers w/ the prob, see if you can remove/re-setup the email profile used by sql. If not, point to the active directory server rather than the exchange server during setup & see if the email account resolves, then. Root of the problem seemed that not all email acct's were propogating to all DC's, & sql servers that auth'd to one that couldn't resolve the sql mail account had prob's. Worth a shot, at least.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy