DB Mail Configuration Wizard hangs & is not responding
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.
Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.