Configure Your Microsoft SQL Server Instance In SSMS

Trouble seeing the images? Right click on images and open in new tab to enlarge or zoom in on the page (Ctrl + mousewheel).

Article Goal: Configure Web Reports server using SSMS.

In this article we are going to provide the steps to configure your Web Reports server using SSMS.

Steps Configure Your Microsoft SQL Server Instance

1. Launch Microsoft SQL Server Management Studio (SSMS).

2. Login to your SQL Server. 

NOTE: Copy the first part of the Server name and paste it somewhere. You will need this at a later step.

Example: Copied out EC2AMAZ-R209LKV from the Server name.

3. Right click on your Microsoft SQL server instance and select Properties.

4. Click on the Security page and set the Server Authentication to SQL Server and Windows Authentication mode, then click OK.

5. Click OK again.

6. Right click on your Microsoft SQL server instance and select Restart.

7. Select Yes to restart your Microsoft SQL server instance. 

8. Expand your Microsoft SQL server instance and right click on Databases, then select New Database.

9. Enter your Database name, then click OK.

NOTE: Copy the Database name and paste it somewhere. You will need this at a later step.

Example: Copied out WebReports from the Database name.

(Optional: Modify the file path for the database files here)

10. Expand the Security folder for your Microsoft SQL server instance, right click Logins and select New Login.

11. Enter your Login name.

NOTE: Copy the Login name and paste it somewhere. You will need this at a later step.

Example: Copied out WRAdmin from the Login name.

12. Select SQL Server authentication.

13. Enter the password for your account. We recommend using a strong password.

NOTE: Remember the password used. You will need this at a later step.

IMPORTANT NOTE: / \ { } ; are not permitted in SQL passwords as they conflict with the appsettings.json file strucutre.

14. Uncheck the "Enforce password expiration" and "User must change password at next login" options. Set your Default database (created at step 9).

15. Select User Mapping. 

16. Select your Database/User.

17. Enable the following minimum database permissions / roles. Then click OK.

- db-datareader

- db-datawriter

- db-owner

- db-securityadmin

Click here to continue to step 5...