is a component of Microsoft SQL Server for sending e-mail messages.
Database Mail is a component of Microsoft SQL Server for sending e-mail messages directly from the SQL Server Database Engine.
Questions tagged [database-mail]
95 questions
1
vote
1 answer
Truncate Database Mail table
We have been having some drive space issues on our SQL server (2005) and I just ran some queries on the sys.allocation_units table and found that we have 26GB of database mail attachments. Apparently we have just been stashing this away in our msdb…
Larry Grady
- 469
- 7
- 24
1
vote
2 answers
How to make your own mailing services like gmail or yahoo
I am a noob to php and databases. But I have an idea to perform mail operations on my own web server (i.e just by database operations), but I really don't have any idea of how to send mail to external websites like gmail. and also I look forward to…
Shrikantha Budya
- 646
- 1
- 4
- 15
1
vote
1 answer
what's the server role for database mail on sql server 2008?
I have create a account and assign server role as public.
the assign user mapping on database mydb as dbo, and for msdb also as dbo.
with User mapping setting on msdb, I checked following role:
DatabaseMailUserRole
db_owner
public
then my app login…
KentZhou
- 24,805
- 41
- 134
- 200
1
vote
2 answers
Timeout Error in SQL Server Database Mail Feature
I configured database mail profile as gmail smtp server, SSL and port 465.
I didn't restart server. And this is first time to use Database Mail feature on that server.
When I send a testing mail it give me this error message:
The mail could not be…
RedLEON
- 281
- 2
- 7
- 19
1
vote
1 answer
Sending e-mail notification when job fails doesn't work
I prepared scripts for sysadmin, for creating and configuring database mail profile, account and operator. He run the script, so I created temporary job, which fails. Then I set e-mail notification when the job fails. I run the Job, but no e-mail…
Konrad Z.
- 1,592
- 4
- 20
- 34
1
vote
2 answers
Database Mail in Sql Server 2008 not working
I am using Database Mail feature of SQL Server 2008 for the first time to send mail.
I followed the steps in Example
All seems good. Send status in
SELECT * FROM sysmail_allitems
is sent.
But the recipient hasn't received any mail..
What could be…
Brij
- 11,731
- 22
- 78
- 116
1
vote
2 answers
Sql Server Database Mail attachments from FileTable msg 22015 (file is invalid)
I'm transitioning email services in an web (mvc3) application from .Net to sql Database Mail. Some of the content we want to send as attachments has been uploaded to a sql FileTable. When I use the UNC path for the attachment (@file_attachments=), I…
Reuven Trabin
- 451
- 7
- 18
0
votes
1 answer
How can we encode the image into the body of the email when sending mail using database mail in sql 2008?
How can we encode the image into the body of the email when sending mail using database mail in sql 2008
I m using :
exec msdb.dbo.sp_send_dbmail
@profile_name = 'DBMail',
@recipients = 'goldenash21@gmail.com',
@subject = 'DB…
Ashok Gupta
- 2,247
- 5
- 28
- 34
0
votes
0 answers
email a file from AWS S3 bucket to a user using sql
I have created a s3 bucket to store all files in it and I know that I can get a presigned url to share it with others. Now I want to generate a quick way to grant a particular email address these rights. My goal would be to have some kind of…
0
votes
1 answer
SQL Database Mail sudden failure with Exception Message: Cannot send mails to mail server
Trying to send email from database server to internal company mail, used to work properly until recently
Failed with the following error message:
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using…
Insignia Last
- 11
- 4
0
votes
1 answer
SQL Database Mail Not Working - But I can send email on same server using VBscript CDO
I have searched everywhere (it feels) for a solution and / or guidance. My last resort is to ask. I have SQL Server 2016 running on a Windows Server. Database mail is not working. I have setup the profile and have submitted a test email by right…
Michael
- 11
- 4
0
votes
1 answer
Databasemail working for live environment but not test environment on the same SQL Server instance
One of our offices has an application that utilizes databasemail to send emails from the application to users listed in the application's user directory.
In their live environment, the emails are sent without issue. On their training environment,…
0
votes
0 answers
SQL Server - Sending encrypted email
Is it possible to send encrypted email using the Database Mail component of SQL Server? I'm looking into adding encryption support to a system that currently uses Database Mail for sending out emails. S/MIME is preferable, but PGP is also OK.
If…
Filip
- 1,451
- 1
- 11
- 19
0
votes
1 answer
SQL Server 2018 : database email - exception message: Cannot send mails to mail server. (The operation has timed out
I am using SQL Server Management Studio V18. I would like to schedule a job in SQL agent, which will send some mail based on some condition. For that I have configured database account profile and I am trying to test the email. But email is not…
biks
- 25
- 1
- 2
0
votes
0 answers
Database Mail registry settings won't stay configured
I have a strange one for you. I'm maintaining several databases prior to a migration. One of them is a 2008R2 instance. This instance has multiple errors in the logs (the infrastructure has been poorly maintained), so I set up a bunch of alerts…
Sound Of Mind
- 19
- 4