👋 Hey there! This video is for members only.
Please log in or create a free account below.
Login / Sign Up
🔐 Fixing “Login Failed” in SQL Server (Enable SQL Authentication)
If you’re getting a “Login failed for user” error, especially after creating a new SQL login, chances are SQL authentication isn’t enabled. Here’s how to fix it quickly.
✅ Steps to Enable SQL Server Authentication:
- Open SSMS
Right-click your server → Properties. - Go to Security Settings
Under Security, switch from Windows Authentication to SQL Server and Windows Authentication mode. - Apply Changes
Hit OK—you’ll get a message saying the server needs to be restarted. - Restart SQL Server
Open SQL Server Configuration Manager, find your SQL service, and restart it. - Reconnect Using SQL Login
Try connecting again using your SQL login—it should now work successfully.
Why it’s useful for early engineers:
Understanding SQL vs Windows authentication is crucial in real-world setups. You’ll often need to test different user roles, or simulate access for apps and services. Knowing how to enable and troubleshoot this saves time and builds solid foundational knowledge.