ColdFusion · Database exception
What does Cannot Open Database Requested By The Login mean in ColdFusion?
SQL Server authenticates the login ColdFusion is using but that login has no permission on, or default access to, the specific database the datasource targets. It's distinct from a plain login failure — the credentials are valid at the server level, just not scoped to the database in question.
SQL Server authenticates the login ColdFusion is using but that login has no permission on, or default access to, the specific database the datasource targets. It's distinct from a plain login failure — the credentials are valid at the server level, just not scoped to the database in question.
In SQL Server, explicitly map the datasource's login to the target database with appropriate role membership rather than assuming server-level access is enough, or add AuthenticationMethod=ntlm and grant the CF service account access when using Windows authentication.