locked
Error 15401. cross domain sid history from user migrated . RRS feed

  • Question

  • Hi .

    I have two domains. Domain A is old 2003 functional level  and Domain B is new 2012 functional level. We have users migrated from domain A to Domain B with Sid history .

    SQL server is built on domain B and users are added to SQL logins from Domain A . We are experiencing Error 15401 . If we remove the sid history from user in Domain B . It all works fine .

    We are in middle of moving all our infrastructure to new domain and cannot really remove sid history from users in Domain B at this time.

    Not sure why SQL server 2014 is acting wiered. Our SQL server is 2014 Enterprise . Can you point me to any hotfix /workaround etc.

    Thanks

    Mumtaz

    Tuesday, September 20, 2016 10:52 AM

All replies

  • Hi Mumtaz,

    Refer the following link

    https://thesqldude.com/2012/10/17/error-15401-when-trying-to-create-a-new-windows-login/


    Please click Mark As Answer if my post helped.

    Wednesday, September 21, 2016 11:10 AM
  • Hi , 

    This hasn't resolved my issue . 

    thanks

    mumtraz 

    Thursday, September 22, 2016 4:39 PM
  • Hi mumtaz khan MS,


    Thanks for your question.


    I am trying to involve someone more familiar with this topic for a further look at this issue. Sometime delay might be expected from the job transferring. Your patience is greatly appreciated.


    Thank you for your understanding and support.


    Regards,
    Lin
    Friday, September 23, 2016 7:00 AM
  • Hi Lin

    Thanks for looking into this . We have also tried to to increase the kerberos token size on the servers and clients but still no joy. 

    Thanks

    Mumtaz 

    Friday, September 23, 2016 8:23 AM
  • Hi, mumtaz khan MS

    Please try below workaround

    1) Create a new group in new domain
    2) Create login of new group in SQL Server
    3) Add users of old domain to the new group

    Monday, September 26, 2016 7:56 AM
  • Hi Lin 

    any update on this . I couldnt find any solution yet.

    thanks

    mumtaz 

    Tuesday, March 14, 2017 7:35 PM