How to add Users for databases on Sql Server 2008
Following are the steps for adding users on Sql server.
Step:1
Got to Security-> Logins on server.
Step: 2
Right click on Logins. Add Login name and select SQL Server authentication. Set password and Confirm password.
Unchecked Enforce password expiration option.
Step: 3
Go to Server Roles and select public option
Step: 4
Go to User Mapping and select Db_Owner, Public Option and mapped it with database from databases.
After following the above steps you will find recently added user will be automatically added on the database.
Following are the steps for adding users on Sql server.
Step:1
Got to Security-> Logins on server.
Step: 2
Right click on Logins. Add Login name and select SQL Server authentication. Set password and Confirm password.
Unchecked Enforce password expiration option.
Step: 3
Go to Server Roles and select public option
Step: 4
Go to User Mapping and select Db_Owner, Public Option and mapped it with database from databases.
After following the above steps you will find recently added user will be automatically added on the database.
No comments:
Post a Comment