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!

About these ads

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

Follow

Get every new post delivered to your Inbox.

Join 382 other followers

%d bloggers like this: