In order to have Internet Explorer 8 on Windows Server 2008 behaving good, you need to disable or configure the loopback check. Read this article for more information.
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.
Select Create a new server farm.
Enter the database server name and the Database Access Account
Select the default values.
These are the steps for how to install Windows SharePoint Services v3.0
Startup the setup executable.
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.
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.
Since I will install MOSS right after this step, I choose to un-check the checkbox and click Ok.
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.
Select the New SQL Server stand-alone installation.
When the Setup Support Rules has identified all the rules, click Ok.
Enter your product key and click Next.
If you agree to the License Terms, check the box and click Next.
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
In this example I will install all features of SQL Server, but for your needs you may select only the features you will need.
If you have no plans of changing the Instance name or the installation root directory, leave those as per default and click Next.
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”.
Enter your SQL Service account and click “Check Names” and then click Ok.
Click Add Current User, click Add and enter the Administrators user group. Click Next.
If you have selected the Analysis Services, click Add Current User and click Add.. and add the Administrators user group. Click Next.
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.
If you want to participate in the error reporting or usage data program, put a checkbox on those. Click Next.
When the Setup Process has finished, click Next.
Finally, click Close.
If you plan to access your SQL Server from an external client, you will have to open some firewall ports.
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.
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.
Click “Add Required Role Services”.
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:
- .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