• Login
  • Register

DNN Blogs

Written for the Community, by the Community
All Posts Term: SQL Server
3 post(s) found

Installing DNN on a Ubuntu Server

Really? No, I am joking, but it's not April Fools Day. So what? In this Blog article I am going to explain how to install SQL Server 2019 on Ubuntu, and then using it with DNN. Sometimes you are in need to install SQL Server and IIS (with DNN) on different machines, so why pay a license for the Operating System when you need a database server?
Since the release of SQL Server 2017, Microsoft added support for different Linux systems (Red Hat Enterprise Linux, SUSE Linux Enterprise Server, Ubuntu and Docker Engine) to SQL Server. Some days ago, I said: why not trying this? And after some trial and error, I finally got it to run. So here's what I did.

Activating and Configuring Database Mail in MS SQL Server Express Edition

Do you know Database Mail? Those who administer an MS SQL Server apart from the Express Edition might know it, and there is a nice interface to configure it in SQL Server Management Studio (SSMS). But this interface is missing in the Express Edition. The reason for that is that the SQL Server Agent Services are not present in this edition, which does not let us configure maintainence tasks or Database Mail.
These services use the MSDB database, and this database is installed as one of the system databases, even in SQL Server Express Edition. With a few SQL statements we can activate and configure Database Mail, and make use of this feature.

Would you like to help us?

Awesome! Simply post in the forums using the link below and we'll get you started.

Get Involved