Enable Mixed Mode Authentication - Ms SQL

1. Enable Mixed Mode Authentication

1. Open SQL Server Management Studio (SSMS) and connect using Windows Authentication.
2. Right-click your server in Object Explorer → Properties.
3. Go to Security → select SQL Server and Windows Authentication mode.
4. Click OK.
5. Restart the SQL Server service for changes to take effect.

2. Enable and Set Password for sa Login

1. In SSMS, expand Security → Logins.
2. Right-click sa → Properties.
3. Set a strong password.
4. Under Status, set Login to Enabled.
5. Click OK.

3. (Optional) Create a New SQL Login

CREATE LOGIN MyUser WITH PASSWORD = 'StrongP@ssw0rd!'; ALTER SERVER ROLE sysadmin ADD MEMBER MyUser; -- or assign specific roles

4. Connect Using SQL Authentication
When connecting in SSMS or your application, choose:

• Authentication: SQL Server Authentication
• Login: sa (or your new username)
• Password: your set password

💡 Tip: Always use a strong password and avoid giving sysadmin rights unless necessary. For production, create logins with only the permissions they need.