Trouble with external Database authentification

This forum post has been removed

Number of replies: 4
The content of this forum post has been removed and can no longer be accessed.
In reply to Deleted user

Re: Trouble with external Database authentification

by Leon Stringer -
Picture of Core developers Picture of Particularly helpful Moodlers

You need to download the Microsoft Drivers 4.3 for PHP for SQL Server and add this extension to PHP. Make sure you install the prerequisite ODBC drivers (see under System Requirements) if you don't have these.

From what you say about your environment I think you need php_sqlsrv_71_nts_x64.dll so copy this to your PHP ext folder and add the following line to php.ini:

extension=php_sqlsrv_71_nts_x64.dll

You may need to restart IIS to apply this change.

In reply to Leon Stringer

This forum post has been removed

The content of this forum post has been removed and can no longer be accessed.
In reply to Deleted user

Re: Trouble with external Database authentification

by Leon Stringer -
Picture of Core developers Picture of Particularly helpful Moodlers

Rolf: I've had a look and it looks like you've spotted a bug. The mssql and mssql_n options only work with an older driver that's no longer available with PHP 7.0 and above. Only mssqlnative will work now. I've added a bug report for this issue.

In reply to Leon Stringer

This forum post has been removed

The content of this forum post has been removed and can no longer be accessed.