1. Open central admin
2. Goto Operations
3. Goto Services on server and located your index server
4. On “Office SharePoint Server Search” click “Stop”. This deconfigures it.
5. Now click “start”
6. Then click “Shared Services Administration”, hover over the failing SSP and select edit.
7. You will notice now the indexer is not selected. Select it from the drop down.
8. HERE IS THE IMPORTANT PART. The server you have selected is probably the same server as you used before. If it is, go to that server and locate the indexer files. It is in the textbox right below the drop down you just used. For me it was “F:\Program Files\Microsoft Office Servers\12.0\Data\Office Server\Applications”. In there you will find a folder with Guid name. At the end of that folder add “_old”. Now go back to your SSP and click OK. Wait 1 minute and the index will recreate the guid folder.
9. Tada, all fixed.

To turn it off just run this from command line

powercfg -h off

Enjoy.

Detail are here

sp_detach_db [YourDatabaseName]

then

sp_attach_db @dbname = N‘YourDatabaseName’,
@filename1 = N‘D:\Microsoft SQL Server1\MSSQL\Data\YourDatabaseName.MDF’

Fix is here

In short do the follow. The reboot is necessary.

Method 2: Disable the loopback check

Follow these steps:

1. Click Start, click Run, type regedit, and then click OK.
2. In Registry Editor, locate and then click the following registry key:
   HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa
3. Right-click Lsa, point to New, and then click DWORD Value.
4. Type DisableLoopbackCheck, and then press ENTER.
5. Right-click DisableLoopbackCheck, and then click Modify.
6. In the Value data box, type 1, and then click OK.
7. Quit Registry Editor, and then restart your computer.

Simple command to run from the C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727 directory

aspnet_regiis.exe –ga [UserName]

This will tell ASP.NET to allow this user to access temp directories and the assembly code.

An odd thing can happened in SharePoint. If you add a user named Joe Smith to a server, then add that user to SharePoint. Later you need to completely remove that user. So you delete the user from the server and you completely remove the user from sharepoint. (removed them from the user collection, not just the site)

One day comes and low and behold you need to add Joe Smith to the server again. You create a new user account for Joe on the server and add Joe to SharePoint. The only issue is that SharePoint doesnt resurrect the user from SharePoint. It creates a new one. And now when you are in a page that was originally created by the 1st Joe Smith you get the error above. Yippy.

If you run the SQL below you will find the two Joe Smith accounts.

SELECT * FROM UserInfo WHERE tp_Login = ‘MYSERVER\Joe.Smith’

You will get results like this

No User SQL

 The field tp_ID is the SharePoint UserID. The field sp_Deleted tells SharePoint if the user has been deleted. When you manually flag a user as deleted, all you have to do is to put the user’s ID in the tp_Deleted field. Notice that the user 19 has 19 in the tp_Deleted field.

So to resurrect the user 19 I need to kill user 16 since they both have the same username. The way I do that is simple

http://confluence.atlassian.com/display/JIRAEXT/How+to+export+a+list+of+users+from+Active+Directory

 static void Main(string[] args)
        {
            bool requireApproval = false;

            // open the site
            SPSite site = new SPSite(http://YOUR_SITE);
            // open the web
            SPWeb web = site.OpenWeb();

            ProcessWeb(web, requireApproval);

            return;

            // open the web collection
            SPWebCollection webcoll = web.Webs;

            // parse through the webs
            foreach (SPWeb webx in webcoll)
            {
                ProcessWeb(webx, requireApproval);
            }

            Console.Read();
        }

        public static void ProcessWeb(SPWeb webx, bool requireApproval)
        {
            Console.Write("Processing " + webx.Url + "\n");

            // get the list
            SPListCollection lists = webx.Lists;

            // looks for our Pages list
            foreach (SPList siteList in lists)
            {
                if (siteList.Title == "Images")
                {

                    //PublishingWeb pweb = PublishingWeb.GetPublishingWeb(webx);

                    //PublishingPageCollection ppages = pweb.GetPublishingPages();

                    bool fixSite = false;

                    siteList.EnableModeration = false;
                    siteList.ForceCheckout = false;
                    siteList.AllowEveryoneViewItems = false;
                    siteList.DraftVersionVisibility = DraftVisibilityType.Reader;
                    siteList.Update();

                    fixSite = true;

                    if (siteList.WorkflowAssociations.Count > 1)
                    {
                        SPWorkflowAssociationCollection wfCol = siteList.WorkflowAssociations;
                        SPWorkflowAssociation wf = wfCol.GetAssociationByName("Parallel Approval", System.Globalization.CultureInfo.CurrentCulture);

                        wf.Enabled = false;

                        siteList.UpdateWorkflowAssociation(wf);
                    }
                }
            }

            if (webx.Webs.Count > 0)
            {
                foreach (SPWeb webNext in webx.Webs)
                {
                    ProcessWeb(webNext, requireApproval);

                }
            }
        }