filmov
tv
How to Create User Account in SQL Server Tutorial
Показать описание
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
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
0:05:21
How to Create a New User Account on Windows 10
0:01:25
How to Create a New User Account on Windows
0:00:14
Creating new user account, microsoft windows 10. using compmgmt.msc
0:03:27
Windows 10: How to Create a New User Account!
0:00:42
How to Create User Account in Windows
0:02:16
How to Create User Account in Windows 11
0:01:47
Windows 10 - How to Create a New User Account
0:04:18
How to Create a New User Account on Windows 10 | How to Create a Guest User Account
0:02:10
How to Create a WeChat Account Without a QR Code | No Invite or Scan Needed!
0:02:19
How to Create a New User Account on Windows 11 (2022)
0:00:57
Create a new user account in Windows 10
0:03:17
How to create Multiple User Accounts in Windows 11
0:04:56
Create User Accounts with Active Directory - The Easy Way!
0:02:17
How to create new user account in laptop pc
0:00:14
How to Create user account with CMD- Windows 11
0:00:45
How to create new user accounts on pc? #newuser #accountcreate #windows #laptop #pc #tech #shorts
0:00:27
Change a user to an Administrator Account | Short Tips
0:00:42
How to create user account with command
0:00:28
Create User account using CMD
0:02:26
How to Create a New User Account in Windows 10 PC or Laptop - 2 Method
0:01:19
How to create a user account on windows 7
0:01:25
How To Create User Accounts On Mac
0:06:07
How to Create a New User Account in Windows 11
0:06:37
Ubuntu Tutorials create user accounts (2 ways)
Комментарии