Wednesday, May 1, 2013

Forgotten your admin password? - Part 2

 In my previous blog with the same Title we discussed ways to reset the password for Admin user in-case we forgot them for Sitecore version 6.0 and above when Sitecore integrated ASP.NET Membership.

But with the launch of Sitecore 6.4 and above when Sitecore introduced PasswordSalt there's a change to the update query we discussed earlier. Below is the updated  query -

UPDATE [Sitecore_core].[dbo].[aspnet_Membership]
SET Password='qOvF8m8F2IcWMvfOBjJYHmfLABc=',
PasswordSalt='OM5gu45RQuJ76itRvkSPFw=='
WHERE UserId IN (SELECT UserId FROM [Sitecore_core].[dbo].[aspnet_Users] WHERE UserName = 'sitecore\Admin')


Thanks Patrick for bringing this up... :-)