After SP3a install, xp_sendmail crashing

From: Eric Inman (EricMInman_at_msn.com)
Date: 09/17/04 

Date: 17 Sep 2004 07:27:30 -0700

Box Win2000
SQLServer 8.00.8??

After installing SP3a, the only job we had that used xp_sendmail was
crashing. The problem ended up being a domain user that had sqlserver
login permissions but that no longer existed on the doamin. The name
was Domain\Administrator and was a user account. After removing the
account the xp_sendmail app worked fine. This job was not using this
account at all.

I was just wondering if anyone could explain this to me?

Is it something with the name administrator? Is this one of the
security fixes to prevent invalid users??

Thanks for your time,
Eric

Relevant Pages

  • RE: SQL Agent wont start
    ... Both SQLServer and SQLAgent are now run under the Local System ... Windows Admin account which was used to start these services. ... Interestingly, when a sysadmin account ...
    (microsoft.public.sqlserver.server)
  • Re: Intranet connect to SQLServer Under users account.
    ... >> I have set up the Web site so that it uses Windows Integrated security, ... >> On a test webpage I can output the user account being used: ... >> SQLServer using their account. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: SBS 2003 server/SQLServer 2000 SP3a service fails to load locally
    ... Resetting the log doesn't change authentication. ... Does the account has a password ... The only error I get is an authentication process problem. ... > the SQLServer Enterprise application and on the service itself. ...
    (microsoft.public.sqlserver.server)
  • FIXED! xp_sendmail works from QA but not from DTS package
    ... >> Do you use the same account for running both your SQLServer service and your ... >> SQLAgent service? ... then try to set SQLserver to use the same account ...
    (microsoft.public.sqlserver.server)
  • Re: Access to sql2005
    ... When you run the site in the debugger, it could run under your account, ... When you run it "for real" it runs under a local ASPNET ... connect to SqlServer using a specified sqlserver account. ...
    (microsoft.public.dotnet.framework.aspnet)