I am trying to perform a database attach upgrade to SharePoint Foundation 2010.
At this point I am trying to attach the content database to a Web application by using Windows Powershell:
Mount-SPContentDatabase -Name -DatabaseServer -WebApplication [-Updateuserexperience]
I am following the directions from this TechNet article: Attach databases and upgrade to SharePoint Foundation 2010. When I go to mount the content database I am receiving this error:
Mount-SPContentDatabase : Could not connect to [DATABASE_SERVER] using integrated security: SQL server at [DATABASE_SERVER] has an unsupported version 10.0.2531.0. Please refer to “http://go.microsoft.com/fwlink/?LinkId=165761” for information on the minimum required SQL Server versions and how to download them.
At first this did not make sense because the default SharePoint Foundation 2010 website was running just fine. But then I realized that the default SharePoint Foundation site runs off of SQL Server Express and that I had just installed SQL Server Web Edition (since the database is greater than 4GB) and restored the database to this version of SQL Server.
Checking the documentation link above I see that SharePoint Server 2010 requires a 64-bit edition of SQL Server with the minimum required SQL Server versions as follows:
SQL Server 2008 Express Edition Service Pack 1, version number 10.0.2531
SQL Server 2005 Service Pack 3 cumulative update package 3, version number 9.00.4220.00
SQL Server 2008 Service Pack 1 cumulative update package 2, version number 10.00.2714.00
The version of SQL Server 2008 Web Edition with Service Pack 1 (the version I installed on this machine) is 10.0.2531.0.
Microsoft SQL Server 2008 (SP1) – 10.0.2531.0 (X64) Mar 29 2009 10:11:52 Copyright (c) 1988-2008 Microsoft Corporation Web Edition (64-bit) on Windows NT 6.1 (Build 7600: ) (VM)
But I had to read the article several times since the minimum version number for SQL Server Express is 10.0.2531.0. At first I thought I was good with the version of SQL Server 2008 Web that I had installed, also 10.0.2531.0. But then I read further to see that there is a cumulative update (hotfix) for SQL Server 2008 SP1 (NOT the Express edition) that is required for SharePoint 2010 and will bump the version number to 10.0.2714.00.
So the solution was to install the Cumulative update package 2 for SQL Server 2008 Service Pack 1 on my SQL Server 2008 Standard Edition to allow SharePoint 2010 to work with SQL Server 2008 (other than the SQL Server 2008 Express version).
SELECT @@VERSION (After installing Cumulative update package 2):
Microsoft SQL Server 2008 (SP1) – 10.0.2714.0 (X64) May 14 2009 16:08:52 Copyright (c) 1988-2008 Microsoft Corporation Web Edition (64-bit) on Windows NT 6.1 (Build 7600: ) (VM)
SharePoint Server 2010, like its predecessors, includes indexing and search capabilities. But what doesn’t come out of the box is the ability to index and search for PDF documents. PDF is a format owned by Adobe, not Microsoft. If you want to be able to find Adobe PDF documents, or have the PDF icon appear when viewing PDF files in a SharePoint document library (see image above), you will need to set it up for yourself. This post describes how to.
- Download and install Adobe’s 64-bit PDF iFilter*1 – http://www.adobe.com/support/downloads/detail.jsp?ftpID=4025
- Download the Adobe PDF icon (select Small 17 x 17) – http://www.adobe.com/misc/linking.html
- Give the icon a name or accept the default: ‘pdficon_small.gif’
- Save the icon (or copy to) C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\IMAGES
- Edit the DOCICON.XML file to include the PDF icon
- In Windows Explorer, navigate to C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\XML
- Edit the DOCICON.XML file (I open it in NotePad, you can also use the built-in XML Editor)
- Ignore the section and scroll down to the section of the file
- Within the section, insert attribute. The easiest way is to copy an existing one – I usually just copy the line that starts <Mapping Key=”png”… and replace the parameters for Key and Value (see image below)
- Save and close the file
- Add PDF to the list of supported file types within SharePoint
- In the web browser, open SharePoint Central Administration
- Under Application Management, click on Manage service applications
- Scroll down the list of service apps and click on Search Service Application
- Within the Search Administration dashboard, in the sidebar on the left, click File Types
- Click ‘New File Type’ and enter PDF in the File extension box. Click OK
- Scroll down the list of file types and check that PDF is now listed and displaying the pdf icon.
- Close the web browser
- Stop and restart Internet Information Server (IIS)*2 Note: this will temporarily take SharePoint offline. Open a command line (Start – Run – enter ‘cmd’) and type ‘iisreset’
- Perform a full crawl of your index. Note: An incremental crawl is not sufficient when you have added a new file type. SharePoint only indexes file names with the extensions listed under File Types and ignores everything else. When you add a new file type, you then have to perform a full crawl to forcibly identify all files with the now relevant file extension.
That’s it. If you now perform a search, PDF files should be displayed in results where they match the search query, along with the PDF icon on display in results. The icon should also be visible in any document libraries that contain PDF files.