«
»

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:

  1.  
    1. In SQL Server Management Studio, right click on the Server connection and click on Properties:sql_server_properties
    2. 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. #1 by Francois on January 28, 2010 - 8:32 am

    Hi,

    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.

    Regards,
    Francois P.

    Reply

Leave a Reply

Please log in using one of these methods to post your comment:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s

%d bloggers like this: