Windows 10: SQL Server 2017 database mailing not triggering databasemail.exe to send out emails.

Good day All,


After a certain update installed on my microsoft sql server 2017 my database mailing no longer works. I installed the latest CU 5 for sql server 2017 as this was suggested to resolve the issue online. After installing the update the databse mailing still didn't work. However I noticed that before I did the update the emails will go out if I manually open the databasemail.exe now I was receiving a dot net 4 not installed error message


Kind Regards


Andre

:)

 

SQL Server 2017 database mailing not triggering databasemail.exe to send out emails.

Good day All,

After a certain update installed on my microsoft sql server 2017 my database mailing no longer works. I installed the latest CU 5 for sql server 2017 as this was suggested to resolve the issue online. After installing the update the databse mailing still
didn't work. However I noticed that before I did the update the emails will go out if I manually open the databasemail.exe now I was receiving a dot net 4 not installed error message

Kind Regards

Andre

 

SQL email trigger not working on windows 2016 Server

Hi,

i'm using SQL server 2017 on Windows server 2016 for our production application.

This server deployed recently and DB configured.

I'm trying the email notification from SQL through office365. i'm getting the following error.

Exception Message: Cannot send mails to mail server. (The remote certificate is invalid according to the validation procedure).

Kindly help me to fix this issue ASAP.

 

SQL Server 2017 Express Issue with 3 Tier database access.

Hi, I am facing an issue with SQL Server 2017 Express.

My client is on PC1, SQL server is configured on PC2 and the database is on PC3. I could successfully connect to SQL server on PC2 through client on PC1, but if I try to access the database on PC 3 using client on PC1, I get following error...

"Msg 5120, Level 16, State 101, Line 2

Unable to open the physical file "\\MD1Z549C.ad001.siemens.net\Database_DT\Products\ProductDB.mdf". Operating system error 5: "5(Access is denied.)".

Msg 1802, Level 16, State 7, Line 2

CREATE DATABASE failed. Some file names listed could not be created. Check related errors."

When i access the database on PC2 there is no Issue. or if i use other SQL server from PC1 then I could access database database on PC3 as well. (here no intermediate PC2 is used)

So issue is when I have Client, SQL Server and Database on 3 different machines. (it gives above errro message)

The same scenario used to work well with SQL server 2008 R2 Express.

The same issue is reproducible with SQL server 2017 full version and SQL server 2019.

All the three PCs, shared drives and SQL server are configured well, which used to work with SQL server 2008 R2 express.

Is there any limitation or restriction introduced with the latest version of SQL server ? OR anything I need to try out to make the scenario work on three different machine.

Thanks a lot in advance.