When working with SQL you'll often run into this problem
It arises when a database owner User Id exists without a Login ID or Login Password
First Find Your Orphans
(substitute into brackets)
USE ['Database'];
GO
EXEC sp_change_users_login 'Report';
GO
Now Repair That
Then create a new Login ID and Login Password for the orphaned User Id
(substitute into brackets)
USE ['Database']
GO
EXEC sp_addlogin ['NEW LOGIN ID'], ['NEW LOGIN ID PASSWORD'], ['DATABASE']
EXEC ['Database'].['INFORMATION SCHEMA'].sp_change_users_login 'Update_One', ['USER ID'], ['NEW LOGIN ID']
Go