Tuesday, March 6, 2012
64-bit SQL Server, DTS and Mail
Any feedback on 64-bit SQL Server? Is anyone using it? Any positive results or problems experienced
I read in the BOL that DTS componenets are not included in the current release. I see this as a major hurdle to overcome - yes packages can be run from a 32-bit server, but this would have an assoicated downside.
Also, SQL Mail is not supported. Can anyone at MS explain why SQL Agent Mail is supported but not SQL Mail? And why is Outlook Express the mail client and not Outlook
Finally, will DTS and SQL Mail be fully supported in future releases on the 64-bit platformThe primary reason for no SQLMail support is that SQLMail requires Extended
MAPI which was not ported to 64bit.
Agent Mail is supported because we did some work on it to support Simple
MAPI which is included with Outlook Express. It is not possible to run
Simple MAPI inside SQL Server as an XP hence this solution does not work
for SQLMail.
The reasons for Outlook Express and not Outlook are:
1/ There is no 64bit version of Outlook, hence no 64bit Simple/Extended MAPI
included with it.
2/ Even under 32bit once Extended MAPI is installed Simple MAPI no longer
works in a manner which allows it to be used by Agent Mail.
We aim to resolve these in a future release.
-Euan
Please reply only to the newsgroup so that others can benefit. When posting,
please state the version of SQL Server being used and the error number/exact
error message text received, if any.
This posting is provided "AS IS" with no warranties, and confers no rights.
"Elliot Wien" <anonymous@.discussions.microsoft.com> wrote in message
news:B0C44188-50B4-4461-9E54-D53AE943B019@.microsoft.com...
> Greetings all
> Any feedback on 64-bit SQL Server? Is anyone using it? Any positive
results or problems experienced?
> I read in the BOL that DTS componenets are not included in the current
release. I see this as a major hurdle to overcome - yes packages can be run
from a 32-bit server, but this would have an assoicated downside.
> Also, SQL Mail is not supported. Can anyone at MS explain why SQL Agent
Mail is supported but not SQL Mail? And why is Outlook Express the mail
client and not Outlook?
> Finally, will DTS and SQL Mail be fully supported in future releases on
the 64-bit platform?
>
64-Bit SQL Server 2005 (Enterprise), SQL Agent Notifications and Database Mail
We have database mail configured on our 64-Bit SQL Server Enterprise 2005 (SP1) and are able to send test messages from the context menu that appears when selecting database mail component.
However for some reason when a SQL Agent Job fails, no emails are sent to the 'operator' that has been defined for the job. I have confirmed that we have the operators correctly configured. We also have a small SQL Agent Job that just sends a test email via the sp_send_dbmail command and that works properly. However if I deliberately create a malformed parameter in the sp_send_dbmail command to 'break' it...no notification of a job failure message is sent.
I have verified that the service_broker component is enabled...and the status of database mail in the MSDB database is 'started.'
We have setup several other 32-bit SQL Server 2005 systems using database mail...and they all work flawlessly.
After reviewing existing message posts...I am unsure if there is a problem with database mail on a 64-bit SQL Server box. Some say 'yes' other say 'no'.
There are several MSDN notes about the problem...however these appeared prior to the release of SP1 of SQL Server 2005.
Thank you for your assistance.
...cordell...
SQL Database mail which relies on using your SMTP server instead of a mail client to send out email, so check whether that service is started as a first point of check.|||yes..our Exchange server works properly and is running. I have several other 32-bit SQL Server 2005 system that are able to send email (using SQL Database Mail) without issue.
Maybe I have misunderstood your reply and missing something obvious...since this is a pretty basic question.
Thank you.
...cordell...
|||As I read KB article 908360 it says that SQL Server 2005 (x64) is not integrated with Database Mail or with SQL Mail in Microsoft SQL Server 2005 64-bit editions.
But then there is a note that says, "Note In SQL Server 2005 Service Pack 1 (SP1), you can use SQL Server Agent to interact with Database Mail as the mailing system on 64-bit operating systems."
We have SP1 installed on our x64 SQL Servers but Database Mail still doesn't work with SQL Agent. The history for any job that fails says, " NOTE: Failed to notify 'DB_Engineering' via email."
QUESTIONS:
Is it correct to assume that there is one and only one SP1 package for SQL Server 2005? Our assumption is that the currently available SP1 is for both 32 bit and 64 bit SQL Server 2005 installations.
Does a separate 64 bit SP1 exist somewhere?
Are there special instructions required for setting up database Mail on SQL Server 2005 (x64) SP1 without using Outlook Express? If so, we haven't found them yet.
Does this article really mean that Outlook Express is currently the only workaround for using Email Notifications on a 64 bit SQL Server? (We do not activate Outlook Express -- or even SMTP -- on Production SQL Servers. SMTP exists on its own machine.)
Please advise,
Thanks,
Ernie