I'm trying to connect my Yii2 application with a database in SQL Server, the version I'm using is 10.0, this is my error message:
exception 'PDOException' with message 'SQLSTATE [08001]: [Microsoft] [ODBC Driver 11 for SQL Server] Named Pipes Provider: Could not open a connection to SQL Server [2].
Configuration file
return [
'class' => 'yii\db\Connection',
'dsn' => 'sqlsrv:Server=localhost;Database=softwareoperacional',
'username' => 'sa',
'password' => 'admin123',
'charset' => 'utf8',
];