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.




Comments

Popular posts from this blog

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 a

KB 294807 - IIS Server - PHP FastCGI 500 Error 0xfffffffe

Resolved issue today of IIS Server - PHP FastCGI 500 Error 0xfffffffe by deleting "Windows Temp" folder files. We used Cygwin to customize some permissions of "Windows Temp" folder and after few hours the website stopped working. The search online was giving all kinds of different solution except what I was looking for. I was hoping the stackoverflow will have answers but even this post didn't cover the issue I was running into. https://stackoverflow.com/questions/15302080/fastcgi-500-failure Restarting the IIS didn't work, but deleting temp files cleared the issue, but now the problem is how long before the site will go down again? Hope the issue is resolved for ever, if not; I will update this post later.

QlikSense - Custom Form Login Screen

Extension of:  Custom login, logout and error forms for Qlik Sense by RPK https://developer.qlik.com/garden/5ada5a8f0c313f5c539dc7fd QlikSense - Custom Login Screen Install Node on QlikSense Server: URL: https://nodejs.org/en/ Saved at: C:\server-tools\Downloads\Node Installed at: C:\server-tools\Runtime\nodejs\ Keep default options Create Folder: C:\QlikForm Clone git Repository and keep updates private: # Open Shell/Bash/Command Prompt cd /QlikForm # Ref: https://medium.com/@bilalbayasut/github-how-to-make-a-fork-of-public-repository-private-6ee8cacaf9d3 git clone --bare https://github.com/kreta99/QS-Custom-Forms .git cd QS-Custom-Forms.git git push --mirror https://github.com/<name>/QS-Custom-Forms.git cd .. (go to parent folder) # remove other users repo clone rm -rf QS-Custom-Forms.git # clone witinc private repo git clone https://github.com/<name>/QS-Custom-Forms.git Get latest copy of login pages: # Open She