MSSQL Tips

sql server error 15401 : SQL Create Login Failure

It was due to that I'm using VM. So I have to change SID using NewSID 4.10.

Ref: http://blogs.technet.com/b/bpaulblog/archive/2011/05/16/sql-create-login-failure-microsoft-sql-server-error-15401.aspx

>> This does not work for Win7 Ultimate x64 in VMWare Fusion 3.1.3. I have to restore Windows.

Instead, setup .exe /ACTION=install /SKIPRULES=PerfMonCounterNotCorruptedCheck worked.

Ref: http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/a92b4fa5-6d30-4a55-ad06-b5c4ba0abea7/

 

Leave a comment

Please note that we won't show your email to others, or use it for sending unwanted emails. We will only use it to render your Gravatar image and to validate you as a real person.