We are replicating our SQL server database data using xoSoft Replication. While we were testing the failover scenario We noticed that data is replicated along with windows login but where ever we have SQl logins none of those logins work.
I thought it could be issue of SIDs and issued sp_change_users_login @Action='update_one', @UserNamePattern=, @LoginName=;
But still when i login using SQL logins I cannot access data.
Any idea how to fix this data?