Configure Your Microsoft SQL Server Instance In SSMS

Cory Fifield -

Trouble viewing images? Click on images to enlarge.

 

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).

mceclip1.png

 

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.

mceclip2.png

 

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

mceclip4.png

 

 

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

mceclip5.png

 

 

5. Click OK again.

mceclip6.png

 

 

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

mceclip7.png

 

 

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

mceclip8.png

 

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

mceclip9.png

 

 

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 WebReportsV10 from the Database name.

 

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

mceclip10.png

 

 

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

mceclip11.png

 

 

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 WRV10 from the Login name.

 

mceclip12.png

 

 

12. Select SQL Server authentication.

mceclip13.png

 

 

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.

 

 

mceclip15.png

 

 

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

mceclip0.png

 

 

15. Select User Mapping

mceclip17.png

 

 

16. Select your Database.

mceclip18.png

 

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

- db-datareader

- db-datawriter

- db-owner

- db-securityadmin

 

mceclip19.png

 

Click here to continue to step 5...

 

 

Have more questions? Submit a request

Comments