Login failed for user 'sa' while trying to create datasource with Railo

Question

So I'm trying to setup Railo and I want to add a datasource. For the database I'm using Microsoft SQL server Management Studio. But now I've run into the classical problem: "Login failed for user 'sa'. ClientConnectionId:afd80ac2-0744-4a7d-a9f7-083d93adee0d"

What I've done so far:

• With the SQL Server Configuration Manager in the TCP/IP settings I enabled the IPs I had to.

• I set the password for the user 'sa' in MSSQL and I added a user mapping for the table I want to use.

• I made the user 'sa' the owner of the DB i want to connect to
• Restarted the SQL service, my computer and Railo multiple times.

I'm pretty much out of ideas.

Answer 1

After Leigh mentioned in the comments to look at my logs it had the following message: "Login failed for user 'max'. Reason: Failed to open the explicitly specified database 'test'. [CLIENT: 127.0.0.1]"

I then tried to make a connection without mentioning a database and that worked.

Answer 2

I would also point to Leigh's answer here which explains how to turn Mixed-Mode authentication on, as this can also cause this error. Since the cause of this isn't on Railo/Lucee's end, this issue still arises in 2018.

I just don't want a useful answer to get lost to history, nor plagiarize an answer I barely found.