IPGraySpace: Sql Server - How to create user account in SQL Server Express 2017

IPGraySpace: SQL Server - How to create a user account in SQL Server Express 2017

This video show How to create a user account in SQL Server Express 2017

1. log in to SQL Server using SQL Server Management Studio
2. log in 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 a user account on "windows authentication mode"
change it to "SQL Server and Windows Authentication Mode"

7. After restart open SQL Server Management Studio
8. log in as windows authentication
9. From the 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 IPGraySpace videos
-----------------
thank you for watching the IPGraySpace video
please share, subscribe, and comment

visit
www.ipgray.com
www.ipgrayspace.com
for more IT articles, documents, and videos