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
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.