Skip to main content

Configuring PHP on Windows Training Kit with SQL Server 2008 R2

There were lot of trial and errors; but I was finally able to setup "PHP on Windows Training Kit" on Windows 7 with SQL Server 2008 R2.

It was the dependencies check which through the curve balls in the check for all requirements installed or not.

I updated these PowerShell files to complete the setup:

Files in: \Labs\GettingStarted\Setup\scripts\Dependencies\Check

  • CheckAdventureWorks2008DB
    • For AdventureWorks I had to remove the "2008" as the database that is installed on my machine does not have the database name as "AdventureWorks2008"
    • $db = Invoke-Sqlcmd -Query "select database_id from [master].sys.databases where name = 'AdventureWorks'" -ServerInstance ".\SQLEXPRESS"
  • CheckSQL2008
    • For SQL Server check I have to search for R2 as just 2008 will return as not found.
    • SearchAllUninstallKeys -SearchFor 'Microsoft SQL Server 2008 R2';
  • CheckSQLServerNativeClient
    • Same as SQL server search; this native client is also R2 and needs to be searched as such.
    • SearchAllUninstallKeys -SearchFor 'Microsoft SQL Server 2008 R2 Native Client';
I had to download the php sql server dlls and stuff but that's easy to follow instructions. This PowerShell updates were the changes I have done for the first time. The setup for "PHP on Windows Training Kit" is straight forward but it should have a check for R2 but in case anyone else have similar issue; I hope this can help you.




Popular posts from this blog

Working hours in six months to a year

I usually try to look for how many hours I have worked on a given project and what hours that I  spend on learning or network management tasks.

Below I have added some hours calculation, after finding the breakdown by months from Berkeley website.


Credit: http://controller.berkeley.edu/payroll/payroll-system-pps/pps-training-materials/number-working-hours-month

2017Working hours six months (Jan 1st - Jun 30th): 
130 days x 8 hours =  1040 hours


Working hours six months (Jul 1st - Dec 31th): 
130 days x 8 hours =  1040 hours

Working hours for the year:
1040 hours + 1040 hours = 2080 hours
MonthWorking Days in the monthMonthly Working Hrs1/2 of working hrsMidpoint of working days in the monthDates of HolidaysJanuary22176888 a.m. 1/172,16February20160808 a.m. 2/1520March2318492Noon 3/1631April20160808 a.m. 4/17May2318492Noon 5/1629June22176888 a.m. 6/16July2116884Noon 7/174August2318492Noon 8/16September2116884Noon 9/154October22176888 a.m. 10/17November22176888 a.m. 11/1610,23,24December21168…