January 16, 2007 at 12:06 pm
I am experiencing the same problem that was previously described in thread 247928. The poster indicates that the problem disappeared as suddenly as it appeared!
When I try to use sp_Send_DBMail with a query, I get an "Unable to get information about NT User.....". With the @Query parameter, the procedure works fine.
The hypothesis is that their is a problem with the query "EXECUTING AS".
I also see the problem in xp_Logininfo - exec xp_Logininfo 'DOMAIN\ID','all' returns the same error.
Something has gone awry, most likely in the domain world. Any ideas what?
January 19, 2007 at 1:36 pm
Login might be expired...
Check the login properties...
MohammedU
Microsoft SQL Server MVP
January 19, 2007 at 1:55 pm
We have made some progress. We had been using a local account to run the SQL engine. Switching to a domain account made the problem vanish!
This indicates a trust/domain networking issue.
We are now continuing to investigate how to make it work with a local account running SQL Server.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply