Installing a Database Server?
It is beyond the scope of n-gen.net CMS support site to document how to install a database server!
However, you can find thousand of sites, pages and videos or even good old fashioned paper books describing installations of a database servers.
Use your favourite search engine to search for information...
...or your favourite AI engine...
Create a MySQL Db Instance
If you want to create a database instance for n-gen CMS on your MySQL or MSSQL (any edition) database server to use for the n-gen CMS installer you can use the SQL statements to the right or below...
If you already have access to a MySQL or MSSQL database server but you do not have a database (instance) on the server for your n-gen CMS the installer will offer to create it for you.
Please be aware that this method will only succeed if you have the privileges to create a new database (instance) on your MySQL or MSSQL database server.
Note:
The database server does not have to reside on the same physical or virtual server as your web server (MS IIS). It does not even have to run on the same Windows OS as your production server. Most of the n-gen.net development has been done on MySQL running on various Linux distributions or Maria DB running on Synology DSM.
You can also run MSSQL (Express Edition) on a Linux PC using a Docker container.
You can even run your database server on a headless 30 € Raspberry Pi as long as your website is not too busy. The only thing is that you need is a stable and always-online connection to make your web site available at all times.
Creating a MySQL database instance
If you do not have a MySQL database server: Download MySQL Database server and install it.
You can find all the required information on MySQL website.
If you do have a database server but do not have a database for n-gen CMS:
Logon to the DB server with Admin privileges (root) and write the below SQL-statements:
CREATE DATABASE [myDbName];
USE [myDbName];
CREATE USER '[myDbUserName]'@'localhost' IDENTIFIED BY '[myDbUserPassword]';
GRANT USAGE ON [myDbName].* to '[myDbUserName]'@'localhost' IDENTIFIED BY '[myDbUserPassword]';
GRANT ALL ON '[myDbName]'.* to '[myDbUserName]'@'localhost';
Creating a Microsoft SQL server (MSSQL) database
If you do not have a MSSQL database server: Download MSSQL (Express edition) Database server and install it.
You can find all the required information on Microsoft website.
If you do have a database server but do not have a database for n-gen CMS:
Logon to the DB server with Admin privileges (root or DBO) and write the below SQL-statements:
CREATE DATABASE [myDbName];
GO
USE [myDbName];
GO
CREATE LOGIN [myDbUserName] WITH PASSWORD = '[myDbUserPassword]';
GO
CREATE USER [myDbUserName] FOR LOGIN [myDbUserName];
GO
ALTER ROLE db_owner ADD MEMBER [myDbUserName];
GO
Substitute the values within [] with your own values.