Re: SQL Mail

From: Ants (antzj_at_hotmail.com)
Date: 11/03/04 

Date: Wed, 3 Nov 2004 16:17:25 -0000

thanks for the response
i managed to get it working though.. not sure exactly what i did but suspect
the following...
local account syncd with same password as domain account..
added various permissions to account mailboxes etc.

restared the sqlmail and can send ok using following script
EXEC xp_sendmail 'email@address' , 'message' etc

no the other problem i'm facing is this.
I have another mailbox on the domain XXX called pete.. tommy's mailbox has
'sent on behalf permissions for pete's...
my initial plan.. to be able to create a sql script to do a 'send from'
using xp_sendmail

(exec xp_sendmail @from='pete's email', @recipient='anyemail' etc )
thanks again

"Ants" <antzj@hotmail.com> wrote in message
news:O3utIJawEHA.3808@TK2MSFTNGP15.phx.gbl...
> Hi,
> currently have a problem...
> ServerA (standalone non domain member running Win2k and SQL 2k) and
> ServerB (Exchange200 Server on Domain called XXX)
>
> need to be able to send email via SQL from ServerB to ServerA.
>
> Userid on local serverB: tommy - password: tommy
> userid on domain XXX: tommy - password: tommy
>
> MSSQLserver and agent service on ServerB started with local account tommy
>
> can open mailbox via outlook no problem on serverB using domain XXX's
> account: tommy
>
> cannot do an xp_sendmail from sql stransact. can i supply userid, password
> and domain name with help of stored procedure?
> any ideas?
> thanks in advance
>
>

Relevant Pages

  • Re: Local email
    ... Yes the user email account properties have two addresses, ... being the .local account. ... There's one mailbox per user, ...
    (microsoft.public.windows.server.sbs)
  • RE: SQL Mail
    ... For SQL Mail to work, you need to have the service running under a domain ... Unless it is a domain account, ... > need to be able to send email via SQL from ServerB to ServerA. ...
    (microsoft.public.sqlserver.server)
  • Re: Domain Account used for IIS6 Anonymous Account Risks?
    ... In general there aren't any "known" vulnerabilities in Windows, IIS or probably your application that haven't been patched. ... but unless the vendor can explain why the application needs Administrator privileges, your answer should be that your security policy calls for least privilege, and the vendor should tell you what the actual privileges required of the application are. ... some of their own webpages) then IIS can connect to serverB using the ... domain\xyzweb account, and that account has full privileges on serverB ...
    (microsoft.public.inetserver.iis.security)
  • RE: Copy Database Wizard Fails to Copy Files
    ... I had the exact same problem until I executed the package under an account ... Regards, ... > simple table) on ServerA to ServerB. ... > Put the database Test in single user mode.......Ok ...
    (microsoft.public.sqlserver.dts)
  • Re: Domain Account used for IIS6 Anonymous Account Risks?
    ... If someone can get IIS to execute arbitrary code (e.g. by uploading ... some of their own webpages) then IIS can connect to serverB using the ... domain\xyzweb account, and that account has full privileges on serverB ... Knowing all of this and knowing that as far as the application vendor, ...
    (microsoft.public.inetserver.iis.security)