April 24, 2012 at 3:52 am
I have configured database mail on SQL Server 2008 R2 instance.
When I click on "Send Test E-mail" of database mail, it gives me error that "there are no database mail profiles to send a test e-mail. Do you want to launch the database mail configuration wizard to create a new profile".
If I go again to create a same profile & account, it says this profile & account already exists.
If I try to create a different profile & account, it gets created successfully but then it does not allow me to send a test e-mail giving the above error.
Can anybody please provide a solution?
I have configured the db mail on another server (SQL 2008) and it works.
April 24, 2012 at 4:31 am
April 24, 2012 at 5:32 am
Bingo!
You are correct!
Its the same bug which was not allowing me to configure the database mail on server instance.
The database mail wizard of another instance from another server was open during configuration.
All the profiles and accounts were getting added into this instance instead of the one I was doing.
Thanks a lot!
April 24, 2012 at 6:47 am
Great!
Glad I could help.
-- Gianluca Sartori
April 24, 2012 at 7:07 am
As a side note, this bug has been fixed in SSMS 2012.
You could install it and use it even against a 2008 instance.
-- Gianluca Sartori
April 27, 2012 at 4:33 pm
I have been bitten badly by this bug.:-)
I was recently trying to copy db mail settings from one server to another and somehow managed to mess up the "good" profile settings.
Had to scramble to fix it in production the next day after users starting complaining about not receiving any emails.
Not fun...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply