This section provides SQL-based instructions for manually creating the PADS4FIDS database using your preferred SQL client (e.g., SQL Server Management Studio, Azure Data Studio, etc.).
Note: Execute the following SQL commands using an account with sysadmin privileges on the SQL Server.
USE [master];GO-- Step 1: Create login for NT AUTHORITY\SYSTEM if it does not existIF NOT EXISTS ( SELECT * FROM [master].[sys].[server_principals] WHERE name = 'NT AUTHORITY\SYSTEM')BEGIN CREATE LOGIN [NT AUTHORITY\SYSTEM] FROM WINDOWS;ENDGO-- Step 2: Create the PADS4FIDS database if it doesn't existIF DB_ID('PADS4FIDS') IS NULLBEGIN CREATE DATABASE [PADS4FIDS];ENDGO-- Step 3: Grant db_owner role to NT AUTHORITY\SYSTEM on PADS4FIDSUSE [PADS4FIDS];GOIF IS_ROLEMEMBER('db_owner', 'NT AUTHORITY\SYSTEM') = 0BEGIN EXEC sp_addrolemember 'db_owner', 'NT AUTHORITY\SYSTEM';ENDGO