Login failed for user % Reason: Failed to open the explicitly specified database.

 

Common error that occurs with permission issues that when the user either does not have access to view the database or it doesn’t exist. Application connecting to SQL Server normally will contain more information about the error. For example ColdFusion below

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot open database "DBNAME" requested by the login. The login failed.