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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

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

Join 1,232 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013
Follow

Get every new post delivered to your Inbox.

Join 1,232 other followers

%d bloggers like this: