SQL login not working after XoSoft failover

Posted on 2011-04-29
Last Modified: 2012-05-11
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?
Question by:vrao19
    LVL 7

    Expert Comment

    did you move the user at the server level?

    if not you can do it like this:

    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.


    Author Comment

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

    LVL 23

    Expert Comment

    by:Racim BOUDJAKDJI
    does xosoft support replicating database/object level priviledges replication.  If not, you'd better be using native SQL replication or database mirroring

    Author Comment

    How will i know does xosoft support replicating database/object level priviledges replication?
    LVL 23

    Expert Comment

    by:Racim BOUDJAKDJI
    I do not know.  I use only native replication.

    Accepted Solution

    Found my mistake. I didnot had the SQL server under mixed mode..I know so dumb..but got resolved.

    Author Closing Comment

    Sql server in Mixed mode

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Finally comes the third version of VMware Virtual SAN, whose name is 6.1, and comes loaded with new features many of which really are excellent and even surprising.
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    6 Experts available now in Live!

    Get 1:1 Help Now