Today one of my Clients wanted to add a server to the farm and had forgot the Farm passphrase . it had been a day and he was not able to find the right one . He had not documented the same .
We tried researching on how to retrieve the Passphrase however were not able to find the right Solution . May be its possible to pull from the sql server after running some Query however was not able to find one
I Came to know that there is no way to lookup the Passphrase in the Database and the only way is to reset the Passphrase and without a valid database or SQL connection this is not possible .
The Best way i could find is to Reset the passphrase using the Powershell commands .
Start => All Programs => Microsoft SharePoint 2010 Products => SharePoint 2010 Management Shell right click the link and run as administrator.
At the PowerShell prompt input
$passphrase = ConvertTo-SecureString -asPlainText –Force
You will be asked to input a new passphrase in plain text.
Set-SPPassPhrase -PassPhrase $passphrase –Confirm
After inputting the command above you will be asked to reenter the new passphrase
Enter Y = Yes N = No to complete the change.
Once it is done run the Wizard. and you will be able to add the server to the farm with the new passphrase .
It may Happen that you may get some error related to Sql . At this point of time as you have lost the connectivity with Sql
Check for all the permissions of the account you are logged in with on the sql . At times still it would not connect . then the only thing is disconnect the server from the farm and reconnect it
Note : If you know how or if you have any Idea of retrieving the Passphrase Please share .
We tried researching on how to retrieve the Passphrase however were not able to find the right Solution . May be its possible to pull from the sql server after running some Query however was not able to find one
I Came to know that there is no way to lookup the Passphrase in the Database and the only way is to reset the Passphrase and without a valid database or SQL connection this is not possible .
The Best way i could find is to Reset the passphrase using the Powershell commands .
Start => All Programs => Microsoft SharePoint 2010 Products => SharePoint 2010 Management Shell right click the link and run as administrator.
At the PowerShell prompt input
$passphrase = ConvertTo-SecureString -asPlainText –Force
You will be asked to input a new passphrase in plain text.
Set-SPPassPhrase -PassPhrase $passphrase –Confirm
After inputting the command above you will be asked to reenter the new passphrase
Enter Y = Yes N = No to complete the change.
Once it is done run the Wizard. and you will be able to add the server to the farm with the new passphrase .
It may Happen that you may get some error related to Sql . At this point of time as you have lost the connectivity with Sql
Check for all the permissions of the account you are logged in with on the sql . At times still it would not connect . then the only thing is disconnect the server from the farm and reconnect it
Note : If you know how or if you have any Idea of retrieving the Passphrase Please share .
Thank you for sharing this valuable information!!
ReplyDeleteHere is an utility which work very efficiently to recover data from corrut or inaccessible sharepoint database. Download the free trial version to get the preview of original recoverable results.
ReplyDeletehttp://www.recoverydeletedfiles.com/sharepoint-server-data-recovery.html
Thanks
Thanks for sharing the Info
DeleteWith the help of this user-friendly tool http://www.repairsharepoint.com you can effectively restore or recover all the data from corrupt SharePoint. The utility works with two different modes Raw file mode and Live SQL Instance mode.
ReplyDeleteHave a look at this tool, I found this one very useful. http://www.filesrepairtool.com/sharepoint-database-repair.html/
ReplyDeleteSharePoint Server can damage or corrupted due to so many reasons like: virus attack, sudden system shutdown, hardware/software malfunctioning etc. Try to extract SharePoint file database with Recovery software of SharePoint. Download it here: http://www.filesrecoverytool.com/sharepoint-database-repair.html/
ReplyDeleteIdeal solution to recover documents, files and websites from SharePoint databases. The software very well undertakes the SharePoint database recovery process in a simple and easy manner.
ReplyDeleteRead More Details:- http://www.pcrecoverytools.com/sharepoint-database-recovery.html
Another Sharepoint Recovery software which can easily and safely and efficiently repair SQL Server files and SharePoint databases to get back all the important business data, documents, metadata and site content on SharePoint server from damaged SharePoint database.
ReplyDeleteGo through: http://www.softmagnat.com/sharepoint-recovery.html