This type of error usually occurs when the default database defined for the login is not accessible by this login (either no permission or does not exist)