Unable to Setup Logical doc Community using Microsoft SQL

[phegdecfc]

Hi,

Has anyone used Microsoft SQL as the database? I have created the database "logicaldoc" and have created a login for it , but when I click next it throws an error "Database not connected".

Do you know where I am going wrong?
Attached is the error.

Thank you!

[phegdecfc]

I fixed the problem.
I had not enabled "SQL authentication mode".

For people who have the same problem, here is the solution.


1. Right click on the Server Instance in the Object explorer on SQL Management Studio
2. Select "Properties"
3. Select "Security" option
4. Change "Server authentication" to "SQL Server and Windows Authentication mode"
5. Restart the SQLServer service on SQL Server Configuration Manager
a. Right click on instance
b. Click "Restart"

[shatzing]

Thanks for sharing your experience !