• SQLCrazyCertified (6/26/2013)2013-06-26 15:21:14.642 Agent message code 20052. The process could not access database ‘DatabaseName’ on server 'ServerName'.

    2013-06-26 15:21:14.642 Category:NULL

    Source: Microsoft SQL Native Client

    Number: 4060

    Message: Cannot open database "DatabaseName" requested by the login. The login failed.

    According to the error it looks like the process is able to connect to the SQL instance, but not able to access the database. Check if the login account has enough permission to the database ‘DatabaseName’ on server 'ServerName'. Also check the SQL Server log on server 'ServerName' for additional logging about the failed login. These additional logging could be resolved to a cause with Aaron Bertrands log at http://sqlblog.com/blogs/aaron_bertrand/archive/2011/01/14/sql-server-v-next-denali-additional-states-for-error-18456.aspx

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **