SQL Server DB Mail Account Creation Failed – A Bug

SQL Server DB Mail Account Creation Failed – A Bug

One fine day i was configuring DB Mail on one of my server and while configuring Mail Account i encountered the following error.This Bug\Problem is applicable to SQLServer 2008 SP1, I’ve faced it on Standard Edition 64-Bit.

As per the error, Server Name field was left blank while configuring the account and since the Column in the table doesn’t allow Nulls it was failing.

I tried it once again and this time double checked the value provided in server name, (checked both ways providing Server IP | Hostname of the relay server) but it landed up again on the same error message.

But this time i choose to look into the Advance info Page to get more info about the error, and Woopie i got the name of the SP which was running behind the scene by Wizard.