Moving PHP+ SQL to Azure

  • Hi,

    I'm moving a PHP/SQL Server app onto IIS and SQL Server both on Azure.
    I'm not a PHP expert hence this question.

    The issue I'm having is that the app is reporting the error message
    "sqlstate: imssp code: -14 message: an invalid parameter was passed to sqlsrv_query."

    PHP is installed ok and the PHP app works fine when point the original PHP app to SQL Server on Azure.
    It's just that I get this error message from the copied PHP app on Azure which is running against IIS on Azure that points to SQL Server on Azure. PHO pages that don't touch sql server work fine on the new setup. 

    Apologies if this sounds long winded but I think it's either a driver issue or an issue with the IIS set up.

    Any help most welcome.
    Thanks,
    Eamon

  • nothing beats answering your own question.......
    It was a missing driver.
    I had to installed the SQL Server 2012 Native Client. Everything ok now.
    Thanks,
    Eamon

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply