projectnami icon indicating copy to clipboard operation
projectnami copied to clipboard

non-Azure SQL Server

Open JoeBergen opened this issue 5 years ago • 7 comments

I am doing a project that will require WordPress on a SQL server, but I have been told not to use Azure so I am trying to deploy it on a SQL server that we have running IIS.

JoeBergen avatar Aug 21 '19 15:08 JoeBergen

I downloaded the git repo and tried to deploy it but I am getting the error: Your PHP installation appears to be missing the SQLSrv extension which is required by Project Nami. even though I have SQLSrv installed in the ext folder and listed in the ini file under extensions. What am I missing?

JoeBergen avatar Aug 22 '19 14:08 JoeBergen

It might be that you have some sort of mismatch between your PHP and SqlSrv versions.

Per our instructions at https://projectnami.org/download/ we highly recommend using the MS Web Platform Installer to prepare your environment.

patrickebates avatar Aug 22 '19 14:08 patrickebates

Hey I just saw you in the video, hello. Anyway, I installed IIS, Platform installer and the github repo. Then I searched SQLSrv in the Platform installer and looked for the version for 7.2 (my version of PHP) and installed that ALTHOUGH after installation it gave me a message that said PI failed to install, saying"this product cannot be installed because the product that it depends on did not install correctly." I assume that means that PHP did not install correctly? Do I have to uninstall PHP, reinstall PHP then try to install SQLSrv again? If that is what I have to do, can I fully uninstall PHP simply by deleting the PHP directory or is there another step?

JoeBergen avatar Aug 22 '19 15:08 JoeBergen

Not knowing how you installed PHP initially, I can't be sure if all you need to do is delete the folder. But I would recommend removing it somehow and allowing WebPI to install everything.

patrickebates avatar Aug 22 '19 15:08 patrickebates

yea I just changed the PATH, restarted and then tried to delete the extra PHP installation but apparently some of the files are open and cannot be deleted which is weird because I am not using this version of php anymore (I confirmed that the other version is being used with php --ini but I guess that is not really conclusive)

I also had to comment out this line in my php.ini file: ;extension=php_sqlsrv_72_ts_x64.dll It looks like my system is referencing some things from the old version of php and some things from the correct version... I cannot find any documentation or anything on how to switch PHP versions on windows not using XAMPP or Composer.. Do you have any idea how I do that?

JoeBergen avatar Aug 22 '19 16:08 JoeBergen

Maybe stop all IIS-related services and try the delete again?

patrickebates avatar Aug 22 '19 16:08 patrickebates

ok there is only one installation of PHP now, the other one is deleted. I am still getting that error telling me that SQLSrv is missing even though I uncommented the line that specifies it as a PHP extension and copied the file "php_sqlsrv_72_ts_x64.dll" into my PHP extensions folder. This system is x64, but PHP installed into the x86 folder. Should I be using a different dll for the PHP extension?

JoeBergen avatar Aug 22 '19 17:08 JoeBergen