a)
Open you sql server management studio
b) Connect using Window authentication
c) Right click on “security - > New - >Login..” as shown in below figure
f) Next Step is “Status” from the left menu and enabling the account as shown in the figure
g) The Final Step is restarting the SQL server instance by right clicking on instance name and restart
h) That's is. You are done with creating new login. Open New Instance and login using new credentials.
b) Connect using Window authentication
c) Right click on “security - > New - >Login..” as shown in below figure
d)
This will open up with a new popup as shown
below:
1)
Enter Login name
2)
Check second radio button “SQL Server
authentication
3)
Select the Default Database from the dropdown
shown bottom of the page.
4)
Click Ok
e)
Select “User Mapping” from the left menu and
select the database for which you are creating new login
And then select the role membership I
selected “Db_owner” in my case
f) Next Step is “Status” from the left menu and enabling the account as shown in the figure
g) The Final Step is restarting the SQL server instance by right clicking on instance name and restart
h) That's is. You are done with creating new login. Open New Instance and login using new credentials.
No comments:
Post a Comment