RE: SQL Mail

From: Mike Epprecht (SQL MVP) (mike_at_epprecht.net)
Date: 11/03/04 

Date: Wed, 3 Nov 2004 04:54:03 -0800

Hi

For SQL Mail to work, you need to have the service running under a domain
account as it uses MAPI. Unless it is a domain account, it won't work.

Check the archives of this NG for other 3rd party add-ins that use SMTP.

Regards
Mike

"Ants" wrote:

> 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: sql agent permission
    ... In terms of linked server configuration, all I said is that the sql ... account used to connect the remote standby server is the same account ... >>and I want to set up serverB as a standby server. ...
    (microsoft.public.sqlserver.security)
  • Re: sql problem
    ... Account # is the link field on ... The requirement is I have to come up with a report comparing the two ... customer tables to see if they are in sync. ... what I wanted to do was to get the SQL to return the "like" names ...
    (comp.databases.oracle.server)
  • Re: sql problem
    ... Account # is the link field on ... table1, table2@dblink where ....) ... customer tables to see if they are in sync. ... what I wanted to do was to get the SQL to return the "like" names ...
    (comp.databases.oracle.server)
  • Re: sql problem
    ... Account # is the link field on ... table1, table2@dblink where ....) ... customer tables to see if they are in sync. ... what I wanted to do was to get the SQL to return the "like" ...
    (comp.databases.oracle.server)
  • Re: Problems connecting to SQL Server
    ... Maximo is specifically stating that you must use the SA user ... to be the SQL 7 Product ID while scrounging around in some boxes. ... I will also try MDAC. ... And they specify the SA account. ...
    (microsoft.public.sqlserver.clients)