DB Mail Configuration Wizard hangs & is not responding
Posted on 2013-01-03
I've installed SQL Server 2008 R2 and applied SP1.
Tried to configure db mail but the Database Mail Configuration Wizard hangs and says "Not Responding".
No error is thrown on-screen.
No error in db logs in SQL Server.
Event Viewer on the server has this informational message:
"Login failed for user '<domain\user_id>'. Reason Failed to open the explicitly specified database. [Client:<my_ip_address_here>]"
The userid given in the message is the one that both the MSSQLSERVER and SQL Server Agent services use. SQL Server isn't having any other problems so I'm confused as to how there could be a problem with the userid. Have no idea what "explicitly specified database" means.