1

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)

Improve this question
3
  • 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
    Commented 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/…
    – SqlWorldWide
    Commented 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.
    – Samuel Isola
    Commented Aug 20, 2017 at 15:17

1 Answer 1

Reset to default
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.

Improve this answer

Your Answer

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

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