Page Comparison

- [Prerequisites](#prerequisites)
- [Create the Database](#create-the-database)

## Prerequisites
* A Microsoft SQL Server
  * Saga requires SQL Server 2012 compatibility.
  * Saga is tested and verified with the following versions:
    * SQL Server 2019
    * SQL Server 2022
  * The Microsoft SQL sever needs to be dimensioned in accordance with the size of the Saga installation. Heavy I/O is to be expected.
* A user with permissions to create databases on the Microsoft SQL Server.
* A gMSA account, see [Ayfie Saga Installation Guide](https://ayfie-dev.atlassian.net/wiki/spaces/SAGA/pages/2400714758/Ayfie+Saga+Installation+Guide)

## Create the Database

Download these files:
* [new-sqlserverlocatordatabase.ps1](https://ayfie-dev.atlassian.net/wiki/download/attachments/2374336517/new-sqlserverlocatordatabase.ps1?version=3134)
* [new-sqlserverlocatordatabase.sql](https://ayfie-dev.atlassian.net/wiki/download/attachments/2374336517/new-sqlserverlocatordatabase.sql?version=3134)

To create the database, run the command below (after having replaced \<Microsoft_SQL_host_FQDN\>, \<domain\> and \<login_name\>) with a user that has permission to create databases.

```
 .\new-sqlserverlocatordatabase.ps1 -Server <Microsoft_SQL_host_FQDN> -Database Locator -AdServiceAccount <domain>\<login_name>
```

* Server - The Microsoft SQL server where the database will be created.
* Database - The name of the database that will be created.
* AdServiceAccount - The Active Directory service account to get access to the database. This needs to be the gMSA account.
* <login_name> is the SAM account name.

The script requires the must be run from a Windows host with Microsoft SQL Server connectivity and the **SqlServer** PowerShell module SqlServer to be installed to run (the module is available out of the box on Windows 2019 Servers) installed. The module is included in all Saga supported OSes. The user executing the script must in the Microsoft SQL Server database have been granted permissions to perform the actions described below.

The script doesperforms the following actions:
* Creates a database named *Locator*
* Sets 2012 SQL Server compatibility level on the database.
* Creates *db_executor* role and grants execute permissions to this role in the database.
* Creates a user for the AdServiceAccount in the database.
* Creates a login for the AdServiceAccount in the database.
* Adds the following roles for the AdServiceAccount:
  * *db_executor*
  * *db_ddladmin*
  * *db_datareader*
  * *db_datawriter*