How to create new user on MS SQL?
- Open MS Sql Management Studio.
- Log in via Windows Authentication.
- Open Security Folder.
- Open Logins Folder.
- Right Click -> New Login...
- Write the user name.
- Select the Sql Authentication
- Type a password
- Pick the DB which this user should manage.
- Press OK.
Look @ the figure bellow
No comments:
Post a Comment