How to install Microsoft Office SharePoint Server 2007

Download the installation media from Microsoft, or use your supplied DVD media. I recommend you to apply the latest service pack 2 to the media files. Unfortunately, at this time of writing, there are no slipstreamed Service Pack 2 media, but you can follow this guide to make your own.

Start the setup.

image

image

Select Complete.

image

image

image

image

image

Select Create a new server farm.

image

Enter the database server name and the Database Access Account

image

Select the default values.

image

image

 image

 

 

 

 

 

 

 

 

How to install Windows SharePoint Services v3.0

These are the steps for how to install Windows SharePoint Services v3.0

Download Windows SharePoint Services 3.0 with Service Pack 2, either 32bit or 64bit.

Startup the setup executable.

image

Click Continue.

image

For this example I will setup my SharePoint as a standalone server with a dedicated SQL Server instance (not SQL Server Express),

so I select Advanced.

image

Because I don’t want to use SQL Server Express, I select the “Web Front End” option. Yes, it sounds odd, but the other option would install and user SQL Server Express, which I don’t want in this case.

image

image

Since I will install MOSS right after this step, I choose to un-check the checkbox and click Ok.

Installing SQL Server 2008 on Windows Server 2008 R2

Before you install SQL Server 2008, read this post about installing the pre-requisites on Windows Server 2008 R2. Here’s the guide to installing SQL Server 2008 on Windows Server 2008 R2.

In this example I have also prepared a special SQL Service account named DBService.

Start the setup program.

Screenshot of the SQL Server Installation Center

Select Installation.

Screenshot of selecting the New SQL Server installation

Select the New SQL Server stand-alone installation.

Screenshot of the Setup rules

When the Setup Support Rules has identified all the rules, click Ok.

Screenshot of the Product Key dialog

Enter your product key and click Next.

Screenshot of the License Terms dialog

If you agree to the License Terms, check the box and click Next.

Screenshot of the Setup Support Files dialog

Click Install.

Screenshot of the Setup Support Files in Progress dialog

Screenshot of the Setup Support Rules dialog

You will probably get a warning for the Windows Firewall. That is because some ports needs to be opened if you plan to access your SQL Server installation from outside. Read more at http://go.microsoft.com/fwlink/?LinkId=94001

Screenshot of the Rule Check Result Dialog

Screenshot  of the Feature Selection dialog

In this example I will install all features of SQL Server, but for your needs you may select only the features you will need.

Screenshot of the Instance Configuration dialog

If you have no plans of changing the Instance name or the installation root directory, leave those as per default and click Next.

Screenshot of the Disk Space Requirements dialog

Click Next.

Screenshot of the Server Configuration dialog

For this example, I will use the same service account for all SQL Server services. So click on “User the same account for all SQL Server services”.

Screenshot of the user account selection dialog

Click Browse.

Screenshot of the user account selection dialog

Enter your SQL Service account and click “Check Names” and then click Ok.

Screenshot of the user account selection dialog

Click Ok.

Screenshot of the Server Configuration dialog

Click Next.

Screenshot of the Database Enginge Configuration dialog

Click Add Current User, click Add and enter the Administrators user group. Click Next.

Screenshot of the Analysis Services Configuration dialog

If you have selected the Analysis Services, click Add Current User and click Add.. and add the Administrators user group. Click Next.

Screenshot of the Reporting Services Configuration dialog

If you have selected the Reporting Services feature, choose which Reporting Services mode you want to use. In this example I will use the integrated mode. Click Next.

Screenshot of the Error and Usage Reporting dialog

If you want to participate in the error reporting or usage data program, put a checkbox on those. Click Next.

Screenshot of the Installation Rules dialog

Click Next.

Screenshot of the Ready to Install dialog

Click Install.

Screenshot of the Installation Progress dialog

Screenshot of the Installation Progress dialog

When the Setup Process has finished, click Next.

Screenshot of the Installation Completed dialgo

Finally, click Close.

If you plan to access your SQL Server from an external client, you will have to open some firewall ports.

Pre-requisites for installing of SQL Server 2008 on Windows Server 2008 R2

In order for you to begin installing SQL Server 2008 on Windows Server 2008 R2, you will need to add required Server Roles and Features.

 

First, add the .NET Framework v3.5.1 that SQL Server 2008 requires. Go to the Server Manager –> Features and select add features.

Select .NET Framework 3.5.1 Features in the Add Features dialog

Put a check in the .NET Framework 3.5.1. Features.”. That will pop up a new dialog that says that it will also install some additional roles and features, such as the Web Server (IIS). That is fine, since you will need them anyway.

Add the Required Role Services

Click “Add Required Role Services”.

.NET Framework 3.5.1 Features selected.

Click Next.

Introduction to Web Server (IIS)

Click Next.

Put a check in the Box Common HTTP Features, which will select :

  • Static Content
  • Default Document
  • Directory Browsing
  • HTTP Errors
  • HTTP Redirection

In the Application Development check the  following:

  • ASP.NET
  • .NET Extensibility
  • ISAPI Extensions
  • ISAPI Filters

In the Security, check these:

  • Basic Authentication (Optional)
  • Windows Authentication
  • Client Certificate Mapping Authentication (Optional)
  • IIS Client Certificate Mapping Authentication (Optional)
  • Request Filtering

In the Performance, check these:

  • Static Content Compression (Optional)
  • Dynamic Content Compression (Optional)

In the Management Tools, check the following:

  • IIS Management Console
  • IIS 6 Management Compatibility (Optional)
  • IIS 6 Metabase Compatibility (Optional)
  • IIS 6 WMI Compatibility
  • IIS 6 Scripting Tools
  • IIS 6 Management Console

 

Web Server services part 1

Web Server services part 2

Click Next.

Confirm Installation screen

Click Install.

 

When finished

Installation Results screen

Click Close.

The system cannot boot. The file is possibly corrupt. The file header checksum does not match the computed checksum

Well, isn’t that special. This error was greeting my wife when she booted up Windows Vista on her Sony Vaio laptop the other day. This error message comes up directly after BIOS POST, within milliseconds. No chance to enter safe mode, no chance to press F10 for system recovery.

Booting from the Windows Vista DVD, I can enter the command prompt and run CHKDSK with no errors. Even CHKDSK /R doesn’t find anything out of the ordinary. The Repair option doesn’t find anything. Booting from the DVD, pressing F9 and selecting the memory diagnostics, it ran for 5 passes without finding anything. Just great…

As it turns out, one of the memory modules was the culprit. The laptop has one 2GB SO-DIMM module and one 1GB. Removing the 1GB module, the laptop boots up happily as if nothing has happened. Hmm…. wondering why the memory diagnostics didn’t find this.

How to enable database diagram on SQL Server 2008

You have to enable database diagram on SQL Server, otherwise when you try to create a database diagram on SQL Server 2008, you are greeted with this message:

TITLE: Microsoft SQL Server Management Studio
——————————

Database diagram support objects cannot be installed because this database does not have a valid owner.  To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects.

——————————
BUTTONS:

OK
——————————
So, first go to the database properties and select the Files tab. Select a valid login as the DB owner. Then go back to the Database Diagrams folder, right click and select Install Diagram Support. The next dialog show this message:

TITLE: Microsoft SQL Server Management Studio
——————————

This database does not have one or more of the support objects required to use database diagramming.  Do you wish to create them?

——————————
BUTTONS:

&Yes
&No
——————————
Click Yes.

Now go back and create a diagram.