Hi experts,
I'm trying to add new Windows authentication user on sql server 2008 r2. I founded user on domain and user but I'm unable to create windows authentication user and I'm getting error 15401.
How to troubleshhot this issue what are the steps I need follow n
This error could occur for several reasons. Some of the most frequent reasons are 1.Case sensitive collation for SQL Server. 2.Multiple domains with the same account name with the same SID.
Thank you Very Much sir for quick replay, as per you replay i followed steps 1. connected to vm as a domain administrator 2. then i followed as per this link 3.then it ask per change password 4. after that i removed database engine 4. then i again installed sql server database engine 5. now i'm able to add windows authentication users. http://www.misdivision.com/blog/how-to-change-an-sid-on-windows-server-2008-r2
Today we found root clause, the problem is the windows team was restored VHD for all VMS so SID (security indetifier) is same for all VMS.
Cool! I think I am also facing this problem in one of the VM (Hyper-V on Win8), which I copied and made another VM. Let me try the same and see if it helps.
I created a VM with Active Directory. Then I copied the VHD and created another VM with SQL Server. Some stuff is already installed and working. Does the above solution only works if we are doing it from scratch? Do I need to rebuilt the VMs once again now? Can I fix the VM's SID without rebuilding them?