I am assuming this is the Orphan users script that you used:

USE DatabaseName

GO

EXEC sp_change_users_login 'Auto_Fix', 'LoginName'

GO

Can you login to the Server using the credentials via an ODBC DSN?