I can access my databases through SQL Server Management Studio (SSMS) by using my Windows account no problem.
I have two issues though:
I want to enable
sa
and then try to log in usingsa
and the password. I get this error:I enabled the SQL Server authentication:
I tried to create a new user, but that user cannot connect either:
How can I fix this?