SQL login not working after XoSoft failover

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?
vrao19Asked:
Who is Participating?
 
vrao19Connect With a Mentor Author Commented:
Found my mistake. I didnot had the SQL server under mixed mode..I know so dumb..but got resolved.
0
 
CboudrozCommented:
did you move the user at the server level?

if not you can do it like this:
http://support.microsoft.com/kb/246133


if yes you can try to fix the SID assosiation by this command:

execute sp_change_users_login 'auto_fix', 'UserName'

if still not working let me know what's the error message.

0
 
vrao19Author Commented:
The xoSoft replicated the server level login. I have executed the above command and this is not fixing the problem.

thanks
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
does xosoft support replicating database/object level priviledges replication.  If not, you'd better be using native SQL replication or database mirroring
0
 
vrao19Author Commented:
How will i know does xosoft support replicating database/object level priviledges replication?
0
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
I do not know.  I use only native replication.
0
 
vrao19Author Commented:
Sql server in Mixed mode
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.