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.


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…

Completed UiPath - RPA Developer Advance Training

After a month of training, with late nights and weekends I have completed the UiPath RPA Developer Advance Training.

The Level 1 Foundation Training pretty much covered all the basics of Desktop studio and workflows, only draw back was I started with the default foundation course which was for 2016, and all document reference links where pointing to 2016 version. I didn't understand it during the foundation training and kept switching to 2018 version document/page.

Only after completing the Foundation course that I realized, I was suppose to have started with the 2018 version of Level 1 Foundation Training, but as it was optional I didn't have to retake the 2018 version, the 2016 was good enough for moving to level 2.

The Level 2 Orchestrator 2018.3 Training as good. It gave good understanding of Queue's, Jobs, and schedules and I was able to complete the level two much faster then the level 1.

The Level 3 UiPath Advanced Training was bit tough as it involved the assignme…