DBMail on a cluster

Leave a comment

September 26, 2012 by Kenneth Fisher

I’ve always found clusters a pain in the neck.  For my latest pain I just spent the last 2 days debugging DBMail on an instance on a cluster.  To the best of my ability everything appeared set up correctly but when I tried a test email it wouldn’t send.  The log showed “Successful Activation” but in sysmail_allitems all I saw was “unsent” for the emails.  To shorten a long story if you have a clustered environment and your instance isn’t using port 1433 you have to create a local TCPIP alias for the instance using the correct IP address.

 What a pain!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 3,755 other subscribers

Follow me on Twitter

ToadWorld Pro of the Month November 2013
%d bloggers like this: