sql_novice_2007 (2/23/2014)
Login failed for user. error 18456 when the user is not sysadmin. If I grant the user sysadmin previleges it's working fine.
Have you checked the default_database settings for this login? Does this login has a corresponding user in its default_database (in case the default_database is a user database & not a system database) & it has appropriate permissions on this database?