How to Create User In SQL Server | Login and User Security
today we will learn How to Create User In SQL Server | Login and User Security. If you want to SQL Server Connect with Your Own User Name and User Security. You need to Make Your Own User Name and Password.
How can You do that?
First of All, you need to Connect SQL Server with Windows Authentication Mode, then you need to Right Click On Your SQL Server Name, Properties, and You need to Select the Second Radio Button Namely SQL Server and Windows Authentication Mode.
Then you need to Restart the SQL Server, Then you need to Right Click Security Folder and Then Login, it has appeared on the right side under Object Explorer Panel, then New Login.
In this Page you need to Enter the User Name as you want to use in SQL Server to Connect, and Select Second Radio Button, then enter the password, then uncheck Enforce Password Expiration.
Then you need to Click Server Role Link, in this page, you need to Select sysadmin.
Then, you need to click User Role and Assign the Database as you want to assign with New User. Select the Database and Assign the Role as you like.
Then, you need to Click Securable Link, in this page, you need to Search the SQL Server Name, after searching the SQL Server Name than you need to Select the Third Option. and Click OK, that's it.
The Largest Hub of Tutorials In this Channel, you will a lot of Programming, Blogging, Digital Marketing, Web Development, Web Designing, WordPress, Google AdSense and Tips & Tricks. Basically, I will share helpful and beneficial videos tutorial. I humbly request to you please Subscribe My YouTube Channel for getting updates. Thanks
Follow us On
Watch more video
Trigger Tutorial In SQL Server For Beginners
Stored Procedure in Sql Server Tutorial For Beginners
How to Create Login Form in C# With Database
Student Registration System in C Sharp Windows Form Application
How to insert Update Delete in C# Windows Application