Skip to main content

Questions tagged [database-mail]

Database Mail is an enterprise solution for sending e-mail messages from the SQL Server Database Engine. Using Database Mail, your database applications can send e-mail messages to users. The messages can contain query results, and files from any resource on your network. Database Mail is designed for reliability, scalability, security, and supportability.

Filter by
Sorted by
Tagged with
56 votes
3 answers
168k views

How can I see the current Database Mail configuration?

Our SQL Server (2008) instance is configured to send mail and everything is working correctly, but I can't figure out how to view the existing configuration, in particular the SMTP server. From SSMS ...
Alex's user avatar
  • 663
9 votes
1 answer
5k views

Trouble With Database Permissions for sp_send_mail

I am trying to send database mail but I am getting EXECUTE permission denied on the object 'sp_send_dbmail' database 'msdb', schema 'dbo'.. I code I am running is as follows: SELECT SUSER_NAME(), ...
Kyle Brandt's user avatar
  • 2,345
5 votes
2 answers
1k views

The database mail configuration saved into a temp table

I am currently dealing with a bunch of servers and they have different Database Mail Configurations. I can see the Database Mail configuration for each of those servers. I use the following script: ...
Marcello Miorelli's user avatar
2 votes
1 answer
4k views

Comprehensive troubleshooting of DatabaseMail

I am having a problem sending email from one of my servers. I want to use DatabaseMail and/or msdb.dbo.sp_send_dbmail I have other production servers that use all the same databaseMail settings ...
Marcello Miorelli's user avatar
0 votes
1 answer
6k views

SQL Mail Failing To Send

SQL Sever 2016 with the latest updates. Running on WS2012R2. Following error message is received: The mail could not be sent to the recipients because of the mail server failure. (Sending Mail ...
DARKOCEAN's user avatar
24 votes
4 answers
54k views

Enable TLS 1.2 for SQL Server 2016 database mail

I have been puzzled by this issue for almost 1 week. Hopefully someone in our community has experienced the same issue and already found a solution. So here is my problem: As per our company policy, ...
jyao's user avatar
  • 3,063
4 votes
2 answers
1k views

Assigning permissions for sysmail_update_account_sp

I have a Microsoft SQL Server 2014. The mail system is configured via DBMail and there is one stored proc in main web app (having its own database) which executes msdb's sysmail_update_account_sp by ...
Rohith Nair's user avatar
2 votes
3 answers
1k views

How can I send mail from a contained database is SQL Server?

How can I send mail with a user within a contained database is SQL Server using Database Mail? I tried using msdb.dbo.sp_send_dbmail but since any users local to the contained database do not see ...
gemisigo's user avatar
  • 343
17 votes
2 answers
97k views

sp_send_dbmail stored procedure send with attachment

I've been tasked with sending a small monthly report to for one of my customers. The report has previously been run manually on the instance, the output copied to a spreadsheet and send to the ...
Gareth's user avatar
  • 313
11 votes
2 answers
93k views

Need to Send a formatted HTML Email via Database Mail in Sql Server 2008 R2

My requirement is to create the automated email as ( A formatted HTML Email via Database Mail) The basic requirement has been completed where when the Job is triggered it inserts the data into a Table ...
Heisenberg's user avatar
  • 1,505
7 votes
3 answers
106k views

Execute Sql statement and send result to email

I have to execute SQL statement every day and send result to dba by email.I configured database email. Below is query: SELECT account.accountID, account.name FROM ...
user120625's user avatar
5 votes
1 answer
7k views

DatabaseMail process is shutting down

I Have configured the Database Mail in INSTANCE1 and INSTANCE2. Whenever i try to send a mail using the following code, i get output as "Mail queued" in INSTANCE1. EXEC msdb.dbo.sp_send_dbmail @...
Vinesh Senthilvel's user avatar
3 votes
2 answers
6k views

how to use database mail from SSIS

I try to use gmail in database mail. I have no problem to send out email from it. But how I can configure my send mail task to send out email by using database mail. Thanks
user1188125's user avatar
2 votes
2 answers
2k views

Cannot find Database Mail feature in SQL Server Express 2012 SP1

I need to use SQL Server Database Mail feature in my project. However Database Mail seems not available on my development instance. There should be a 'Database Mail' node in the Object Explorer. In ...
bluearth's user avatar
  • 131
2 votes
1 answer
7k views

DatabaseMail didn't start when an email is queued

This is about SQL Server 2005. I have configured SQL agent jobs to send an email when it failed. So far I have received email reliably. However, I have an weird problem where an email would get ...
elty123's user avatar
  • 421
2 votes
2 answers
26k views

Problem sending an attachment using dbo.sp_send_dbmail

I am trying to send an attachment using dbo.sp_send_dbmail. I can't do this I get the error Attachment file \VMName\ListTEAM\LCPP_CP.pdf is invalid. Just some quick things that I have checked. I ...
Rascal of the North's user avatar
2 votes
1 answer
3k views

Is it possible to configure multiple database mail id in single account name in sql server 2012?

I would like to say that as i want to configure multiple database mail in single account name in sql server 2012. This is SQL-Cluster-DB , so as per direction from head, If any sql job will fail , ...
Md Haidar Ali Khan's user avatar
1 vote
2 answers
6k views

Send Email To Multiple Recipients

Creating a group or mailing list is not an option, and this may not be possible, but I need a way of scanning EmailMe and pulling the email address(es) to email from there. If two email addresses ...
BellHopByDayAmetuerCoderByNigh's user avatar