Tuesday, 29 June 2010

Disabling Windows Loopback Check for SharePoint Server 2007

The loopback check will cause constant password prompts appear whenever using host headers in SharePoint 2007. To get around this, you can make exceptions in the Loopback Check security feature, or completely disable it. The steps on how to sort this, are below:

Dev Environments (Less Secure Method)
  1. Click Start > Run > type 'regedit' > 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.

Live Environments (More Secure Method)

  1. Click Start > Run > type 'regedit' > OK
  2. In Registry Editor, locate and then click the following registry key: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa\MSV1_0
  3. Right-click MSV1_0, point to New, and then click Multi-String Value.
  4. Type BackConnectionHostNames, and then press ENTER.
  5. Right-click BackConnectionHostNames, and then click Modify.
  6. In the Value data box, type the host name or the host names for the sites that are on the
  7. local computer, and then click OK.
  8. Quit Registry Editor
  9. Restart the Computer

If you are doing this on SharePoint, you will need to do this on all SharePoint servers in the Farm.

SharePoint 2007 Anonymous Access and STSADM Lockdown

To setup Anonymous Access, please see the below basic steps (remember to change the URL):
  1. Logon to the SharePoint Server
  2. Open Command Prompt
  3. Edit and type the following command: stsadm -o activatefeature -url http://intranet -filename ViewFormPagesLockDown\feature.xml
  4. Still in command prompt, edit and type the following command: stsadm -o deactivatefeature -url http://intranet -filename ViewFormPagesLockDown\feature.xml
  5. Finally, open Central Administration and click Application Management > Authentication Providers and select the relevant Web App you wish to enable Anonymous Access on
  6. Toggle Enable Anonymous Access check box (go in and out of this screen, essentially leaving Anoynmous Access turned on and thus toggling it)

From here, as long as the site collection should be ready to go.

Configuring the Adobe PDF iFilter for SharePoint 2007

Below are steps for installing the x64 Adobe PDF iFilter for SharePoint 2007:


  1. First of all, install the x64 Adobe PDF iFilter to the SharePoint index server. This file can be found on the Adobe website, or by searching Google
  2. When installed, open Central Administration on the index server
  3. Open the SSP thats relevant to the iFilter
  4. Click Search Administration under the Search heading
  5. Click File Types
  6. Click New File Type
  7. Type pdf and click OK

Next, we need to verify that PDF has been added to the registry correctly:

  1. Run Regedit by browsing to c:\Windows\system32\regedt32.exe
  2. Within the left hand side tree, browse to: \\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office Server\12.0\Search\Applications\{site GUID}\Gather\Portal_Content\Extensions\ExtensionList
  3. If PDF extension is present, skip to Step 8 to verify the second location. If PDF extension is not present, continue with the next step
  4. Right click on right-side Extension List pane and choose New > String Value
  5. Add a name to the new Registry Key (e.g. “38” - basically the next in line)
  6. Double click the new Registry Key. For Value data, enter pdf
  7. This would automatically add an entry for ‘pdf’ filetype as mentioned above
  8. Verify that PDF has the correct settings in a second registry location.
  9. While still in Regedit, within the left-side tree, browse to: \\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office Server\12.0\Search\Setup\Filters\.pdf
  10. Verify the following values. If values are not as shown, edit them.
    i. Default =
    ii. Extension = pdf
    iii. FileTypeBucket = 1
    iv. MimeTypes = application/pdf
  11. Verify that PDF has the correct settings in a third registry location.
  12. While still in RegEdit, within the left-side tree, browse to: \\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office Server\12.0\Search\Setup\ContentIndexCommon\Filters\Extension\.pdf
  13. Verify the following values. If values are not as shown, edit them.
    i. Default = {E8978DA6-047F-4E3D-9C78-CDBE46041603} OR {56BD18AD-CF9C-4110-AAAA-B2F96887D123}

The final part, is to sort out the PDF Icon. If you search on the internet, there are plenty of 16x16 PDF Icons about. Firstly obtain this, and proceed with the following steps on the index server.

  1. Copy the 16x16 PDF Icon you have downloaded to the following location:
    C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\IMAGES
  2. Add an entry in docicon.xml for the pdf icon by copying/pasting and adjusting one of the other entries on a new line. The location for this XML file is:
    C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\TEMPLATE\XML

The last thing to do is restart all SharePoint services as well as IIS:

  1. Launch the Command Prompt by clicking Start > All Programs > Accessories > Command Prompt
  2. Type the following at the prompt: “net stop osearch”. Wait for success message.
  3. Type the following at the prompt: “net start osearch”. Wait for success message.
  4. Type the following at the prompt: “iisreset”. Wait for success message.
  5. Close the Command Prompt window.

Microsoft Office SharePoint Server can now index PDF files. Also, the PDF icon should show in File Types list in Central Administration and therefore along side the search results that appear.

Moving SQL Databases

SQL Steps for moving databases to another drive are outlined below. This example is for SharePoint 2007 databases, that are on SQL 2005:

  1. Logon to SharePoint and stop the relevant IIS Website
  2. Logon to SQL, and right click the server name and click Properties
  3. In the dialog box, click Database Settings on the left, and change the default locations for all new databases
  4. Now, right click a relevant database and click Tasks > Detach...
  5. When the box appears, check the exact database and log file names and make NOTES of them
  6. Select the Drop Connection checkbox
  7. Click OK
  8. The database should now dissapear from the left pane
  9. Still on SQL, open Windows Explorer and locate the MDF and LDF files, and copy and paste them to the new drives and make a note of the new location
  10. In SQL Manager, Right click Databases and select Attach and point to the new locations for the MDF and LDF Files
  11. Start the Website in IIS on SharePoint

From here, check the site works. If the pages cannot be displayed, it maybe due to the SQL Database permissions being incorrect. You may need to check to see if there is a DBOwner etc.

There maybe different considerations for databases that aren't for SharePoint 2007.

SharePoint 2007 Version Numbers

Below is a list of SharePoint 2007 and WSS 3.0 Version Numbers, which you can find in Central Administration's Site Actions > Site Settings screen.

12.0.0.6535
SP2 + April 10 CU (KB981042 + KB981043)

12.0.0.6529
SP2 + February 10 CU (KB978396 + KB978395)

12.0.0.6524
SP2 + December 09 CU (KB977027 + KB977026)

12.0.0.6520
SP2 + October 09 CU (KB974989 + KB974988)

12.0.0.6514
SP2 + August 09 CU (KB973400 + KB973399)

12.0.0.6510
SP2 + June 09 CU (KB971538 + KB971537)

12.0.0.6504
SP2 + April 09 CU (KB968850 + KB968851)

12.0.0.6421
SP2 (KB953338 + KB953334)

12.0.0.6341
February 09 CU (KB961755 + KB961756)

12.0.0.6335
December 08 CU (KB960010 + KB960011)

12.0.0.6331
October 08 CU (KB957691 + KB957693, KB958567 + KB958569)

12.0.0.6327
August 08 CU (KB956056 + KB956057)

12.0.0.6318
Infrastructure Update (KB951695 + KB951297)

12.0.0.6303
Post-SP1 Hotfix (KB948945)

12.0.0.6301
Post-SP1 Hotfix (KB941274)

12.0.0.6300
Post-SP1 Hotfix (KB941422)

12.0.0.6219
SP1

12.0.0.6039
October 2007 Public Update

12.0.0.6036
August 2007 Hotfix package

12.0.0.4518
RTM

12.0.0.4407
Beta 2 TR

12.0.0.4017
Beta 2

12.0.0.3111
Office 12 (PDC image - pre-beta) - This version of Office does not have a support link in the Add/Remove programs dialog box.