Blog posts - recent

Blog posts > SharePoint 2007 > , , , , ,

Installing MOSS 2007 on Windows Server 2008 and SQL Server 2008 - Part 4: Installing and configuring SQL Server 2008

14. August 2008
| by Andreas
| 14 Comments |

This article is a part of a series describing the installation of Microsoft Office SharePoint Server 2007 (MOSS) on a Windows Server 2008 with the newly released SQL Server 2008. Please have a look at "Installing MOSS 2007 on Windows Server 2008 and SQL Server 2008 - Part 1: Overview".

Installation

  • Start the "setup.exe" of your SQL Server 2008 installation DVD.
  • You are prompted to install the .NET Framework 3.5 SP1 (surprise since this was officially released later)
  • After that you need to install a Windows Update.

Start the setup.exe.

Istall the .NET Framework 3.5 SP1. Install a Windows Update.

  • On the left side click "Installation" and on the right side click "New SQL Server stand-alone installation or add features to an existing installation".
  • After that select your version of SQL Server 2008.

Select New SQL Server stand-alone installation or add features to an existing installation Select your version of SQL Server 2008.

  • After installing the setup support files you are prompted that there are some warnings. You can ignore that on a development environment.

Install the setup support files. Ignore the warnings on a development environment.

  • After that select the "Database Engine Services" feature and the "Management Tools" feature.
  • Keep the default instance checked.

Select the Database Engine Services feature and the Management Tools feature. Keep the default instance checked.

  • After validating the hard disk requirements you have to select a services account. Please use the domain account from Part 3: Domain Accounts.

After validating the hard disk requirements you have to select a services account. Select the SQLservice account.

  • You don't need to change the collation settings given by the installation wizard.
  • Use "Windows Authentication" and add the current user as a SQL Server administrator.

Dont change the collation settings. Use Windows Authentication and add the current user as a SQL Server administrator.

  • Click a few times next to start installation.

Click to start installation. The installation was successful dialog shown at the end.

Configuration

  • You have to enable "named pipes".
  • "Remember to reboot for the named pipes to be available (needed for part 6)." (Updated 13. September 2009, provided by Audun)

You have to enable named pipes.

"Remember to go back to the Domain setup page and set the required permissions for SQL server /setupAdmin account." - Installing MOSS 2007 on Windows Server 2008 and SQL Server 2008 - Part 3: Domain Accounts (Updated 13. September 2009, provided by Audun)

Please take a look at Part 5: Installing IIS7.

Comments

10/27/2008 10:55:15 PM #

Andreas - I've been looking for blogs/references that speak to how stable SQL 2008 RTM is proving to be and, in particular, with MOSS 2007.  Was wondering if you have experience with production environments and any feedback with regards to stability/reliability.
Moe

Moe Oro United States

10/29/2008 9:08:36 AM #

Hi,

yes that's a question I have asked myself. I haven't seen any SQL Server 2008 in a production environment right now. The customers I talk to still use SQL Server 2005 and the customers who are going to use SharePoint 2007 need to set up the production environment.

Unfortunately I have to wait until I hear some experiences from the real world..

Andreas

aglaser Switzerland

12/4/2008 4:56:45 PM #

Trackback from Office et SharePoint pour et par les administrateurs

Installation MOSS 2007 sur Windows 2008 et SQL Server 2008...

Office et SharePoint pour et par les administrateurs

9/4/2009 10:49:24 AM #

Hi,
Thanks for an excellent guide.
On this page I have two suggestions for improvement, it would be great if you added them.  
Number 1:  Bullet point after configuring named pipes: Remember to reboot for the named pipes to be available (needed for part 6).
Number 2: Remember to go back to the Domain setup page and set the required permissions for SQL server /setupAdmin account (this step is just sooo easily forgotten).

Audun Norway

9/13/2009 7:30:28 PM #

Hi Audun,

thank you very much! Smile I highly appreciate your suggestions and added them above.

Andreas

Andreas Switzerland

10/8/2009 9:41:38 PM #

Did you have any issues joining the MOSS VM to the newly created domain?

ehaze United States

10/9/2009 7:00:19 PM #

Hi,

I didn't have any issues... I joined the domain before I installed Active Directory, SQL Server and SharePoint.

Andreas

Andreas Switzerland

10/11/2009 4:08:41 PM #

I found my issue(s), sort of, I was trying to do this with VWware Workstation....
Once I activated HyperV, things went much smoother.  Thanks for the great blog post!

ehaze United States

10/13/2009 1:34:11 AM #

Wow nice post! These are pretty much the steps I used to successfully install SQL server 2008 in our medium sized MOSS farm.

If anyone is interested I have also detailed a process for migrating from SQL server 2005 to SQL server 2008 (on Windows Server 2008) within a live SharePoint 2007 farm. Feel free to check it out over at http://mossblogger.blogspot.com/ if you are interested.

Cheers, Ben.

Benjamin Athawes United Kingdom

10/13/2009 10:38:42 AM #

@ehaze / @Benjamin

Thanks for sharing the information with us.

Andreas Switzerland

11/5/2009 12:58:49 PM #

Hi,

Thanks for this excellent tutorial...

Naveen India

11/10/2009 9:53:59 AM #

Hi Andreas. Great articles. I have used them as reference for setup in both development environment and production. I have used Windows Server 2008 R2 as base. The only difference I can think of, is that you have to install SP1 on SQL Server 2008.

Ole Kristian Norway

12/3/2009 5:58:42 PM #

Andreas and Moe,
What a great article and discussion!
I've worked with SQL Server 2008 and SharePoint for a couple years and I have seen examples where it is used in stable production sites. If you are starting from scratch, I would definitely recommned considering using the latest platform. However even for SharePoint 2010, SQL 2005 is still supported, but you must use the latest service pack and the 64bit version.
Tom

Tom Resing United States

12/6/2009 8:27:07 PM #

@Tom: Thanks for your input Smile

Andreas Switzerland

Add comment

Your comment is not displayed until it is approved.




  Country flag

biuquote
Loading