Migration by the numbers – Step 13

Step 13 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 13 – Recreate the original internal website environment

Click Start | All Programs | Microsoft SharePoint 2010 Products | SharePoint 2010 Central Administration.

Accept the UAC.

Under the System Settings heading select Manage services on server.

You should see that the Microsoft Foundation Search is currently Stopped. Click the Start hyperlink in the Action column.

Enter account details into the Content Access Account area.

(*Authors note – this doesn’t have to be a domain administrator account. The account you choose will be given full read only rights to the site. It is recommended that you utilize a dedicated account with appropriate security).

Scroll down the screen and press the OK button.

(*Authors note – You may wish to adjust the default indexing schedule to something more often).

You should your configuration being saved.

When complete you will see that the SharePoint Foundation Help Search is started.

(*Authors note – You see a service of a different name listed. As long as it says Started your search is enabled).

Select System Settings from Central Administration menu on the left hand side.

Select Configure incoming e-mail settings from under the E-Mail and Text Messages (SMS) section.

Press OK to accept the warning message about an SMTP service not being installed.

For Enable Incoming E-Mail choose Yes.

For Incoming E-Mail Server Display Address enter companyweb.

For E-Mail Drop Folder enter c:\inetpub\mailroot\drop.

Scroll down the screen and press OK to save the configuration.

Under E-Mail and Text Messages (SMS) select Configure outgoing e-mail settings.

In Outbound SMTP server enter SharePointSMTPServer.

In the From address and Reply-to address enter companywebadmin@domain-name (where domain-name is the name of your organizations Internet domain name).

Ensure that Character set is 65001 (unicode UTF-8).

Select OK to save the changes.

Select System Settings and under Farm Management select Configure alternate access mappings.

Now select Edit Public URLs from the menu.

Click on the box No Selection in the top right of the screen. From the menu that appears select Change Alternate Access Mapping Collection.

Click on SBS SharePoint.

The box should now read SBS SharePoint.

Set the Intranet box to http://companyweb.

If you have already run the Set up your Internet address task in the SBS Console set the Internet address to https://:987.

If you have not run the Set up you Internet address task in the SBS Console set the Internet address to http://sites:987.

Press the Save button to continue.

You should now see the additional URLs you just configured displayed.

Return to the main Central Administration screen.

Select Security from the menu on the left.

From under General Security select Specify authentication providers.

Click in the Web Application box in the top right of the screen and select Change Web Application from the menu that appears.

Select SBS SharePoint from the window that appears.

Locate the IIS Authentication Settings section which is current set to NTLM. Select Negotiate (Kerberos).

The following warning will appear. Click OK to continue.

Scroll down the page and save the changes.

You will then be returned to the Authentication providers screen.

Mobile SharePoint 2010

One of the great features that will be available in Windows Phone 7 will be direct integration into SharePoint 2010 and the use of Mobile Office 2010. If you are a big user of SharePoint this is probably a very good reason to give the new Windows Phone 7 a close look.

Until I get that chance probably the best idea of what the experience will be like can be seen in the following video.

<img src="http://lh5.ggpht.com/-gwHgyg_qyv0/UP38tDYrP1I/AAAAAAAAHss/Ac0uTS9-2-Y/video29759dbb0cb6%25255B4%25255D.jpg?imgmax=800" style="border-style: none" galleryimg="no" onload="var downlevelDiv = document.getElementById('2405bc87-7a46-4af3-b247-d422b6ed5d05'); downlevelDiv.innerHTML = "

http://www.youtube.com/v/0OHVIc1Hgqc?hl=en&hd=1“;” alt=””>

http://www.youtube.com/watch?v=0OHVIc1Hgqc&feature=player_embedded

I also have to admit that the more I see of Windows Phone 7 the more I like it. As good as the Apple ‘iStuff’ is if you live mainly in a Microsoft environment Windows Phone 7 I think maybe a really good option.

Optimizing Windows SharePoint Search

One of the major complaints I hear from people when they implement Windows SharePoint Services v3 is that it is limited in what it can index and search. That is certainly true with the following files generally not being indexed by Windows SharePoint Services v3.0 out of the box:

– Office 2007 documents (i.e. docx, xlsx, pptx, etc)
– Adobe Acrobat PDFs
– Outlook MSG files
– TIFF files

to mention just a few. What most people don’t realize is that Windows SharePoint Services v3.0 can be configured to index these documents making them available to all users. The problem is that there generally isn’t a single source of good information about configuring this, that is until now!

This information has always been available in my SharePoint Guide (www.wssops.com) but I have now decided to create a new publication called:

Windows SharePoint MasterClass: Optimizing Search

available in eBook format for only $29.95. The details of the publication are:

This book is designer for those that want to take Windows SharePoint Services v 3.0 Search beyond the default. Did you know that Windows SharePoint Services v3.0 could index the contents of Adobe Acrobat documents and TIFF files? It normally can’t do either of these by default but the information inside this book will show you how to that and more. You’ll learn how to configure Search Server Express 2008 (free from Microsoft) to index information beyond SharePoint sites including Exchange Public folders, web sites and network shares. Implemented correctly Search Server Express can provide you the power of an internal search engine allowing you to make better and faster use of your digital information. If you want to make the most of Windows SharePoint Services then this book is for you.
I working a number of additional titles in this MasterClass series to help people take Windows SharePoint Services beyond the default install and get the most from the product.

If you have a topic you’d like to see appear in an upcoming MasterClass title please let me know (director@ciaops.com).

Migration by the numbers – Step 11

Step 11 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 11 – Remove the existing content database

Run the SharePoint 2010 Central Administration via Start | All Programs | Microsoft SharePoint 2010 Products | SharePoint 2010 Central Administration.

Accept the UAC.

Select Manage content databases from under the Application Management heading.

Click on the Database name which is a hyperlink.

(*Authors note – there will normally only be a single database and it will have some GUID after WSS_Content_).

Scroll down the screen.

In the Remove Content Database section check the option Remove content database.

Scroll down the screen and select the OK button.

(*Authors note – there is no additional warning here, once you click OK the existing content database is removed from this site).

(*Authors note – you should now see no content databases listed as shown above).

Migration by the numbers–Step 12

Step 12 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 12 – Connect the ShareWebDb content database

Run an administrator privileged command prompt at the server console.

Select Start and type CMD into the Search box. From the list that appears, right mouse click on CMD and select Run as administrator from the menu that appears.

Accept the UAC

Change directory to c:\program files\common files\microsoft shared\web server extensions\14\bin.

Type the following command:

stsadm –o addcontentdb –url http://localhost –databasename sharewebdb

(*Authors note – You should now see a percentage complete number displayed, as shown above. This is indication of the database conversion process from WSS v3 to SharePoint Foundation 2010. The duration of this conversion will depend on the hardware as well as the database size).

(*Authors note – when the process is complete you should see a message like shown above indicating Operation completed successfully).

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 10 – Attach the ShareWebDb database to SQL Server 2008

Select Start | Control Panel | Programs and Features.

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

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.

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

(*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).

(*Authors note – select OK when available).

(*Authors note – select Install when available).

(*Authors note – select Next when available).

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).

(*Authors note – select Next when available).

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

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).

(*Authors note – select Next when available).

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

(*Authors note – select Next when available).

(*Authors note – select Install when available).

(*Authors note – select Next when available).

(*Authors note – select Close when available).

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).

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

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

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

(*Authors note – select Add).

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).

(*Authors note – select OK).

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

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

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

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

Migration by the numbers – Step 9

Step 9 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 9 – Detach the Windows SharePoint Services 3.0 database from Windows Internal Database

You will need to have the SQLCMD utility installed on your server before you can complete these steps. This can be downloaded directly for SBS 2008 (x64) via:

http://download.microsoft.com/download/4/4/d/44dbde61-b385-4fc2-a67d-48053b8f9fad/SQLServer2005_SQLCMD_x64.msi

(*Authors note. I think it would be better to install the SQL Management Studio Express to complete this step as you need it for the next step anyway and other maintenance in general. Although the SQLCMD utility is handy to have I don’t see it being necessary).

Click Start in the Search box type CMD.

Under Programs right mouse click on CMD and select the option Run as administrator from the menu that appears.

At the command prompt type the following commands all followed by the ENTER key:

sqlcmd -S np:\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query
use master
alter database ShareWebDb set single_user with rollback immediate
go
sp_detach_db ‘ShareWebDb’
go

The WSS v3 content database is now removed from being connected to SQL Embedded Edition 2005. The next step will attach it to the SQL Server 2008 Express.