Monday, November 8, 2010

Migration by the numbers – Step 10

Step 10 in a series of posts documenting the Microsoft SharePoint Foundation 2010 upgrade process on SBS 2008. This is based on the document:

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=2dc66a0f-f840-4b29-93d3-13db70c85cba&;;displayLang=en

Previous steps:

Step 1

Step 2

Step 3

Step 4

Step 5

Step 6

Step 7

Step 8

Step 9

Step 10 - Attach the ShareWebDb database to SQL Server 2008

Select Start | Control Panel | Programs and Features.

image_2_6991F6C3

 

Locate the entry Microsoft SQL Server Management Studio Express. Select it and then click the Uninstall button at the top of the window.

 

image_4_6991F6C3

 

Select Yes to continue.

 

image_6_6991F6C3

 

Select Yes to continue.

 

(*Authors note – you will be installing a 2008 version of the SQL Management Studio which allows the support of SQL 2008 & 2005 databases)

 

Download Microsoft SQL Server 2008 Management Studio Express. The direct link is:

 

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=08e52ac2-1d62-45f6-9a4a-4b76a8564a2b&displaylang=en

 

Install the download on the server.

 

image_8_6991F6C3

 

(*Authors note – recommend you run the install as an administrator)

 

image_10_177F497C

 

(*Authors note – Select Installation from menu on left and then New SQL Server stand-alone installation or add features to an existing installation on the right).

image_12_177F497C

 

(*Authors note – select OK when available).

 

image_14_177F497C

 

(*Authors note – select Install when available).

 

image_16_177F497C

 

(*Authors note – select Next when available).

image_18_177F497C

 

Select Perform a new installation of SQL Server 2008.

 

(*Authors note – select Next when available. You can select either option here I believe, however as this installation package is only the SQL Management Studio a new installation will only install that as we will see in a few screens).

image_20_177F497C

 

(*Authors note – select Next when available).

 

image_22_177F497C

 

(*Authors note – select I accept the license terms and then Next).

 

image_24_177F497C

 

Select Management Tools – Basic.

 

(*Authors note – then Next. If you chose to add features in a previous screen this option is hidden as it is the only option to add to an existing instance).

 

image_26_177F497C

 

(*Authors note – select Next when available).

 

image_28_177F497C

 

(*Authors note – leave all options unchecked and select Next when available).

 

image_30_028DC709

 

(*Authors note – select Next when available).

 

image_32_028DC709

 

(*Authors note – select Install when available).

 

image_34_028DC709

 

(*Authors note – select Next when available).

image_36_028DC709

 

(*Authors note – select Close when available).

 

image_38_028DC709

 

Run the SQL Management Studio.

 

(*Authors note – select Start | All Programs | Microsoft SQL Server 2008 and right mouse click on SQL Server Management Studio. Select Run as administrator from menu that appears. Accept UAC after this).

image_40_028DC709

 

Connect to SQL instance call Express that was created in Step 4.

 

(*Authors note – should actually be Step 6 I believe).

 

image_42_028DC709

 

Right mouse click on Databases and select Attach from the menu that appears.

 

image_44_028DC709

 

(*Authors note – select Add).

image_46_307B19C1

 

This is what the Microsoft doc says:

 

“In the Attach Database dialog box, browse to the location where you transferred the .mdf and .ldf files in “Step 2: Back up the Windows Internal Database files,” select the ShareWebDb.mdf file for the database that you want to attach, and then click OK.”

 

(*Authors note – navigate to c:\windows\sysmsi\ssee\mssql.2005\mssql\data and select ShareWebDB.mdf.

The issue with the Microsoft document is firstly, I think it should read Step 4 – Back up the Windows Internal Database files, not Step 2. Secondly, I believe you should not be attaching these as they are backups, the original content database which you detached in Step 9 are actually located in c:\windows\sysmsi\ssee\mssql.2005\mssql\data. It is these original WSS v3 content databases you should be using).

image_48_307B19C1

 

(*Authors note – select OK).

 

image_50_307B19C1

 

(*Authors note – select OK).

 

image_52_307B19C1

 

(*Authors note – if you now open Databases you should see ShareWebDb).

 

image_54_307B19C1

 

(*Authors note – To manage your SQL 2005 Embedded databases via the SQL Management Studio select File | Connect Object Explorer.

 

image_56_307B19C1

 

Enter \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query in the server name and press Connect.

 

image_60_5E686C79

 

You should now see the two SQL instances – 2008 at the top and 2005 Embedded below as shown above).