Thursday 27 September 2007

'75a0fea7-8d3c-455d-89d3-4ece8739402d' error

If you've come accross this error before, you will realise there is NO help anyway. I came across it after doing a backup of a site and restoring it on a new farm. When you went to a site, and clicked Site Actions/Manage Content and Structure, you would have got the error:

Feature '75a0fea7-8d3c-455d-89d3-4ece8739402d' for list template '420' is not installed in this farm. The operation could not be completed.

After careful examination, we realised what the problem was. The original farm had the "Microsoft Application Core Template" installed. After installing it, the problem went away.

Microsoft's Important change to licensing for Internet Sites (MOSSFIS)

Microsoft has changed their licensing for Internet Sites in SharePoint. Please read this:

http://blogs.msdn.com/sharepoint/archive/2007/09/24/important-change-to-moss-2007-for-internet-sites-mossfis-licensing.aspx

Tuesday 25 September 2007

Microsoft Project Server 2007 with SharePoint

I have just installed MS Project Server 2007 with SharePoint. It is one of the easiest setups you will come across. Once it's setup, you create a PWA (project web access) site, and you're up and running.

If anyone needs step by step instructions on how to set it up, simply email me. I will update this post once I have finished the documentation.

Monday 10 September 2007

Changing the location of Microsoft SQL Embedded Edition (MSEE) files

Windows SharePoint Services v3 uses Microsoft SQL Embedded Edition (MSEE) for its data store. When MSEE is installed, the data files are installed to your C: drive by default. Well, like any good admin - we don't want data (that can grow exponentially) living on our system partition. However, you can't successfully move the data files for an MSEE instance using your normal SQL tools (most notably SQL 2005 Management Studio). Yep, you've got to resort to the command line . . .

First, you will need to have the Microsoft SQL Server Native Client and Microsoft SQL Server 2005 Command Line Query Utility installed.
1) Identify the Sharepoint DB you want to move (look under SystemRoot%\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data)

2) Stop SharePoint services.

3) Open a command prompt

4) Go to the Microsoft SQL Server 2005 Command Line Query Utility folder (under C:\Program Files\Microsoft SQL Server\90\Tools\binn)

5) Enter the following command & hit enter:
sqlcmd -S \\.\pipe\mssql$microsoft##ssee\sql\query -E

6) Enter the following commands & hit Enter after each:
EXEC sp_detach_db GO

7) Repeat step 6 for each database you want to move.

8) Move the individual .mdf & ldf files for the detached databases to the new location.

9) Attach moved databases. Return to your command prompt and enter the following command then press Enter:

EXEC sp_attach_db @dbname = N'',
@filename1 = N'\.mdf',
@filename2 = N'\.ldf'

The line breaks above are for ease of reading. When entering the command, don't use line breaks, just the the lines wrap. E.g.:

EXEC sp_attach_db @dbname = N'WSS_Content',
@filename1 = N'D:\SharePointDB\WSS_Content.mdf',
@filename2 = N'D:\SharePointDB\WSS_Content_Log.ldf'

10) Type GO and press Enter.

11) Repeat steps 9 & 10 for each database you moved.

12) Type Exit to exit from SQLCMD

13) Type Exit to close Command Prompt

14) Start SharePoint services you stopped previously.

15) Verify access to SharePoint sites.

Friday 7 September 2007

SharePoint Server 2007 SDK: Software Development Kit

Download the lasted SharePoint Server 2007 SDK (1.2). I've played around with it a bit, and one feature that I really like is the BDC Editor.

http://www.microsoft.com/downloads/details.aspx?familyid=6d94e307-67d9-41ac-b2d6-0074d6286fa9&displaylang=en

New tools and samples included with the MOSS SDK: Developer tools and samples for the following areas of MOSS development (new items in bold):
  • Business Data Catalog Samples and Utilities

    • Microsoft Business Data Catalog Definition Editor

    • Sample Pluggable SSO Provider

    • WSHelloWorld Web Service

    • WSOrders Web Service

    • Excel Services User Defined Function Sample

    • WSOrders Custom Proxy Sample

    • Amazon Web Service Sample

    • AdventureWorks Metadata Samples

    • SAP Sample

  • Document Management and Content Processing Samples
    • Comment Scrub Document Converter

    • Term Replacement Document Inspector

  • Search Samples

    • Sample Protocol Handler

    • Custom Content Source

  • Records Management and Policy Samples
    • De-Duplication Router

    • Document Integrity Verifier

    • Records Center Web Service Console Application

    • Search, Collect, and Hold Tool

    • Sample Custom Barcode Generator

    • IRM Document Protector

  • Workflow Samples
    • Custom Workflow Report Query Generator

    • Custom Workflow Report XLSX Injector

    • Visual Studio Workflow Templates

    • Enterprise Content Management Workflow Activities

    • List Item Activities

    • Hello World Sequential Workflow

    • State Based Approval Workflow

    • Modification Workflow

    • Replication and Contact Selector Workflow

    • Intersystem Purchase Order

    • Confidential Approval Workflow

    • Group Approval Workflow

    • Approval Workflow Sample

    • Multi-Stage Workflow

    • Server-side Collect Signatures Workflow

Let me know what you think of it.

Wednesday 5 September 2007

Microsoft Templates for SharePoint

Just a quick one, before rushing to develop a SharePoint site, check out Microsoft's free templates.

http://www.microsoft.com/sharepoint/templates.mspx

I've used a couple of them and modified them to meet my clients needs. Another useful list is Microsoft's Fantastic 40.

http://www.microsoft.com/technet/windowsserver/sharepoint/wssapps/templates/default.mspx

They're all free and work under WSS.