SQL Server Instance Features
On the Feature Selection screen during SQL server setup, enable Database Engine Services and Full-Text Semantic Extractions for Search.
Authentication Mode
-
In SQL Server Management Studio Object Explorer, right click the server and then click Properties.
-
On the Security page, under Server Authentication, select the server authentication mode, then click OK.
-
In the SQL Server Management Studio dialog box, click OK to acknowledge the requirement to restart the SQL server.
TCP/IP
-
Open SQL Server 2019 Configuration Manager.
-
Expand SQL Server Network Configuration > Protocols for MSSQLSERVER.
-
Set TCP/IP to Enabled.
DB Admin Users
-
Create an admin user called otadmin (it can be any name of the customer's choice) with a secure password and provide the dbcreator server role.
-
Restart the SQL server.
Note
The dbcreator role can be removed after the account creation step.
Database Connectivity from Application Server
Ensure the database can connect to the application server by setting up the required firewall safelist. The application supports SQL server authentication. To use this feature, ensure a username is created with this authentication setting. Make sure your database security settings allow both Windows authentication and SQL server authentication.
