Alpesh Nakar's Blog

I apologise for not getting this done earlier. This is the index of all the posts I did to install MOSS from command line. I am planning to create a pdf document for this, not this week though. If you are a SharePoint blogger and would like to advertise in the pdf, please contact me. I have learnt a lot along the way and this method is just indicative of how you can use command line to install and configure SQL and MOSS. I have used these in testing, development and production environments with modifications as needed. For our project requirements I had to find this kind of solution! I could not imagine installing 1300 standalone MOSS instances manually!

At that time, there wasn’t much available on the web, just bits and pieces. These days, you will find many. I am sure this will benefit many. On a side note, I will share some screenshots of the final installation package that has been done – later next week or thereafter.

We go to pilot next week! I will be on the road for 3 months…. maybe…

SQL Server 2005 and MOSS  Command Line Installation

1 Unattended SQL Server 2005 Installation

2 Configure MOSS using STSADM CLI

SQL Server 2005 Express Edition and MOSS  Command Line Installation

1 SQL Server 2005 Downloads for MOSS

2 SQL Server 2005 Express Edition Downloads for MOSS

3 SharePoint config.xml

4 Script to install MOSS with SQL Express

5 Howto configure sql express to allow remote connections

6 How to enable SQL Browser Service using a script

7 SharePoint: Config XML and PSConfig

8 SharePoint: Let PSConfig and STSADM setup your MOSS

What is ReGhost?

ReGhost is an application that was built quite some time ago, to deal with the unghosting issues prominant in Windows SharePoint Services 2.0, and SharePoint Portal Server 2003.  Whenever a page/item was customised in an application such as SharePoint Designer – the content would become what they call ‘unghosted’.  Meaning that the content is now stored and served from the database – it now exists as totally independant, rouge content.

The main issue for people has been the upgrade from WSS v2.0 / SPS 2003 to Windows SharePoint Services v3.0 / MOSS.  In order to successfully migrate your content, you needed to find an easy, reliable, safe way to “reghost” the content.

This is where ReGhost comes in – it will locate all of your content databases on the network, and examine them for unghosted pages – it then allows you to select which content you wish to revert.  Once selected, it will essentially reset the content, aka “reghost” the content – making it possible for your migration to complete successfully.

There are other uses for the product – when a company is managing a large intranet, a lot of customisations can occur – sometimes it’s nice to be able to revert some of the sites or pages back to their original state – ReGhost can do this for you – and it can do it very quickly and effectively.

Some of it’s current features include:

1. Individual item/page reghosting – being able to select individual content is crucial for most organisations

2. Content backup – ReGhost will let you execute a database backup before performing the reghost operation – keeping your data safe.

3. Content Searching – it will find your content databases for you – making the whole process a lot quicker.

4. Remote Reghosting – you don’t need to have the software installed on your servers, just point it at your SQL Server instance with appropriate permissions, and away you go!

5.  Transactional database access – if anything goes wrong during the reghost operation – everything will be rolled back, and your data is kept safe.

6. Automatic update facility – the application has a really nice software update facility, where it’s possible to check for the latest version, as well as a comment on what features are included in the new version, it will then on request, download and update your software for you – hassle free.

Due to the sheer amount of effort put into the product, it’s been released for a small purchase price.  You can register and subscribe to the download here.

Have you seen these? I had these book marked, and I can tell you that the white papers are really really good. Resources for SharePoint are just awesome and this is one of them.

Title	Streaming Video	White Paper
Overview: Office SharePoint Server server farm architecture	-	Download
Overview: Configuring server farms	Watch	Download
Securing server farms	Watch	Download
Configuring performance options	Watch	-
Backup, Restore, High Availability and Disaster Recovery	Watch	Download
Operations and management	Watch	Download
Capacity planning	Watch	Download
Search architecture and configuration	Watch	Download

Last week, our team was developing permissions matrix for our portal and intranets projects. MOSS 2007 comes with a complex permissions matrix and to have something like this handy is really a time saver.

Just look at the pictures and you will see that Mark has really shared an awesome piece of work! This spreadsheet has saved my team many hours of work and minimised chances of errors.

Download SharePoint Permissions Matrix

In addition to Office 2007 Service Pack 1, SharePoint Designer and Microsoft Office Server 2007 service packs have been released.

This service pack also includes all of the updates released for the 2007 Microsoft Office System servers prior to December of 2007.

This update applies to the following programs:

• Microsoft® Office SharePoint® Server 2007
• Microsoft® Office Project Server 2007
• Microsoft® Office Forms Server 2007
• Microsoft® Office Groove® Server 2007, 64-Bit Edition

You can get a more complete description of SP1, including a list of issues that were fixed, in the Microsoft Knowledge Base article 936984: Description of the 2007 Microsoft Office Servers Service Pack 1.

Most important to note

• Before SharePoint Server 2007 Service Pack 1 can be installed, Microsoft Windows SharePoint Services 3.0 Service Pack 1 must be installed.

Download

• Download Windows SharePoint Services 3.0 SP1
• Download 2007 MOSS SP 1 (both editions)
• Download Microsoft Office SharePoint Designer 2007 Service Pack 1 (SP1)Language Packs
  • Microsoft® Office Server Language Pack 2007, 32-Bit Edition: Office Server Language Pack 2007 SP1, 32-Bit Edition
  • Microsoft® Office Server Language Pack 2007, 64-Bit Edition: Office Server Language Pack 2007 SP1, 64-Bit Edition
  • Microsoft Office SharePoint Designer Language Pack 2007 Service Pack 1 (SP1)

Microsoft have now released a desktop version of Microsoft Office SharePoint Server 2007 Training kit. This release is in addition to the server version, which created a site for the training and delivered from your SharePoint portal. With the portal edition, SharePoint/IT administrators are able to track who has used the training, and what trainings they’ve taken.

The Microsoft Office SharePoint Server 2007 Training Standalone Edition is designed to help you learn how to use the features of Microsoft Office SharePoint Server. The Training topics lead you step-by-step through beginning to advanced features, including Collaboration, Business Processes and Forms, Portals and Personalization, Search, Business Intelligence and Enterprise Content Management.

The Training includes videos, interactive tutorials, and articles. The Standalone Edition is accessed through your browser after you install the application on your personal computer.

The Microsoft Office SharePoint Server 2007 Training Portal Edition, built on the Microsoft SharePoint Learning Kit, is designed for server administrators who want to help their end-users learn how to use the features of Microsoft Office SharePoint Server 2007. The Training topics lead the learner step-by-step through beginning to advanced features, including Collaboration, Business Processes and Forms, Portals and Personalization, Search, Business Intelligence and Enterprise Content Management.

The Training includes videos, interactive tutorials, and articles. In addition, the material is SCORM compliant. You can easily add or remove training topics to fit your business needs. The Training also includes a reporting function that allows an administrator/trainer to track learners’ completed training topics. You can customize the Training to fit the look and feel of your own Office SharePoint Server site.

Training topics included

Collaboration

• Finding your way around a team site
• Understanding permissions
• Customizing a team site
• Linking calendars to Outlook
• Adding Web Parts
• Collaborating in libraries, lists, and workspaces
• Using blogs and wikis to share information

Enterprise Content Management

• Document management
• Protecting files
• Using workflows
• Records management
• Creating and publishing Web pages
• Improving compliance and support litigation discovery

Search

• Finding files, Web sites, information, and people

Portals and personalization

• My Sites
• Targeting content to specific audiences
• Managing access to your My Site

Business processes and forms

• Streamlining business processes with forms and workflow
• Gathering information with browser-compatible forms
• Designing custom workflows using SharePoint Designer

Business intelligence

• Sharing Excel workbooks as interactive reports
• Working with a Report Center site
• Using dashboards to drive decisions
• Understanding Filter Web Parts
• Integrating external data

Download Standalone Edition | Download Server Edition