Laravel - Sqlsrv远程连接

Question

我试图用Laravel连接到远程服务器上的sql server数据库，但我做不到，我做了以下所有必要的设置：

php.ini设置

    extension=php_pdo_sqlsrv_81_ts_x64
    extension=php_sqlsrv_81_ts_x64

database.php设置

         'sqlsrv' => [
            'driver' => 'sqlsrv',
            'host' => env('DB_HOST', 'IP ADRESS'),
            'port' => env('DB_PORT', '1433'),
            'database' => env('DB_DATABASE', 'DATABASE NAME'),
            'username' => env('DB_USERNAME', 'UID'),
            'password' => env('DB_PASSWORD', 'UPW'),
            'charset' => 'utf8',
            'prefix' => '',
            'prefix_indexes' => true,
            // 'encrypt' => env('DB_ENCRYPT', 'yes'),
            // 'trust_server_certificate' => env('DB_TRUST_SERVER_CERTIFICATE', 'false'),

我所犯的错误是这样的

PDOException::("SQLSTATEIMSSP:此扩展需要用于Server的Microsoft驱动程序与Server通信。

Answer 1

您需要从官方页面安装ODBC：

https://learn.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver16