• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2019
  • Last Modified:

SQL 2005 Alert Not Sending

I am trying to run a stored job from within my application, every time i run the e-mail alert is not sent and in the log i have the following error..

If i send from DB Mail it works fine, When i try executing the job it runs but no e-mail is sent.

My customer trigger works within the application but the application built ones get the error below

Msg 15404, Level 16, State 10, Procedure xp_logininfo, Line 62
Could not obtain information about Windows NT group/user 'sa', error code 0xffff0002.

Any ideas what it could be

1 Solution
Brendt HessSenior DBACommented:
To send email, the user running the process must be a Windows user.... and the 'sa' login is not a windows user.  However you are setting these up when you deploy it, you are using the 'sa' login, and not a Windows domain account.

As noted in the info on xp_logininfo:

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.

Bingo.  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.

JiggensAuthor Commented:
How do i do that, this are custom stored procedures that were created by the application.  They work on other servers of sql 2005 as i have other customers, but for some reason this one server which is SQL2005 on Server 2008 is different
Under Database Mail / Manage Profile Security set the Profile to be public.

Featured Post

Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now