failed creating new databases with error of profile name is not valid on SQL Server 2016

Question

Suddenly failed to create new databases on a SQL Server 2016 SE instance, that previously created databases successfully without any issues. the error message 'profile name in not valid' from either an application server remotely installation or on local SQL Server with an account granted sysadmin and local admin privilege on servers.

the issue finally has been fixed after created a database mail profile or drop/recreate the database main profile several times.

I searched online, seems no one reported such 'profile name is not valid' that caused creating database failed and totally don't understand why as creating a database nothing to do with sending mails.

managing SQL Servers over 10 years, first time running into this issue. Any thoughts are much appreciated and thank you in advance.

Answer 1

Could it be that you created a server level trigger for CREATE DATABASE and that trigger somehow involves sending a DB Mail?

https://learn.microsoft.com/en-us/sql/relational-databases/triggers/ddl-triggers?view=sql-server-ver16

Answer 2

Hi @Jiang, Nasha AG:EX ,

Creating a new user database failed with error message 'profile name in not valid'? Please share us a screenshot about your operation and error to make us better understood your issue. Or did you meant that sending DB mail failed with this error message? If so, please check the solution and explanation from below blog.

Fix “profile name is not valid” When Sending Mail from SQL Server

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".