Getting error Login Failed for user
When I try to change my database to Microsoft SQL Server, I get the error: “Can’t connect to the database Login failed for user but my username and password are correct:
Best Answer
If you are using Windows authentication, rather than SQL Server Authentication, you have to perform the following steps to enable FLOW to use the database.
- Download SQL Server jdbc drivers from https://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774
- Copy sqljdbc_auth.dll and sqljdbc4.jar from the JDBC install into the \server\lib directory
- update database.properties file located in \conf\database.properties and add the following to the bottom:
COMMANDER_CUSTOM_DB_URL=jdbc\:sqlserver\://\:1433;domain\=;databaseName\=;applicationName\=ElectricCommander;selectMethod\=direct;integratedSecurity\=true
