Database Mail

Question

Post reply

Database Mail

2Tall

SSChampion

Points: 14644
More actions
March 30, 2009 at 5:12 am

#128914

The application were are running uses SQL Server Authentication. The connection account to SQL is contained with the apps config file.
Database Mail is configured and test emails send OK. If we attempt to send via the app the following error is generated:
Msg 15404, Level 16, State 10, Procedure xp_logininfo, Line 62
Could not obtain information about Windows NT group/user 'app_account', error code 0xffff0002.
I have investigated this error and found article:
If account_name is specified, xp_logininfo reports the highest privilege level of the specified Windows user or group. If a Windows user has access as both a system administrator and as a domain user, it will be reported as a system administrator. If the user is a member of multiple Windows groups of equal privilege level, only the group that was first granted access to SQL Server is reported.
If account_name is a valid Windows user or group that is not associated with a SQL Server login, an empty result set is returned. If account_name cannot be identified as a valid Windows user or group, an error message is returned.
The account 'sa' cannot be identified as a valid windows user or group. You need to set this up to use a windows account... something that can send email.
If I grant the account server role 'sys admin' then the error appears resolved, however I would rather not grant the account elevated privileges just to send email.
Any thoughts as to how I might resolve?
Thanks,
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

2Tall SSChampion Points: 14644 More actions · Answer 1

I have run:

EXEC msdb.sys.sp_helprolemember 'DatabaseMailUserRole';

The account in question is a member.

I then ran:

EXEC msdb.dbo.sysmail_help_principalprofile_sp;

The account is not associated to the database mail profile (there is only one profile).

Anyone advise on resolving this?

Thanks,

Phil.

-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

Tommy Cooper

2Tall SSChampion Points: 14644 More actions · Answer 2

OK I have now resolved. I amended the profile security.

Thanks,

Phil.

-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

Tommy Cooper

jswong05 Hall of Fame Points: 3553 More actions · Answer 3

That is a bogus error message I got too. The profile has to be public or the correct principal.

Jason
http://dbace.us
😛