September 16, 2002 at 5:08 am
Hi Guys,
I have encountered problem in setting up SQLmail on clustered server. I have followed every instruction and restarted the cluster nodes.
->I logged onto server(cluster nodes) using NT account that is been used for SQL service start up
-> installed outlook 2000 client
-> created a profile for the SQL startup service acount
-> restarted the server(s) (I had to re-start the servers, Before re-start, i was unable to see mail profile in the drop-down list under "SQLMail" Properties)
After re-start, im able to send mails using outlook on the server successfully.
Then I tried testing froM SQLMail. Once, i Click on "test"
by selecting mail profile from drop down list,its hanging continuously.
I also tried from QA to start the mail session. Problem remains the same and its hanging the moment i issued xp_startmail command from QA
Did I Go wrong anywhere?your support is appreciated,
thanks in advance
Praveen Kumar Peddi
Praveen Kumar Peddi
Praveen Kumar Peddi
September 16, 2002 at 11:05 am
Not a cluster person, but I know there are issues with SQLMail on clusters. If no one responds here, I suspect you will need to call MS.
Steve Jones
September 27, 2002 at 2:35 pm
I'm assuming that You're running SQL2000 Enterprise. In that case, you need SQL SP2 to get it working properly on a cluster.
Also, MS doesn't officially support SQLMail on a cluster, because MAPI is not cluster aware. I tried to phone them during my initial setup, and they were not able to provide a lot of help.
Please ensure that your mail profiles have the same name on both nodes. This will ensure that SQLMail works properly in case of a failover.
Worst case, you can use a tool such as Command Line E-mailer in conjunction with XP_CMDSHELL to send out your notifications. It's available here: http://www.bysoft.se/sureshot/clemail/.
September 30, 2002 at 1:08 am
HI Thushar,
thnk u for the response,
we are using SQL 2000 Enterprise edition,also applied SP2,mail profiles are identical on both nodes, still the problem remains.
hi guys,
thnk u very much for ur support.
we could not resolve the problem and we moved to CDONTS for sending mails using SMTP server.
your further support is appreciated in setting up SQLMail.
thnks n regs,
Praveen Kumar
Praveen Kumar Peddi
Praveen Kumar Peddi
September 30, 2002 at 7:46 am
Microsoft's official response is SQLMail is not supported on cluster configurations because Outlook and MAPI don't have cluster support. However, we use SQLMail on our clusters here. Here is the checklist we go through:
(1) Install Outlook 2000
(2) Log on as user SQL Server and the SQL Server Agent runs under
(3) Create MAPI profile using Outlook
(4) Test send and receive via Outlook
(5) Configure SQLMail and SQLAgentMail to use MAPI profile
(6) Create operator with e-mail address and test send to operator
(7) Test using xp_sendmail.
If you are getting the hang when you try to test the profile from SQLMail, you might go back and verify you can do everything through Outlook. If you can, I believe there are some knowledge base articles about reverting to an older version of the .DLL that drives SQL Mail. If it comes to that, we can hope you look for the appropriate article.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply