SQL Mail

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

Date: Wed, 3 Nov 2004 12:40:19 -0000

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 Mail
    ... a popular free SMTP extended stored procedure is ... > need to be able to send email via SQL from ServerB to ServerA. ... > Userid on local serverB: tommy - password: tommy ...
    (microsoft.public.sqlserver.server)
  • 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: 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)
  • how to synchronize nt accounts after database restore on a different server?
    ... I had to move/restore one of our dbs from ServerA (sql 2k on nt5 box) to ... Windows authentication is used to authenticate users to the server. ... The SQL ServerB does not have an account for Domain\Staff (under ...
    (microsoft.public.sqlserver.programming)
  • Re: Getting Msg 18456 in referencing a database from a linked server
    ... to authenticate to serverb. ... You should try adding your linked server passing an SQL ... authentication/Valid Windows account depending on your security type. ...
    (microsoft.public.sqlserver.server)
Loading