Hi Shannon -
From BOL
(ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlntsv9/html/ccb9605a-cfdb-4fc3-bc12-4730cea45e04.htm):
You cannot specify connection information (such as name and password)
for the SMTP server as part of the delivery channel configuration. The
operating system establishes connections to the SMTP server using the
service account.
Some possible alternatives (just speaking off the top of my head here
- I haven't tested them out)
1) Create a relay server to forward the message - probably same issues
here though.
2) Create a custom delivery protocol that can specify connection
information.
3) Explore the capabilities of your existing server. For example,
using the appropriate From field may work (doubtful but it's worth
looking into)
HTH...
--
Joe Webb
SQL Server MVP
http://www.sqlns.com ~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811 I support PASS, the Professional Association for SQL Server.
(
www.sqlpass.org)
[quoted text, click to view] On 11 Mar 2006 06:22:50 -0800, idelta@gmail.com wrote:
>Hi There
>
>I know it's a simple one but I have tried many variations and can't
>find where the SMTP protocol arguments are documented. How do I
>specify the username and password for this protocol?
>
>Here's the relevant part from my ICF file. Any help greatfully
>appreciated!
>
><DeliveryChannels>
> <!-- Multiple DeliveryChannel Elements Allowed -->
> <DeliveryChannel>
> <DeliveryChannelName>GoogleSMTP</DeliveryChannelName>
> <ProtocolName>SMTP</ProtocolName>
> <Arguments>
> <!-- Multiple Argument Elements Allowed -->
> <Argument>
> <Name>SmtpServer</Name>
> <Value>smtp.gmail.com</Value>
> </Argument>
> <Argument>
> <Name>BodyEncoding</Name>
> <Value>utf-16</Value>
> </Argument>
> <Argument>
> <Name>User</Name>
> <Value>MyUsername</Value>
> </Argument>
> <Argument>
> <Name>Password</Name>
> <Value>MyPassword</Value>
> </Argument>
> </Arguments>
> </DeliveryChannel>
> </DeliveryChannels>
>
>Cheers
