November 28, 2006 at 12:37 pm
Has anyone got this working.
I keep reading it can work
Even if i click on sql server agent mail session mail profile i get
18-38 sql mail does not work with 64 bit version of SQL Server
So how do you send email when using a job or an alert.
November 28, 2006 at 1:42 pm
http://www.only4gurus.net/miscellaneous/sqlsrv_programming.pdf
Information below is coming from the link mentioned above:
The computer running SQL Server must be set up as an e-mail client. SQL Server Enterprise Manager is used to assign an e-mail account and password to the SQL Server installation. The mail component of SQL Server can then be enabled to start automatically when the SQL Server Agent service is started. Alternatively, the mail component can be started and stopped at will using either SQL Server Enterprise Manager, or the xp_startmail, xp_stopmail, and xp_sendmail stored procedures.
To setup the mail infrastructure you must create a mail profile and SQL Server 2000 Service Pack 2 must be installed."
Once everything is set up, an email from the sql server can be sent by executing the following 3 statements:
EXEC master..xp_startmail -- starts mail
-- Substitute proper recipient email, subject and message
-- sends email
EXEC master..xp_sendmail @recipients = 'tracey@hotmail.com',
@subject = 'SQL Server Report',
@message = 'Hello Martin'
EXEC master..xp_stopmail -- stops mail
November 28, 2006 at 2:47 pm
I have the outlook set up on the SQL Server.
Now in SQL Query...
As soon as i do this
EXEC master..xp_startmail
Server: Msg 18038, Level 16, State 1, Line 0
SQL Mail does not work with the 64-bit version of SQL Server
November 28, 2006 at 3:10 pm
Hmm ... don't know much more about email sending, but it appears that the error message states the problem.
November 28, 2006 at 11:14 pm
From what I have read only Database Mail is supported when using SQL 2005 64 bit edition.
Since SQL is running as 64bit it is not viable for it to communicate with the 32bit mail client software that may be installed. SQL Mail requires a mail profile as configured using a mail client (eg Outlook).
Database Mail does not need mail client software to be installed on the server.
Once you have Database Mail operational, use sp_send_dbmail rather than xp_sendmail.
November 29, 2006 at 7:37 am
I believe only Database Mail (as mentioned above) works in 64-bit. SQLMail is a leftover from SQL 2000 and only runs on 32-bit.
February 12, 2009 at 5:00 pm
It has been a long time since the last message. I still have a question: How does the Agent email in 64-bit? Do I have to use Outlook?
February 12, 2009 at 5:33 pm
No Outlook just go to databasemail inside SQL 2005...and follow the details...enter email server thats all. So much better that SQL 2000.
Must set the configuration on SQL 2005 SQL Server 2005 surface area configuration for features, database engine, enable database mail.
Thats all.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply