The server expects sqlfluff to be installed and added to the PATH. If that is not feasible, pass the absolute path via --sqlfluff-path flag, e.g. sqlfluff-lsp ...