August 1, 2009 at 9:20 pm
Wondering anyone has successful experience to make database mail working on Sql Server 2005 64 Bit window 2008 Clustered Environment ?
We have them working on all 32 bit servers on VCS, but none of them working at 64 Bit window 2008 Clustered Environment.
Any input will be highly appreciated !
ddfg
August 2, 2009 at 3:11 am
- is your mail server accepting smtp from your cluster nodes and sql instances (may need grants at mail software level on the mail server)
- is sqlbrowser running ?
did you check this thread ? http://social.msdn.microsoft.com/forums/en-US/sqltools/thread/185eb1df-1387-43d7-b3bf-1f00cb39e14c/
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
August 2, 2009 at 2:09 pm
Thanks ALZDBA , I go through the thread and double checked all SQL Browser services are running on both cluster nodes, the problem really seems like SQL Server not able to run DataBaseMail90.exe external program to deliver the emals, they are sitting in the queue:
EXECUTE msdb.dbo.sysmail_help_queue_sp ;
results:
mail34NOTIFIED 2009-08-02 05:57:18.8472009-08-02 05:57:18.873
status0INACTIVE 2009-08-02 06:14:06.5432009-08-02 06:14:06.467
select * from sysmail_event_log;
results:
........
34error2009-08-01 15:05:00.853Activation failure.NULLNULLNULL2009-08-01 15:05:00.853sa
35error2009-08-01 22:57:19.317Activation failure.NULLNULLNULL2009-08-01 22:57:19.317sa
So, how am i able to let SQL Mail to activate the DatabaseMail90. exe ?
I installed SQL Server 2005 SE plus SP3 on this 64bit windows 2008 EE , two nodes active/active cluster, i can see the DatabaseMail90.exe sitting at \MSSQL\Binn, and i actually put the virutal server name with virtual IP in host file on both nodes, still not able to get it going, any thoughts ? Thanks a bundle !
ddfg
August 3, 2009 at 5:35 am
did you enable dbmail xps
-- enable db-mail
exec sp_configure 'show advanced options', 1;
RECONFIGURE;
GO
exec sp_configure 'Database Mail XPs', 1; -- 0 to Disable and 1 to enable
RECONFIGURE
GO
does this ref help ?
http://technet.microsoft.com/en-us/library/ms190630.aspx
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
August 3, 2009 at 3:35 pm
Yes, that's the first thing i need to do before setup db mail.
Like i said, i did this db mail many many times without any issues including on 32bit window 2003clusters, but just not working on the two nodes 64bit cluster server ( windows 2008 ), installed the instances as named instances and with static port numbers, we have four paired two nodes SQL Server 2005 plus SP3 servers, none of those instances database mail work, they are all the same problem --- mails sitting there with the status "unsent" in the queue, wondering did anybody really make it work at 64 bit windows cluster servers ? thanks.
ddfg
August 3, 2009 at 4:01 pm
Is your broker enabled on msdb database?
SELECT is_broker_enabled, name FROM sys.databases
If not use the Alter Database command to do so. You might have to stop the agent service to do so
Shinoj
August 4, 2009 at 2:39 am
smtp & win2008 seem to have changes in setup compared to win2003.
Maybe this one helps ...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
August 17, 2009 at 12:50 am
Did you manage to get smtp to work on your 64-bit win2008 ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
September 24, 2009 at 12:30 pm
I had the exact same issue on the same setup (SQL2005-SE with SP3 and cu5 (9.00.4230)) on a Windows 2008 cluster, all 64-bit. The following link describes a number of DBMail stored procs that need to be recreated, a configuration file to build... its like a 10 step process, but it worked.
http://paradisj.blogspot.com/2008/08/sql-server-2005-database-mail-in.html
The article talks about it being the result of applying SP2, but I'm doing fresh builds with SP3 and still had the same problem. Very frustrating when DBMail is working fine on my SQL2005-SE with SP3 (9.00.4035) on a Windows 2003 cluster.
I found setting up the config file first with the insert, then create the missing sp_validate_user because it is referenced in some of the other alter sp's. Last, run the start command.
I hope this helps.
Dale
September 25, 2009 at 1:55 pm
I also had a problem with DBMail that logged the message "Mail configuration information could not be read from the database" into the DBMail error log.
This was corrected by running the following update script manually:
C:\Program Files\Microsoft SQL Server\MSSQL.x\MSSQL\Install\sysdbupg.sql
Dale
September 25, 2009 at 2:39 pm
Thank you for the refs, Dale.
I'll try them next week.
Johan
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
October 9, 2009 at 1:32 pm
You rock!!! Thanx so much for your help!!!
October 12, 2009 at 12:58 am
Once again, thank you Dale.
Your advise and refs contained the solution to fix the issue that occured on some of our x64 systems.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
January 12, 2010 at 11:43 am
Thanks, Dale!
That got my DBM working again after the lovely message:
<snip>
Message: Mail configuration information could not be read from the database.
</snip>
Nice not to have to go through the CU/SP reinstallation. 😀
Cheers.
dj
January 13, 2010 at 7:15 am
I had the same issue and this post resolved it. Here's another post about the subject.
http://www.sqlservercentral.com/Forums/Topic522362-146-1.aspx
and as Dale said, running this fixes it.
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\ sysdbupg.sql
Viewing 15 posts - 1 through 15 (of 20 total)
You must be logged in to reply to this topic. Login to reply