In navicat. I can connect to sql server using domain authencation.
But it cannot be connected in laravel.Below is my connection config.
[
"driver" => "sqlsrv",
"url" => "ad.demo.com",
"host" => "10.xx.xx.xx",
"port" => "1550",
"database" => "Database",
"username" => "user1",
"password" => "****",
"charset" => "utf8",
"prefix" => "",
"prefix_indexes" => true,
]
Error message:
Illuminate/Database/QueryException with message 'SQLSTATE[28000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Login failed for user 'user1'. (SQL: select count(*) as aggregate from [USERS])'