Sharepoint 2010 Foundation install Step By Step

My goal was to install Sharepoint Foundation 2010 (SPF2010) so that web application is on one server and the database is on seperate server.

So these were my steps:




1. Download SharePoint Foundation 2010 from Microsoft Download Center 

2. Before installing check System & Hardware requirements

3. Run setup

4. Install software prerequisites:

And there was my first error message saying: "The tool was unable to install Hotfix for Microsoft Windows KB976462"

Solution:
Download and install this Hotfix manually and after that run again "Install software prerequisites".

Instructions (from this link):

1. Create a Folder under C:\ as KB976462
2. Download hotfix KB976462
3. Open Command Prompt (run as administrator) and then execute the following statement.
   1.expand -f:* "C:\KB976462\Windows6.1-KB976462-v2-x64.msu" %TEMP% and the second
   2.pkgmgr.exe /n:%TEMP%\Windows6.1-KB976462-v2-x64.xml 
4. Run again "Install software prerequisites".

5. Install SharePoint Foundation

1. Choose "Server Farm" -> "Complete". (This allowed me to install SharePoint database on seperate server.
2. Run Configuration Wizard.
3. Choose "Create new Farm" and type in sql server instance and account. And there was my second error message saying: "SQL server at 'server\instance name' has an unsupported version 9.0.4035.0." In my case I had a "SQL 2005 SP3", so I was missing Cumulative update package 3 for SQL Server 2005 Service Pack 3
4. Download & Install Cumulative update on your SQL server. Server Restart required!!!
5. So after this Hotfix continue setup and specify pass phrase.
6. Choose Administration page port.
7. Set authentification to NTLM.
8. Done!