locked
SQL Server: login fails in DB Mirroing after executing transfer Login Task RRS feed

  • Question

  • Hi ALL,

     

    I setup DB mirroring.to sysnc up login in both the sever (prim and secondry), i execute Transger login task.with COPY SIDs and Overwriting logins. when i executed the task secondary failed to login even system admin can't login.

    for Sec server to work i put it in single user mode and ten started but there

    ##MS_PolicyTsqlExecutionLogin## ##MS_PolicyEventProcessingLogin## end NT Authority missing.

    when i try to open Error log it shows me severe error detected. how can i rollback system to normal state?

     
    manish
    Saturday, June 4, 2011 9:16 AM

Answers

  • I think you have completely messed up your logins in SQL server , do you have a master database backup on the secondary server before you did this change ? If yes , build a new SQL server in your test environment and restore your master database , from there you can script out all the logins with their permissions and execute it on your secondary server.

    Can you also post the error log msg here ? You could add yourself or anyother login into SQL server when you start SQL server under minimal config and single user mode.


    Thanks, Leks
    Sunday, June 5, 2011 10:10 PM
    Answerer

All replies

  • manish

    Something went wrong with Transfer login task, what if you re-create manually all logins on the secondary and then start testing?


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Sunday, June 5, 2011 7:13 AM
  • I think you have completely messed up your logins in SQL server , do you have a master database backup on the secondary server before you did this change ? If yes , build a new SQL server in your test environment and restore your master database , from there you can script out all the logins with their permissions and execute it on your secondary server.

    Can you also post the error log msg here ? You could add yourself or anyother login into SQL server when you start SQL server under minimal config and single user mode.


    Thanks, Leks
    Sunday, June 5, 2011 10:10 PM
    Answerer
  • Why don't recreate them manually on mirroring server.... here is help to transfer logins with T-SQL script http://support.microsoft.com/kb/918992

     


    http://uk.linkedin.com/in/ramjaddu
    Wednesday, June 8, 2011 9:27 AM