#Odbc driver 11 for sql server tls 1.2 install
#Odbc driver 11 for sql server tls 1.2 update
#Odbc driver 11 for sql server tls 1.2 upgrade
#Odbc driver 11 for sql server tls 1.2 code

$obj | Add-Member -MemberType NoteProperty -Name 'InstallLocation' -Value $($thisSubKey.GetValue('InstallLocation')) $obj | Add-Member -MemberType NoteProperty -Name 'DisplayVersion' -Value $($thisSubKey.GetValue('DisplayVersion')) $obj | Add-Member -MemberType NoteProperty -Name 'DisplayName' -Value $($thisSubKey.GetValue('DisplayName')) $obj | Add-Member -MemberType NoteProperty -Name 'ComputerName' -Value $env:COMPUTERNAME #Open each Subkey and use GetValue Method to return the required values for each #Retrieve an array of string that contain all the subkey names #Drill down into the Uninstall key using the OpenSubKey Method

$reg=::OpenRemoteBaseKey('LocalMachine', $env:COMPUTERNAME) #Create an instance of the Registry Object and open the HKLM base key $UninstallKey='SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall' $array = the variable to hold the location of Currently Installed Programs

#Odbc driver 11 for sql server tls 1.2 update

# Check and report if an update is required for each entry found #$sqlodbc = Get-WmiObject -Class Win32reg_AddRemovePrograms | Where-Object | Select DisplayName,DisplayVersion # Fetch the different MS SQL ODBC installations found on the machine Write-Host $cli.DisplayName 'with version' $cli.DisplayVersion ' supports TLS 1.2' -ForegroundColor Green I think this is very usefull for anyone that uses PHP development with Docker and connects to mssql server. My main question is: What should I change to not use TLS on connection, or to overpass this error. If you search for SQL Server you will see batch script to install.

#Odbc driver 11 for sql server tls 1.2 install

This will install mssql requirement on php-fpm and workspace containers.ĭocker files can be found on /php-fpm and /workspace

env file on laradoc folder and set this 2 variables to true: mysql container was irrelevant for this case.Īssuming that you have laradoc setup (follow docs or videos on Youtube). It happens that my Laravel web application connects to mysql and mssql. On this case it is nginx container that leverages also php-fpm and workspace containers (where docker file has the mssql script). Laradock is very complex project with a lot of diferent container setup mainly for Laravel developers. & docker-php-ext-enable pdo_sqlsrv sqlsrv Pecl install pdo_sqlsrv-5.3.0 sqlsrv-5.3.0 Replace pdo_sqlsrv-4.1.8preview with preferred version. # Install pdo_sqlsrv and sqlsrv from PECL. & ln -sfn /etc/locale.alias /usr/share/locale/locale.alias

& echo 'en_US.UTF-8 UTF-8' > /etc/locale.gen & echo 'en_US.UTF-8 zh_CN.UTF-8 UTF-8' > /etc/locale.gen & ACCEPT_EULA=Y apt-get install -y unixodbc unixodbc-dev libgss3 odbcinst msodbcsql17 locales # Add Microsoft repo for Microsoft ODBC Driver 13 for LinuxĪpt-get install -y apt-transport-https gnupg & ln -s /usr/lib/x86_64-linux-gnu/libsybdb.so /usr/lib/libsybdb.so This is the DockerFile script to install SQL Server driver on PHP-FPM container I am using laradoc project to setup my needed docker containers.

#Odbc driver 11 for sql server tls 1.2 code

Expected behavior and actual behaviorĬonnection to SQL Server successfully Repro code or steps to reproduce

#Odbc driver 11 for sql server tls 1.2 upgrade

Please take in account I am trying to connect to an SQL Server 2008 R2 and upgrade server is not an option. I am not able to setup SQL Server driver on PHP-FPM container. I am start using Docker for PHP development, and I want to connect to SQL Server from Laravel Project. Ubuntu 16.04.6 LTS (Docker container) PHP version