|
|
You're in the
sql server dts
group:SMTP in my database server
sql server dts:
stored procedures.There is no way of having any MAPI compliant software installed on the productions database server,so I came up with the idea of installing an SMTP server and use the extended stored procedure introduced here(http://www.sqldev.net/xp/xpsmtp.htm). Now my database admin is nagging that I don't like to have something running in the SQL SERVER address space and my network admin is nagging that he dosen't want to have SMTP server installed on the production,because Microsoft dosen't recommand this. I just wondered whay you guys have ever done in terms of sending emails from your sql server.Is there a way of sending emails from sql server using another SMTP server on another box(same domain thought)?
Yes of course. SMTP service need not be installed on the SQL Server. In my
case, I have different mailing server, with SMTP on it. And I specify the SMTP server name as a parameter to the xp_smtp_sendmail stored procedure. -- Vyas, MVP (SQL Server) SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/ [quoted text, click to view] "Ray5531" <RayAll@microsft.com> wrote in message news:uU$Mz$PTFHA.3464@tk2msftngp13.phx.gbl... > I basically need to send emails from MY DTS packages and also some of my > stored procedures.There is no way of having any MAPI compliant software > installed on the productions database server,so I came up with the idea of > installing an SMTP server and use the extended stored procedure introduced > here(http://www.sqldev.net/xp/xpsmtp.htm). Now my database admin is nagging > that I don't like to have something running in the SQL SERVER address space > and my network admin is nagging that he dosen't want to have SMTP server > installed on the production,because Microsoft dosen't recommand this. I just > wondered whay you guys have ever done in terms of sending emails from your > sql server.Is there a way of sending emails from sql server using another > SMTP server on another box(same domain thought)? > >
Is there a firewall between your sql server and your mailing servers ? If
yes how come xp_smtp_sendmail opens up a TCP/IP socket to the mailing server? In my case there is a firewall between my database serevr and also external SMTP servers... Thanks for your help,I'm so stuck to this problem. Bye [quoted text, click to view] "Narayana Vyas Kondreddi" <answer_me@hotmail.com> wrote in message news:uggCK9WTFHA.3216@TK2MSFTNGP10.phx.gbl... > Yes of course. SMTP service need not be installed on the SQL Server. In my > case, I have different mailing server, with SMTP on it. And I specify the > SMTP server name as a parameter to the xp_smtp_sendmail stored procedure. > -- > Vyas, MVP (SQL Server) > SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/ > > > "Ray5531" <RayAll@microsft.com> wrote in message > news:uU$Mz$PTFHA.3464@tk2msftngp13.phx.gbl... >> I basically need to send emails from MY DTS packages and also some of my >> stored procedures.There is no way of having any MAPI compliant software >> installed on the productions database server,so I came up with the idea >> of >> installing an SMTP server and use the extended stored procedure >> introduced >> here(http://www.sqldev.net/xp/xpsmtp.htm). Now my database admin is > nagging >> that I don't like to have something running in the SQL SERVER address > space >> and my network admin is nagging that he dosen't want to have SMTP server >> installed on the production,because Microsoft dosen't recommand this. I > just >> wondered whay you guys have ever done in terms of sending emails from >> your >> sql server.Is there a way of sending emails from sql server using another >> SMTP server on another box(same domain thought)? >> >> > >
The equivalent to XPSMTP is available for DTS 2000 as a DTS Custom Task,
see: http://sqldev.net/dts/SMTPTask.htm GertD@SQLDev.Net Please reply only to the newsgroups. This posting is provided "AS IS" with no warranties, and confers no rights. You assume all risk for your use. Copyright © SQLDev.Net 1991-2005 All rights reserved. [quoted text, click to view] "Ray5531" <RayAll@microsft.com> wrote in message news:uU$Mz$PTFHA.3464@tk2msftngp13.phx.gbl... >I basically need to send emails from MY DTS packages and also some of my > stored procedures.There is no way of having any MAPI compliant software > installed on the productions database server,so I came up with the idea of > installing an SMTP server and use the extended stored procedure introduced > here(http://www.sqldev.net/xp/xpsmtp.htm). Now my database admin is > nagging > that I don't like to have something running in the SQL SERVER address > space > and my network admin is nagging that he dosen't want to have SMTP server > installed on the production,because Microsoft dosen't recommand this. I > just > wondered whay you guys have ever done in terms of sending emails from your > sql server.Is there a way of sending emails from sql server using another > SMTP server on another box(same domain thought)? > >
You would have to open port 25 (or if you use an other port which ever you
are using) for traffic from SQL to the SMTP server. You can also look at an SMTP relay server solution. GertD@SQLDev.Net Please reply only to the newsgroups. This posting is provided "AS IS" with no warranties, and confers no rights. You assume all risk for your use. Copyright © SQLDev.Net 1991-2005 All rights reserved. [quoted text, click to view] "Ray5531" <Ray5531@microsoft.com> wrote in message news:u7OgQnnTFHA.616@TK2MSFTNGP12.phx.gbl... > Is there a firewall between your sql server and your mailing servers ? If > yes how come xp_smtp_sendmail opens up a TCP/IP socket to the mailing > server? In my case there is a firewall between my database serevr and also > external SMTP servers... > > Thanks for your help,I'm so stuck to this problem. > > Bye > "Narayana Vyas Kondreddi" <answer_me@hotmail.com> wrote in message > news:uggCK9WTFHA.3216@TK2MSFTNGP10.phx.gbl... >> Yes of course. SMTP service need not be installed on the SQL Server. In >> my >> case, I have different mailing server, with SMTP on it. And I specify the >> SMTP server name as a parameter to the xp_smtp_sendmail stored procedure. >> -- >> Vyas, MVP (SQL Server) >> SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/ >> >> >> "Ray5531" <RayAll@microsft.com> wrote in message >> news:uU$Mz$PTFHA.3464@tk2msftngp13.phx.gbl... >>> I basically need to send emails from MY DTS packages and also some of my >>> stored procedures.There is no way of having any MAPI compliant software >>> installed on the productions database server,so I came up with the idea >>> of >>> installing an SMTP server and use the extended stored procedure >>> introduced >>> here(http://www.sqldev.net/xp/xpsmtp.htm). Now my database admin is >> nagging >>> that I don't like to have something running in the SQL SERVER address >> space >>> and my network admin is nagging that he dosen't want to have SMTP server >>> installed on the production,because Microsoft dosen't recommand this. I >> just >>> wondered whay you guys have ever done in terms of sending emails from >>> your >>> sql server.Is there a way of sending emails from sql server using >>> another >>> SMTP server on another box(same domain thought)? >>> >>> >> >> > >
Is that relay server for free?
Where should I get it from? Thanks fro your reply. [quoted text, click to view] "Gert E.R. Drapers" <GertD@SQLDevNet> wrote in message news:u%23VC1B3TFHA.2872@TK2MSFTNGP14.phx.gbl... > You would have to open port 25 (or if you use an other port which ever you > are using) for traffic from SQL to the SMTP server. You can also look at > an SMTP relay server solution. > > GertD@SQLDev.Net > > Please reply only to the newsgroups. > This posting is provided "AS IS" with no warranties, and confers no > rights. > You assume all risk for your use. > Copyright © SQLDev.Net 1991-2005 All rights reserved. > > "Ray5531" <Ray5531@microsoft.com> wrote in message > news:u7OgQnnTFHA.616@TK2MSFTNGP12.phx.gbl... >> Is there a firewall between your sql server and your mailing servers ? If >> yes how come xp_smtp_sendmail opens up a TCP/IP socket to the mailing >> server? In my case there is a firewall between my database serevr and >> also external SMTP servers... >> >> Thanks for your help,I'm so stuck to this problem. >> >> Bye >> "Narayana Vyas Kondreddi" <answer_me@hotmail.com> wrote in message >> news:uggCK9WTFHA.3216@TK2MSFTNGP10.phx.gbl... >>> Yes of course. SMTP service need not be installed on the SQL Server. In >>> my >>> case, I have different mailing server, with SMTP on it. And I specify >>> the >>> SMTP server name as a parameter to the xp_smtp_sendmail stored >>> procedure. >>> -- >>> Vyas, MVP (SQL Server) >>> SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/ >>> >>> >>> "Ray5531" <RayAll@microsft.com> wrote in message >>> news:uU$Mz$PTFHA.3464@tk2msftngp13.phx.gbl... >>>> I basically need to send emails from MY DTS packages and also some of >>>> my >>>> stored procedures.There is no way of having any MAPI compliant software >>>> installed on the productions database server,so I came up with the idea >>>> of >>>> installing an SMTP server and use the extended stored procedure >>>> introduced >>>> here(http://www.sqldev.net/xp/xpsmtp.htm). Now my database admin is >>> nagging >>>> that I don't like to have something running in the SQL SERVER address >>> space >>>> and my network admin is nagging that he dosen't want to have SMTP >>>> server >>>> installed on the production,because Microsoft dosen't recommand this. I >>> just >>>> wondered whay you guys have ever done in terms of sending emails from >>>> your >>>> sql server.Is there a way of sending emails from sql server using >>>> another >>>> SMTP server on another box(same domain thought)? >>>> >>>> >>> >>> >> >> > >
There are free relay server, see
http://www.google.com/search?sourceid=navclient&ie=UTF-8&rls=GGLD,GGLD:2004-25,GGLD:en&q=SMTP+relay+server GertD@SQLDev.Net Please reply only to the newsgroups. This posting is provided "AS IS" with no warranties, and confers no rights. You assume all risk for your use. Copyright © SQLDev.Net 1991-2005 All rights reserved. [quoted text, click to view] "Ray5531" <RayAll@microsft.com> wrote in message news:OWlo2h3TFHA.580@TK2MSFTNGP15.phx.gbl... > Is that relay server for free? > Where should I get it from? > > Thanks fro your reply. > > "Gert E.R. Drapers" <GertD@SQLDevNet> wrote in message > news:u%23VC1B3TFHA.2872@TK2MSFTNGP14.phx.gbl... >> You would have to open port 25 (or if you use an other port which ever >> you are using) for traffic from SQL to the SMTP server. You can also look >> at an SMTP relay server solution. >> >> GertD@SQLDev.Net >> >> Please reply only to the newsgroups. >> This posting is provided "AS IS" with no warranties, and confers no >> rights. >> You assume all risk for your use. >> Copyright © SQLDev.Net 1991-2005 All rights reserved. >> >> "Ray5531" <Ray5531@microsoft.com> wrote in message >> news:u7OgQnnTFHA.616@TK2MSFTNGP12.phx.gbl... >>> Is there a firewall between your sql server and your mailing servers ? >>> If yes how come xp_smtp_sendmail opens up a TCP/IP socket to the >>> mailing server? In my case there is a firewall between my database >>> serevr and also external SMTP servers... >>> >>> Thanks for your help,I'm so stuck to this problem. >>> >>> Bye >>> "Narayana Vyas Kondreddi" <answer_me@hotmail.com> wrote in message >>> news:uggCK9WTFHA.3216@TK2MSFTNGP10.phx.gbl... >>>> Yes of course. SMTP service need not be installed on the SQL Server. In >>>> my >>>> case, I have different mailing server, with SMTP on it. And I specify >>>> the >>>> SMTP server name as a parameter to the xp_smtp_sendmail stored >>>> procedure. >>>> -- >>>> Vyas, MVP (SQL Server) >>>> SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/ >>>> >>>> >>>> "Ray5531" <RayAll@microsft.com> wrote in message >>>> news:uU$Mz$PTFHA.3464@tk2msftngp13.phx.gbl... >>>>> I basically need to send emails from MY DTS packages and also some of >>>>> my >>>>> stored procedures.There is no way of having any MAPI compliant >>>>> software >>>>> installed on the productions database server,so I came up with the >>>>> idea of >>>>> installing an SMTP server and use the extended stored procedure >>>>> introduced >>>>> here(http://www.sqldev.net/xp/xpsmtp.htm). Now my database admin is >>>> nagging >>>>> that I don't like to have something running in the SQL SERVER address >>>> space >>>>> and my network admin is nagging that he dosen't want to have SMTP >>>>> server >>>>> installed on the production,because Microsoft dosen't recommand this. >>>>> I >>>> just >>>>> wondered whay you guys have ever done in terms of sending emails from >>>>> your >>>>> sql server.Is there a way of sending emails from sql server using >>>>> another >>>>> SMTP server on another box(same domain thought)? >>>>> >>>>> >>>> >>>> >>> >>> >> >> > >
Thanks Gert,
It really helped. [quoted text, click to view] "Gert E.R. Drapers" <GertD@SQLDevNet> wrote in message news:ORno74CUFHA.752@TK2MSFTNGP10.phx.gbl... > There are free relay server, see > http://www.google.com/search?sourceid=navclient&ie=UTF-8&rls=GGLD,GGLD:2004-25,GGLD:en&q=SMTP+relay+server > > GertD@SQLDev.Net > > Please reply only to the newsgroups. > This posting is provided "AS IS" with no warranties, and confers no > rights. > You assume all risk for your use. > Copyright © SQLDev.Net 1991-2005 All rights reserved. > > "Ray5531" <RayAll@microsft.com> wrote in message > news:OWlo2h3TFHA.580@TK2MSFTNGP15.phx.gbl... >> Is that relay server for free? >> Where should I get it from? >> >> Thanks fro your reply. >> >> "Gert E.R. Drapers" <GertD@SQLDevNet> wrote in message >> news:u%23VC1B3TFHA.2872@TK2MSFTNGP14.phx.gbl... >>> You would have to open port 25 (or if you use an other port which ever >>> you are using) for traffic from SQL to the SMTP server. You can also >>> look at an SMTP relay server solution. >>> >>> GertD@SQLDev.Net >>> >>> Please reply only to the newsgroups. >>> This posting is provided "AS IS" with no warranties, and confers no >>> rights. >>> You assume all risk for your use. >>> Copyright © SQLDev.Net 1991-2005 All rights reserved. >>> >>> "Ray5531" <Ray5531@microsoft.com> wrote in message >>> news:u7OgQnnTFHA.616@TK2MSFTNGP12.phx.gbl... >>>> Is there a firewall between your sql server and your mailing servers ? >>>> If yes how come xp_smtp_sendmail opens up a TCP/IP socket to the >>>> mailing server? In my case there is a firewall between my database >>>> serevr and also external SMTP servers... >>>> >>>> Thanks for your help,I'm so stuck to this problem. >>>> >>>> Bye >>>> "Narayana Vyas Kondreddi" <answer_me@hotmail.com> wrote in message >>>> news:uggCK9WTFHA.3216@TK2MSFTNGP10.phx.gbl... >>>>> Yes of course. SMTP service need not be installed on the SQL Server. >>>>> In my >>>>> case, I have different mailing server, with SMTP on it. And I specify >>>>> the >>>>> SMTP server name as a parameter to the xp_smtp_sendmail stored >>>>> procedure. >>>>> -- >>>>> Vyas, MVP (SQL Server) >>>>> SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/ >>>>> >>>>> >>>>> "Ray5531" <RayAll@microsft.com> wrote in message >>>>> news:uU$Mz$PTFHA.3464@tk2msftngp13.phx.gbl... >>>>>> I basically need to send emails from MY DTS packages and also some of >>>>>> my >>>>>> stored procedures.There is no way of having any MAPI compliant >>>>>> software >>>>>> installed on the productions database server,so I came up with the >>>>>> idea of >>>>>> installing an SMTP server and use the extended stored procedure >>>>>> introduced >>>>>> here(http://www.sqldev.net/xp/xpsmtp.htm). Now my database admin is >>>>> nagging >>>>>> that I don't like to have something running in the SQL SERVER address >>>>> space >>>>>> and my network admin is nagging that he dosen't want to have SMTP >>>>>> server >>>>>> installed on the production,because Microsoft dosen't recommand this. >>>>>> I >>>>> just >>>>>> wondered whay you guys have ever done in terms of sending emails from >>>>>> your >>>>>> sql server.Is there a way of sending emails from sql server using >>>>>> another >>>>>> SMTP server on another box(same domain thought)? >>>>>> >>>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > >
One thing about the SMTPTask is that it expires as of June 2005. It is
mentioned at the very bottom of page. I don't know if that means it stops working, or what. [quoted text, click to view] "Gert E.R. Drapers" wrote:
> The equivalent to XPSMTP is available for DTS 2000 as a DTS Custom Task, > see: > http://sqldev.net/dts/SMTPTask.htm > > GertD@SQLDev.Net > > Please reply only to the newsgroups. > This posting is provided "AS IS" with no warranties, and confers no rights. > You assume all risk for your use. > Copyright © SQLDev.Net 1991-2005 All rights reserved. > > "Ray5531" <RayAll@microsft.com> wrote in message > news:uU$Mz$PTFHA.3464@tk2msftngp13.phx.gbl... > >I basically need to send emails from MY DTS packages and also some of my > > stored procedures.There is no way of having any MAPI compliant software > > installed on the productions database server,so I came up with the idea of > > installing an SMTP server and use the extended stored procedure introduced > > here(http://www.sqldev.net/xp/xpsmtp.htm). Now my database admin is > > nagging > > that I don't like to have something running in the SQL SERVER address > > space > > and my network admin is nagging that he dosen't want to have SMTP server > > installed on the production,because Microsoft dosen't recommand this. I > > just > > wondered whay you guys have ever done in terms of sending emails from your > > sql server.Is there a way of sending emails from sql server using another > > SMTP server on another box(same domain thought)? > > > > > >
Here is a script that can be added to DTS to send mail. It is what the =
below EXE is made out of but with a COM wrapper. Stay tuned and I will build a COM wrapper for it or you can use it as = is. You can easily modify it to meet our needs in DTS. CDO is = installed on all Windows systems from 2000 on. function SendMail(strTo, strFrom, strSubject,strText,strSMTPServer) 'As = Boolean On Error Resume Next SendMail =3D True Set objEmail =3D CreateObject("CDO.Message") If Err =3D 0 Then objEmail.From =3D strFrom=20 objEmail.To =3D strTo=20 objEmail.Subject =3D strSubject objEmail.Textbody =3D strText = objEmail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/conf= iguration/sendusing") =3D 2 = objEmail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/conf= iguration/smtpserver") =3D strSMTPServer = objEmail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/conf= iguration/smtpserverport") =3D 25 objEmail.Configuration.Fields.Update objEmail.Send If Err <> 0 Then SendMail =3D False End If End If End Function --=20 Jim Vierra "Perry Provost" <Perry Provost@discussions.microsoft.com> wrote in = message news:A13EFC31-BA76-42FE-A9A5-91773E73A42F@microsoft.com... [quoted text, click to view] > One thing about the SMTPTask is that it expires as of June 2005. It is =
> mentioned at the very bottom of page. I don't know if that means it = stops=20 > working, or what. >=20 > "Gert E.R. Drapers" wrote: >=20 >> The equivalent to XPSMTP is available for DTS 2000 as a DTS Custom = Task,=20 >> see: >> http://sqldev.net/dts/SMTPTask.htm >>=20 >> GertD@SQLDev.Net >>=20 >> Please reply only to the newsgroups. >> This posting is provided "AS IS" with no warranties, and confers no = rights. >> You assume all risk for your use. >> Copyright =C2=A9 SQLDev.Net 1991-2005 All rights reserved. >>=20 >> "Ray5531" <RayAll@microsft.com> wrote in message=20 >> news:uU$Mz$PTFHA.3464@tk2msftngp13.phx.gbl... >> >I basically need to send emails from MY DTS packages and also some = of my >> > stored procedures.There is no way of having any MAPI compliant = software >> > installed on the productions database server,so I came up with the = idea of >> > installing an SMTP server and use the extended stored procedure = introduced >> > here(http://www.sqldev.net/xp/xpsmtp.htm). Now my database admin is = >> > nagging >> > that I don't like to have something running in the SQL SERVER = address=20 >> > space >> > and my network admin is nagging that he dosen't want to have SMTP = server >> > installed on the production,because Microsoft dosen't recommand = this. I=20 >> > just >> > wondered whay you guys have ever done in terms of sending emails = from your >> > sql server.Is there a way of sending emails from sql server using = another >> > SMTP server on another box(same domain thought)? >> > >> >=20 >>=20 >>=20
Jim,Thanks alot=20
It helps a lot . [quoted text, click to view] "Jim Vierra" <jvierra@msn.com> wrote in message = Here is a script that can be added to DTS to send mail. It is what =news:OKU5Bi5UFHA.3544@TK2MSFTNGP10.phx.gbl... the below EXE is made out of but with a COM wrapper. Stay tuned and I will build a COM wrapper for it or you can use it as = is. You can easily modify it to meet our needs in DTS. CDO is = installed on all Windows systems from 2000 on. function SendMail(strTo, strFrom, strSubject,strText,strSMTPServer) = 'As Boolean On Error Resume Next SendMail =3D True Set objEmail =3D CreateObject("CDO.Message") If Err =3D 0 Then objEmail.From =3D strFrom=20 objEmail.To =3D strTo=20 objEmail.Subject =3D strSubject objEmail.Textbody =3D strText = objEmail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/conf= iguration/sendusing") =3D 2 = objEmail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/conf= iguration/smtpserver") =3D strSMTPServer = objEmail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/conf= iguration/smtpserverport") =3D 25 objEmail.Configuration.Fields.Update objEmail.Send If Err <> 0 Then SendMail =3D False End If End If End Function --=20 Jim Vierra "Perry Provost" <Perry Provost@discussions.microsoft.com> wrote in = message news:A13EFC31-BA76-42FE-A9A5-91773E73A42F@microsoft.com... [quoted text, click to view] > One thing about the SMTPTask is that it expires as of June 2005. It =
is=20 > mentioned at the very bottom of page. I don't know if that means it = stops=20 > working, or what. >=20 > "Gert E.R. Drapers" wrote: >=20 >> The equivalent to XPSMTP is available for DTS 2000 as a DTS Custom = Task,=20 >> see: >> http://sqldev.net/dts/SMTPTask.htm >>=20 >> GertD@SQLDev.Net >>=20 >> Please reply only to the newsgroups. >> This posting is provided "AS IS" with no warranties, and confers no = rights. >> You assume all risk for your use. >> Copyright =C2=A9 SQLDev.Net 1991-2005 All rights reserved. >>=20 >> "Ray5531" <RayAll@microsft.com> wrote in message=20 >> news:uU$Mz$PTFHA.3464@tk2msftngp13.phx.gbl... >> >I basically need to send emails from MY DTS packages and also some = of my >> > stored procedures.There is no way of having any MAPI compliant = software >> > installed on the productions database server,so I came up with = the idea of >> > installing an SMTP server and use the extended stored procedure = introduced >> > here(http://www.sqldev.net/xp/xpsmtp.htm). Now my database admin = is=20 >> > nagging >> > that I don't like to have something running in the SQL SERVER = address=20 >> > space >> > and my network admin is nagging that he dosen't want to have SMTP = server >> > installed on the production,because Microsoft dosen't recommand = this. I=20 >> > just >> > wondered whay you guys have ever done in terms of sending emails = from your >> > sql server.Is there a way of sending emails from sql server using = another >> > SMTP server on another box(same domain thought)? >> > >> >=20 >>=20 >>=20
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |