I tried creating an availability group but keep encountering this error during the validation checks

Create failed for Database 'HADR Seeding Test 2d074a6f-c035-4046-ae4e-045436ca56c5'.

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

profile name is not valid (Microsoft SQL Server, Error: 14607)

  • 2
    Is it possible that on the secondary replica that you are trying to add, that you have a TRIGGER on any CREATE DATABASE statement that is set to send an email? If it attempts to send an email and uses an incorrect profile you could receive this message.
    – Nic
    Aug 20, 2017 at 6:06
  • Besides what @Nic mentioned, if you are wondering what this database is about, read this: sqlskills.com/blogs/jonathan/… Aug 20, 2017 at 12:36
  • Thanks @Nic... The profile name being used to send emails in the CREATE DATABASE trigger was incorrect. I fixed that and everything's fine now. Aug 20, 2017 at 15:17

1 Answer 1


As @Nic rightly suggested, the secondary replica had a trigger to send emails on CREATE DATABASE statements which was set to use an incorrect profile name. I corrected that and validation checks completed successfully.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.