Login to Members Area

Choose the service you want to log in
24x7x365 Presence
Live Chat

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.

Pritam Monday 10 June 2013 - 10:01 pm | | Default
Used tags: , , , ,

No comments

(optional field)
(optional field)

Comment moderation is enabled on this site. This means that your comment will not be visible until it has been approved by an editor.

Remember personal info?
Small print: All html tags except <b> and <i> will be removed from your comment. You can make links by just typing the url or mail-address.