Whenever you try to send Test mail from Database mail; it throws below error message:

Msg 14641, Level 16, State 1, Procedure sp_send_dbmail, Mail not queued. Database Mail is stopped. Use sysmail_start_sp to start Database Mail.


  1. First of all make sure that Service Broker Message Delivery in Databases is enabled by executing the following command in SSMS:
    SELECT is_broker_enabled FROM sys.databases WHERE name = 'msdb'

    If the result of above query is 0, then activate the service broker.

    Activating Service Broker allows messages to be delivered to the database. A Service Broker endpoint must be created to send and receive messages from outside of the instance.

    To activate Service Broker in a database use the following command:

    USE master ;
    GO
    
    ALTER DATABASE DatabaseName SET ENABLE_BROKER ;
    GO
  2. If the Service Broker is enabled then confirm whether Database Mail is enabled or not by executing below queries in SQL Server Management Studio:
    sp_configure 'show advanced', 1
    GO
    
    RECONFIGURE
    GO
    
    sp_configure
    GO

    If the result set shows run_value as 1 then Database Mail is enabled.

  3. If the Database Mail option is disabled then run the below queries to enable it:
    sp_configure 'Database Mail XPs', 1; 
    GO
    
    RECONFIGURE;
    GO
    
    sp_configure 'show advanced', 0; 
    GO
    
    RECONFIGURE;
    GO
  4. Once the Database Mail is enabled then to start Database Mail External Program use the below mentioned query on msdb database:
    USE msdb ;       
    EXEC msdb.dbo.sysmail_start_sp;
  5. To confirm that Database Mail External Program is started, run the query mentioned below :
    EXEC msdb.dbo.sysmail_help_status_sp;
  6. If the Database Mail external program is started then check the status of mail queue using below statement:
    EXEC msdb.dbo.sysmail_help_queue_sp @queue_type = 'mail';
  7.  If it’s still unresolved then you need to modify the properties of the SQL Server Agent.  Select “Alert System” and then check “enable email profile”.  Select “database mail” and the profile, then restart the SQL SERVER AGENT.