Today I’m going to show You Can Create Tutorial. It is one best way to secure your database. If you have installed SQL Server You are using Windows Authentication User Account in SQL Server Mode to Connect SQL Server, that’s not good work.
Because many friends or any other person they are using your system. They easily delete or change your database from your computer.
Basically, more than users using Windows Authentication Mode, I recommend you use Server Authentication Mode to Connect the SQL Server. You just need to create a username, password and authorize role of the database as you like.
In this video tutorial, I will teach you How You can make a User to Connect SQL. These few simple steps to create an Account.
First of All, you need to Open SQL Server and Connect the SQL Windows Authentication Mode. After that Go to Left Side Right Click to DB Yellow and Green Icon in the Front. After that Select property then select Security Tab and Change the Radio Button Windows Authentication Mode to SQL Server Mode.
Then you need to restart the SQL Server and go to right side folder namely Security Right Click it. Then Hover the Mouse New and Login then enter the User Name as you want to use and Select Second Radio Button and enter the password, then you need to uncheck Enforce password expiration.
Then Go to Next Tab Server Role and Check Last Option namely sysadmin. Then go to User Map Tab and Select Database as you assign, after that below you can database roles, assign the role as you like.
That’s it, However, Kindly Watch the Complete video tutorial for getting more ideas. If you have any question/suggestion kindly comment me. Please Subscriber My YouTube Channel and Share my Video. Thanks, A Lot
Subscribe: https://www.youtube.com/channel/UC52WD7AHRXOzVJ1C4tW2A7w/featured
#sql #server