Database Configuration

· User can Create the Database in Microsoft SQL Server Management Studio before Signing in to the Application.

Open SSMS and Connect to SQL Server

· Open the Microsoft SQL Server Management Studio and go to File --> Connect Object Explorer.

· Select the proper Server Name in which Database is created/saved. Click on Connect.

Create a New Database

· Once connected, in the Object Explorer window (usually on the left side), right-click on the Databases node.

· Select New Database from the context menu.

Configure Database Details

· In the New Database window, enter a Database Name.

· You can also configure other options like the Owner, Filegroup, Collation, and more by expanding the options.

· Once you're done, click OK to create the database.

· You should see your new database listed under the Databases node in the Object Explorer.

Preparing Database

· User can prepare database in System Admin.

Step 1: Log in to System Admin

· User can access the Application using the Web Application URL.

· For example, the URL:- http://localhost:8081/.

Step 2: Configure the Data Base

· Click on Database from the left side menus or the Database Configure icon on the Dashboard screen. Click on the Edit button.

· Select Server Type as Cloud and add the Connection String and provide the database name that was created in Microsoft SQL Server Management Studio.

· Eg: Connection String :- Data Source=host.docker.internal;Initial Catalog=Database_Test;User ID=sa;Password=Admin123;TrustServerCertificate=True;

· After saving, click on Prepare Database.

The Database has been configured. Then, Reset and change the password. User can login using this database.