Hosting Blog

How to create the special SQL view for a MSSQL database

Steps to create the special SQL view for the MSSQL database:

1)  Login to the SQL Server for the database for which the SQL view is to be created.

2)  Open the SQL Server Management Studio there.

3)  Expand the Security tab and select the option Login and right click on it to create the New Login.

4)  Fill the "Login name" field for creating the SQL view user and also set a complex password in the SQL Server Authentication option in the New Login window that appears.
 
5)  Make sure the password is complex and properly generated by KeePass.

6)  Also only check the option "Enforced Password policy" while the rest of the options must be unchecked and then click OK.

7)  Now go to the particular database for which the SQL view is being created.

8)  Right click on the DB and go to its properties.

9)  On the new window that appears, select the option File.

10) Write the created SQL View in the "Owner" field and click OK.