Hi,

We now have a platform ready to host our MOSS 2007 setup.

To set it up professionally, with a little bit of “Release process” in mind, I’ll use different service accounts to run the platform.

These Service Accounts were created in the previous post.

The one that interests us the most now, is the one created to set up SharePoint.

This account have the maximum of privileges on the farm. You must use it ONLY to set up the farm and apply updates.

As a reminder, the prerequisites for this account are:

  • Be a domain account
  • Grant this account the SQL server rights:
    • SQL server login
    • server roles:
      • dbcreator
      • securityadmin
  • Member of farm “servers” local administrator” group

Step 1: SQL prerequisites

Use the same technique as for the settings of the SQL server itself. We just need to give the right instructions.

Create a SQL answer file (a text file renamed, for instance “SQL_acct_login.sql”) and type this in it:

CREATE LOGIN [ad\MOSS_Setup_Acct] FROM WINDOWS;
GO
EXEC sp_addsrvrolemember [ad\MOSS_Setup_Acct], 'securityadmin';
GO
EXEC sp_addsrvrolemember [ad\MOSS_Setup_Acct], 'dbcreator';
GO

Launch this the same way as previously for SQL Server settings:

cd /d "C:\Program Files\Microsoft SQL Server\90\Tools\Binn"
SQLCMD -i ”SQL_acct_login.sql”

Here is the script:

And here is the result:

Step 2: SharePoint prerequisites

Now, we'll check and install prerequisites for SharePoint on the server. They are :

  • .NET Framework 3 + SPs
  • IIS 6 (for Windows Server 2003)
  • ASP.NET v2.0.50727, allowed in IIS

If you followed my previous steps, IIS 6 is already present. So you need .NET Framework 3. To set it up, download the FULL package from here: http://go.microsoft.com/fwlink/?LinkId=70848 (this is x86 package – I don’t cover x64 in these posts).

To set it up run:

E:\Sources\dotnetfx3.exe /q /norestart

To install and allow ASP.NET v2 in IIS, run:

C:\windows\microsoft.net\framework\v2.0.50727\aspnet_regiis -i –enable

To give the SharePoint setup account the right it needs on the server, run:

net localgroup "Administrators" "ad\MOSS_Setup_Acct" /add

You can now logout as Administrator and go to the next post ;-)

<Emmanuel/>