How to enable SQL authentication in Microsoft SQL Server 2019

In this video tutorial you can learn How to enable sequel authentication in Microsoft SQL server 2019
see how to download and install SQL Server 2019
• How to install SQL Ser...
For any support contact:
Skype: Sachin.Samy
WhatsApp: wa.me/91852711...
Email: [e-mail]

[@hubbellrowe9012]

Just what the doctor ordered. Thanks so much! Nothing changed as of 2024. Same exact steps still apply.

[@SachinSamy]

Your welcome

[@Balajiji4888]

Thank you sir for making this video It is much Usefull

[@SachinSamy]

Thank you for watching the video don't forget to like share and subscribe

[@AndreasGrimen]

This was very helpful, you saved my day!

[@SachinSamy]

You are most welcome and thank you for watching the video don't forget to like share and subscribe

[@khalilroot6410]

Thank you sir. You are the best! Still working in 2023

[@SachinSamy]

Thanks 👍

[@sakhaaskari3391]

Thank a lot for helping me with my homework ! you are my hero✨✨

[@SachinSamy]

You're welcome 😊

[@plaguegames3556]

Thanks a lot Sachin.
Guys if you are still having problems you can make the encryption optional and it will work out.

[@SachinSamy]

Welcome

[@horrorfactory770]

Thank you so much Sir ! It worked. I liked & subscribed.

[@SachinSamy]

You are welcome and thank you for like and subscribe to the channel

[@ahsansaleem2513]

thanks a lot Your Video made my day

[@SachinSamy]

You're welcome

[@chetanpatil9142]

thanks brother you save my 1000rs

[@SachinSamy]

Your welcome

[@nagavarmadandu1027]

perfect guy to resolve this problem

[@codewithmashkoor]

Thank you sir , it was really helpfull
you are genius professor 🤩🤩🤩🤩🤩

[@SachinSamy]

Most welcome

[@parrimasthanaiah4424]

Super explain thank🌹 you sir.

[@niroshanparanayapa8111]

Thank You😘
You are genius prof

[@SachinSamy]

Thank you 😊

[@HemantKumar-xl5dv]

thanku for saving my time

[@SachinSamy]

You are welcome to forget to like share and subscribe

[@JohnBergAndersen]

Thanks a lot. Your video saved my day :)

[@SachinSamy]

Your welcome thanks for watching the video

[@lokeshshinde2861]

Thank you sir. You are the best!

[@SachinSamy]

You're welcome!

[@vedaantwagh186]

thanks a lot, it was really helpful

[@SachinSamy]

Glad it helped!

[@hiralpatel6656]

thank you sir...............................

[@The0xyg3nz]

welcome back sachin samy 🙋‍♂️

[@javaremastered1530]

thank you i lost 1 night on this

[@SachinSamy]

Your welcome

[@WeedsePoentah]

The properties are not showing up when right clicking inside the object explorer even though I am in fact server admin according to the azure portal

[@User_jkjsbbk]

Thank you so much, you saved my life )

[@SachinSamy]

Welcome

[@shivanikumari9608]

thank u brother, ur video helped me a lot

[@damilolaadeogun6507]

Thank you very much 👏

[@SachinSamy]

Welcome

[@wssameera5247]

Thanks👍👍👍👍

[@SachinSamy]

Welcome

[@thusharapriyakalum3834]

Thank you❤

[@SachinSamy]

Your welcome

[@KamranKhanmba]

how to solve SSL when connecting thru java eclipse?
2014 sql server i downloaded from watching your video and also download jdbc sql
driver

[@AdarshAchar-o1v]

Thank You

[@SachinSamy]

You're welcome

[@shaiksubhani5882]

after i doing this process till i can't get the sql server authentication as USER

[@chiragmehandiratta4580]

SQL server authentication is automatically looked out after few minute. So Please tell how to resolve this issue

[@AcostaMarkArchieB.-rq6gi]

Thanks a lot sir!

[@SachinSamy]

Your welcome

[@ketkipatil8309]

Thank you , worked for me!

[@SachinSamy]

Thank you 😊

[@academai11]

thanks bro

[@SachinSamy]

You are welcome and thanks watching the video don't forget to like share and subscribe

[@merus2906]

Thank you bro, I need it for doing my project : D

[@emmanuelkapambwe2013]

thanks, it worked for me

[@uno234567ocho]

THANKS!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

[@SachinSamy]

Welcome

[@mrafaqatpk]

thanku so much

[@mostafahussien1239]

Thank you😇😇 sir

[@jmff051]

very good!

[@SachinSamy]

Thank you! Cheers!

[@duggu9626]

Good one

[@palasharya]

How to check the port number to configure it with another application ?

[@amarkhandekar5041]

Great

[@ankitsaxena3447]

Thanks

[@SachinSamy]

Welcome

[@asddfgist]

in what case it give the bellow msg ,and how it is resolved
User does not have permission to perform this action. (Framework Microsoft SqlClient Data Provider

[@SachinSamy]

Check you are logged in with the Admin user in SQL

[@rkgamer644]

Thank you for sharing

[@aditiphalke6610]

Thank you😇😇

[@BADPRASGAMER]

Thanks bro it's working ❤️

[@kiranshettyb]

IF BOTH WINDOWS AND SQL SERVER AUTHENTICATION ARE DISABLE HOW TO ENABLE BOTH

[@SachinSamy]

If both SQL Server Authentication and Windows Authentication are disabled and you cannot access the SQL Server instance, you’ll need to follow a process to regain access and enable authentication modes. Here’s how to handle the situation when neither authentication method works:
1. Start SQL Server in Single-User Mode
Since both authentication modes are disabled, you need to start SQL Server in Single-User Mode to get administrative access and re-enable authentication.
Steps to start SQL Server in Single-User Mode:
1. Stop the SQL Server Service:
Open SQL Server Configuration Manager.
Under SQL Server Services, right-click on the SQL Server instance you want to manage and click Stop.
2. Run SQL Server in Single-User Mode:
Open a Command Prompt with Administrator privileges.
Navigate to the SQL Server binary path, typically something like:
cd "C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Binn\"
(Change the path based on your SQL Server version and instance name).
Start SQL Server in Single-User Mode by running the following command:
sqlservr.exe -m
3. Connect to SQL Server in Single-User Mode:
Open SQL Server Management Studio (SSMS).
Use Windows Authentication to connect to the server. Since the server is running in Single-User Mode, only one connection is allowed, so ensure SSMS connects successfully.
2. Enable SQL Server and Windows Authentication Mode
Once connected in Single-User Mode, follow these steps to enable SQL Server Authentication and Windows Authentication:
1. In SSMS, right-click on the server in Object Explorer and choose Properties.
2. Go to the Security page.
3. Under Server Authentication, select SQL Server and Windows Authentication Mode (Mixed Mode Authentication).
4. Click OK.
3. Restart SQL Server
After making the change, go back to SQL Server Configuration Manager and restart the SQL Server service to exit Single-User Mode and apply the new authentication settings:
Right-click on your SQL Server instance and click Start.
4. Enable the "sa" Account and Set Password
Open SSMS again, connect to your instance, and enable the sa account if needed:
Navigate to Security → Logins.
Right-click on the sa account and choose Properties.
Under the Status page, ensure Login is set to Enabled.
Set a strong password for the account in the General tab.
5. Verify and Test Access
Once everything is enabled:
Test both Windows Authentication and SQL Server Authentication using SSMS to ensure everything is working properly.

[@bnglre]

Good one - Thanks

[@shmeklz]

THE BEST 💪🇺🇦😎

[@chandrabhushansingh6886]

genius man🙌

[@gobi.b2369]

🌛🌜

[@deolsandy]

Thank You

[@SachinSamy]

You're welcome

[@shri11.11]

Thank you so much

[@playing7294]

Thank you ❣️

[@SachinSamy]

You are so welcome

[@pratikmurke3314]

thank u so much