Home » [sqlstate 42000] (error 14607)

[sqlstate 42000] (error 14607)

SQL Server Error : 14607, Severity: 16. %s name is not valid

SQL Server Error : 14607 Details

SQL Server Error: 14607 Severity: 16 Event Logged or not: No Description: %s name is not valid Severity 16 Description: Indicates general errors that can be corrected by the user.

Cause of Error:

For SQL Server Emailing, we need to create an database mail account and then a database mail profile.

If we send a email with below on SQL Management Studio and executed the following script:

@recipients=’[email protected]’, @profile name = ‘Profilename’, EXEC msdb.dbo.sp send dbmail @subject =’test email,’ @body =’test email,’ @body format =’HTML’

We can have a job failed due to an error below for any other user trying to send a … Read the rest