We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

SQL 2005 Alert Not Sending

Medium Priority
2,040 Views
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

Comment
Watch Question

Brendt HessSenior DBA
CERTIFIED EXPERT

Commented:
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.

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

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Commented:
Under Database Mail / Manage Profile Security set the Profile to be public.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.