sql-serversql-server-2012cfmlrailolucee

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


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:

I'm pretty much out of ideas.


Solution

  • 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.