"Ensure that SQL authentication" message is enabled when downloading Studio

I am trying to restore a DB, and I have been unsuccessful. I have tried uninstalling and reinstalling Studio several times today (the same with SQL express). I keep getting some really strange errors. so I had to uninstall again. I am wondering if someone knows how to make sure that SQL authentication is enabled. I am hoping that might be my issue

Comments (1)


Dear Joan,

Regarding this message, you need to make sure to enable SQL Server authentication, like this image:


In addition, make sure to have enabled the sa user with his password. To set up SQL Server correctly, please follow this article:

Best Regards