Getting "Cannot open user default database. Login failed." for connections that don't specify a default database
That error either means that the default database does not exist or that it is not accessible to the user. Try to set tempdb as the default and see if that helps.