Tuesday, July 7, 2015

how to create new user in MS SQL Server 2012, 2008 or R2

in this Article we are learn how to create user in ms sql server 2012, 2008 or R2.
these are several step to make user authentication .
1- Connect to Server
 server name =.\SQLEXPRESS
 authentication= Windows Authentication
connect successfully.
2-go to Security and then enter Logins right click on Logins popup bring click on new Login
open new Login screen Popup form Enter Suitable Name for login username select radio button  SQL Server authentication put your password and Confirm password should be same then select default database : XYZ i.e
3- Select  Server Roles check public.
4- Select User Mapping Check Users mapped to this login XYZ.
5- Check on  below Database role membership for XYZ check
db_owner.
6- press OK button
then Disconnect to Server and reconnect to server select sql authentication
fill with login username and password connect the server. username successfully connect with sql server.

thanks

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.