If you want to use Lando with SQL-Server on Drupal without going crazy

submited by

Style Pass

2024-08-31 09:00:03

If you want to use SQL-Server by Microsoft on your Lando environment, you may encounter several difficulties. This is because (according to me) SQL-Server is difficult in any case [especially if you use most of the time MySQL or MariaDB :-]

Lando is perfect for local development if you are a Drupal [or WordPress] developer because it is based on Docker, and makes development speed than other tools [XAMPP, I’m looking at you]. I’m using Lando on my WSL Ubuntu LTS installed on Windows 11, and it goes great!

Again, Lando has a lot of plugins that you can use, especially for your database: MySQL, MariaDB, MongoDB, Postgres, and SQL-Server [here is the official page of the plugin]. Using this last, for me, is a tremendous hell!

First of all, we need to know that Lando is based on a specific configuration file called .lando.yml [that we can override with other YML files, if necessary].

If you are looking at lines 37 to 42, let me explain. I need a method to create a user [different from sa] and give some privileges. Again, I want to make this using environment variables.