SQL 2005 Alert Not Sending

Posted on 2009-02-17
Last Modified: 2012-05-06
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

Question by:Jiggens
    LVL 32

    Expert Comment

    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.

    LVL 1

    Accepted Solution

    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

    Expert Comment

    Under Database Mail / Manage Profile Security set the Profile to be public.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    I had a question today where the user wanted to know how to delete an SSL Certificate, so I thought that I would quickly add this How to! Article for your reference. WHY WOULD YOU WANT TO DELETE A CERTIFICATE? 1. If an incorrect certificate was …
    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
    This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now