IPGRAY : Sql Server - How to create user account in Sql Server Express 2017
IPGRAY : Sql Server - How to create user account in Sql Server Express 2017
This video show How to create user account in Sql Server Express 2017
1. Login to sql server using Sql Server Management Studio
2. Login as windows authentication
3. After login right click on the root directory "properties"
4. Click "Security" from left navigation check "Sql Server and Windows Authentication Mode" click "OK"
5. Restart Sql server Service
6. If the service restart does not work - restart the computer itself
FYI : you can't create user account on "windows authentication mode"
change it to "Sql Server and Windows Authentication Mode"
7. After restart open Sql Server Management Studio
8. Login as windows authentication
9. From left panel right click on "Security" and "new" and "Login"
this will give you full access as windows authentication
10. Follow other steps in the video
thanks for watching
follow more IPGRAY videos on youtube
please subscribe