SQL Server tips helpful when installing SharePoint 2010
Tip #1 – There are two easy ways to tell which build of SQL Server you are running:
- In SQL Server Management Studio, right click on the Server connection and click on Properties:
- Run this query: SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)
Tip #2 – At the time of this posting, this link contains the patches for all SQL Server builds. Found this very helpful when trying to get my SQL Server 2008 ready for SharePoint 2010, which required Cumulative Update 2 for SP1.
This entry was posted on January 26, 2010, 4:33 pm and is filed under SharePoint, SQL Server. You can follow any responses to this entry through RSS 2.0.
You can leave a response, or trackback from your own site.
#1 by Francois on January 28, 2010 - 8:32 am
I just installed our sandbox environment with SQL Server 2008 SP1 and Cumulative Update 1. I found that SharePoint 2010 didn’t require cumulative update 2.