DataBase Mail Test

I have already checked that I can test the "Database Mail" via sending e-mail!

But I would like to ask if this e-mail could be with a digital signature?

If anyone knows the way I can do it,I would like to tell me how I can do it!!!!

Thank you very much

Nikos

I don't think it is possible for the database mail, as the individual third party or outlook based digital signature will not be able to decrypt of check such information. You might need to check on Exchange based forums in this case.

http://aspnet.4guysfromrolla.com/articles/022807-1.aspx fyi and it is only based for data.

Database Mail SMTP Settings

Hi All,
The Sql server will send emails when I am connected to it on the LAN but not
when I am remote or connected via a VPN. I am using the fully qualified
hostname for the smtp server in the database mail configuration.
Here is the error message:
The mail could not be sent to the recipients because of the mail server
failure. (Sending Mail using Account 3 (2007-06-08T16:36:07). Exception
Message: Cannot send mails to mail server. (The operation has timed out.).
Thanks for your help.
JN
On Jun 11, 4:11 pm, "JN" <j...@.ecconsulting.com> wrote:
> Hi All,
> The Sql server will send emails when I am connected to it on the LAN but not
> when I am remote or connected via a VPN. I am using the fully qualified
> hostname for the smtp server in the database mail configuration.
> Here is the error message:
> The mail could not be sent to the recipients because of the mail server
> failure. (Sending Mail using Account 3 (2007-06-08T16:36:07). Exception
> Message: Cannot send mails to mail server. (The operation has timed out.).
> Thanks for your help.
> JN
Hi
Can you ping/telnet the mail server?
Has the server been set to exclude connections via VPNs?
John
|||It looks like the problem is caused by the firewall blocking port 25 on the
smtp server.
Thanks.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:1181581014.987361.279000@.q69g2000hsb.googlegr oups.com...
> On Jun 11, 4:11 pm, "JN" <j...@.ecconsulting.com> wrote:
> Hi
> Can you ping/telnet the mail server?
> Has the server been set to exclude connections via VPNs?
> John
>

Database Mail SMTP Settings

Hi All,
The Sql server will send emails when I am connected to it on the LAN but not
when I am remote or connected via a VPN. I am using the fully qualified
hostname for the smtp server in the database mail configuration.
Here is the error message:
The mail could not be sent to the recipients because of the mail server
failure. (Sending Mail using Account 3 (2007-06-08T16:36:07). Exception
Message: Cannot send mails to mail server. (The operation has timed out.).
Thanks for your help.
JNOn Jun 11, 4:11 pm, "JN" <j...@.ecconsulting.com> wrote:
> Hi All,
> The Sql server will send emails when I am connected to it on the LAN but not
> when I am remote or connected via a VPN. I am using the fully qualified
> hostname for the smtp server in the database mail configuration.
> Here is the error message:
> The mail could not be sent to the recipients because of the mail server
> failure. (Sending Mail using Account 3 (2007-06-08T16:36:07). Exception
> Message: Cannot send mails to mail server. (The operation has timed out.).
> Thanks for your help.
> JN
Hi
Can you ping/telnet the mail server?
Has the server been set to exclude connections via VPNs?
John|||It looks like the problem is caused by the firewall blocking port 25 on the
smtp server.
Thanks.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:1181581014.987361.279000@.q69g2000hsb.googlegroups.com...
> On Jun 11, 4:11 pm, "JN" <j...@.ecconsulting.com> wrote:
>> Hi All,
>> The Sql server will send emails when I am connected to it on the LAN but
>> not
>> when I am remote or connected via a VPN. I am using the fully qualified
>> hostname for the smtp server in the database mail configuration.
>> Here is the error message:
>> The mail could not be sent to the recipients because of the mail server
>> failure. (Sending Mail using Account 3 (2007-06-08T16:36:07). Exception
>> Message: Cannot send mails to mail server. (The operation has timed
>> out.).
>> Thanks for your help.
>> JN
> Hi
> Can you ping/telnet the mail server?
> Has the server been set to exclude connections via VPNs?
> John
>

Database mail running on cluster error

Hi

we are running Sql 2005 enterprise edition sp1 on a 2 node cluster.When we send a test message via database mail we recieve the following error

Date 3/7/2007 9:11:18 AM
Log Database Mail (Database Mail Log)

Log ID 5
Process ID 2892
Last Modified 3/7/2007 9:11:18 AM
Last Modified By JDG\pssqlservice

Message
1) Exception Information
===================
Exception Type: System.NullReferenceException
Message: Object reference not set to an instance of an object.
Data: System.Collections.ListDictionaryInternal
TargetSite: Microsoft.SqlServer.Management.SqlIMail.Server.Objects.Account GetAccount(Int32)
HelpLink: NULL
Source: DatabaseMailEngine

StackTrace Information
===================
at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.DataAccessAdapter.GetAccount(Int32 accountID)
at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.SessionManager.GetAccount(Int32 accountID)
at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory.CreateSendMailCommand(DBSession dbSession)
at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory.CreateCommand(DBSession dbSession)
at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandRunner.Run(DBSession db)
at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.ThreadCallBack.MailOperation(Object o)

Does anybody know what could be the problem here?

Just a guess here: No known FROM address provided...|||we do have a reply address configured in the batabase mail configuration.so it is not this

Database Link supported with Oracle 9i?

I'm getting ready to link my SQL Server 2000 database to my legacy Oracle 9i
database via linked server and I was wondering if Microsoft supported such a
configuration.
tks
kmcclare@.hotmail.com
Yes, you can access Oracle from SQL Server via a linked server, provided you
have the required oracle drives (SQL*Net I believe) installed on the SQL
Server box. SQL Server Books Online has examples. See sp_addlinkedserver and
sp_addlinkedsrvlogin in SQL Server Books Online.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Ken McClaren" <kmcclare@.hotmail.com> wrote in message
news:e$FC1CmbEHA.904@.TK2MSFTNGP09.phx.gbl...
I'm getting ready to link my SQL Server 2000 database to my legacy Oracle 9i
database via linked server and I was wondering if Microsoft supported such a
configuration.
tks
kmcclare@.hotmail.com
|||These KB articles might help you incase you run into any issues.
Q280106 HOW TO: Set Up and Troubleshoot a Linked Server to Oracle in SQL
Q259959 INFO: Steps to Debug Connectivity Issues to an Oracle Server
Cheers,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
|||I've had a number of problems upgrading from 8i to 9i and in the end
I've stayed with the 8i client on the sql server and that works
perfectly. I'm sure I read somewhere that 9i hasn't been fully tested by
MS, although I might have dreamt that!
g.
http://www.sqlskunkworks.com
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

Database Link supported with Oracle 9i?

I'm getting ready to link my SQL Server 2000 database to my legacy Oracle 9i
database via linked server and I was wondering if Microsoft supported such a
configuration.
tks
kmcclare@.hotmail.comYes, you can access Oracle from SQL Server via a linked server, provided you
have the required oracle drives (SQL*Net I believe) installed on the SQL
Server box. SQL Server Books Online has examples. See sp_addlinkedserver and
sp_addlinkedsrvlogin in SQL Server Books Online.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Ken McClaren" <kmcclare@.hotmail.com> wrote in message
news:e$FC1CmbEHA.904@.TK2MSFTNGP09.phx.gbl...
I'm getting ready to link my SQL Server 2000 database to my legacy Oracle 9i
database via linked server and I was wondering if Microsoft supported such a
configuration.
tks
kmcclare@.hotmail.com|||These KB articles might help you incase you run into any issues.
Q280106 HOW TO: Set Up and Troubleshoot a Linked Server to Oracle in SQL
Q259959 INFO: Steps to Debug Connectivity Issues to an Oracle Server
Cheers,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.|||I've had a number of problems upgrading from 8i to 9i and in the end
I've stayed with the 8i client on the sql server and that works
perfectly. I'm sure I read somewhere that 9i hasn't been fully tested by
MS, although I might have dreamt that!
g.
http://www.sqlskunkworks.com
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!