HOW TO SET LOGIN IN SQL DATABASE

To set the Login in Ms-Sql Server :-
1.Open the SQl serer using your Administrator profile.

 

2.Go to Security>logins
3.Right click on login and select "New Login"
4.Click "search" button and a pop-window will open as follows:-

5.Now click the "Advanced" button and the following window will pop-up :-



6.Click the "Find Now" button.
7.In search results arera, list of profile names will be loaded. Select your profile from which you want to access the sql server and click the "ok" button.
8.Under "server roles" and "user mappings" check the checkboxes to grant the rights to your selected profile.