SQLSTATE[08001]: [Microsoft][ODBC Driver 13 for SQL Server]TCP Provider: No connection could be made because the target machine actively refused it. (SQL: select top 1 * from [settings] where [name] = site_title and [settings].[deleted_at] is null)

Which error are you getting? The one from the title or "could not find driver"?

@staudenmeir Yes.

You can't answer my question with "Yes.". Is the error "No connection could be made because the target machine actively refused it." or "could not find driver"?

The one from the title I got it when I tried to access the site.

The last one I got when I tried to run php artisan migrate

Try an empty port: DB_PORT=

You are trying to connect with MS SQL Server for which you need to install its appropriate drivers. Install SQLSRV driver on your PC or Server. These drivers are needed for PHP to connect with MS SQL Server.

You can find that on https://www.microsoft.com/en-in/download/details.aspx?id=20098. It will surely work

@technosml I think I have already installed 5.3 from here https://docs.microsoft.com/en-us/sql/connect/php/download-drivers-php-sql-server?view=sql-server-2017

Just extracted php_sqlsrv_72_ts_x64.dll and php_pdo_sqlsrv_72_ts_x64.dll from there

@staudenmeir Got following error

SQLSTATE[08001]: [Microsoft][ODBC Driver 13 for SQL Server]SQL Server Network Interfaces: Connection string is not valid [87]. (SQL: select top 1 * from [settings] where [name] = site_title and [settings].[deleted_at] is null)

@ssquare try this simple code and check it connects with mssql server:

$serverName = "serverName\sqlexpress"; //serverName\instanceName
$connectionInfo = array( "Database"=>"dbName", "UID"=>"userName", "PWD"=>"password");
$conn = sqlsrv_connect( $serverName, $connectionInfo);

if( $conn ) {
     echo "Connection established.<br />";
}else{
     echo "Connection could not be established.<br />";
     die( print_r( sqlsrv_errors(), true));
}
?>```

Put dd($this->getSqlSrvDsn($config)); in Illuminate\Database\Connectors\SqlServerConnector::getDsn(). What's the result?

@technosml

Connection could not be established.
Array ( [0] => Array ( [0] => 08001 [SQLSTATE] => 08001 [1] => 87 [code] => 87 [2] => [Microsoft][ODBC Driver 13 for SQL Server]SQL Server Network Interfaces: Connection string is not valid [87]. [message] => [Microsoft][ODBC Driver 13 for SQL Server]SQL Server Network Interfaces: Connection string is not valid [87]. ) [1] => Array ( [0] => HYT00 [SQLSTATE] => HYT00 [1] => 0 [code] => 0 [2] => [Microsoft][ODBC Driver 13 for SQL Server]Login timeout expired [message] => [Microsoft][ODBC Driver 13 for SQL Server]Login timeout expired ) [2] => Array ( [0] => 08001 [SQLSTATE] => 08001 [1] => 87 [code] => 87 [2] => [Microsoft][ODBC Driver 13 for SQL Server]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. [message] => [Microsoft][ODBC Driver 13 for SQL Server]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. ) )

I got above error. I have created database on sql server using (local). And I don't know I have which username and password on sqlserver I am using username 'sa' and black password as suggesting as default one.

By the way, I think instance name should be right as I have seen somewhere the name inside sqlserver should be its instance name

https://ibb.co/jkcSMe

@staudenmeir

"sqlsrv:Server=DESKTOP-H9OGJE5\MSSQLSERVER,1433;Database=kpi_db"

Sorry @ssquare but I don't have much knowledge about MS SQL Server. But I think there will be any option to create a username and password for your databases. And I think you got the answer for your question. Please create new thread for your query about username and password. So that anyone can help you.

Please post your current .env file.

@technosml okay i have created one user root and given password. and mapped to the database and also given the role as public. Now, what?

@staudenmeir

APP_NAME=Laravel
APP_ENV=local
APP_KEY=base64:MQ/MXLKOABVwvWjD3G9TgX1v4BO/+bWCez06cuzhYv8=
APP_DEBUG=true
APP_URL=http://localhost

LOG_CHANNEL=stack

DB_CONNECTION=sqlsrv
DB_HOST=DESKTOP-H9OGJE5\MSSQLSERVER
DB_PORT=1433
DB_DATABASE=kpi_db
DB_USERNAME=sa
DB_PASSWORD=

BROADCAST_DRIVER=log
CACHE_DRIVER=file
SESSION_DRIVER=file
SESSION_LIFETIME=120
QUEUE_DRIVER=database

REDIS_HOST=127.0.0.1
REDIS_PASSWORD=null
REDIS_PORT=6379

MAIL_DRIVER=smtp
MAIL_HOST=smtp.sendgrid.net
MAIL_PORT=587
MAIL_USERNAME=
MAIL_PASSWORD=
MAIL_ENCRYPTION=tls

PUSHER_APP_ID=
PUSHER_APP_KEY=
PUSHER_APP_SECRET=
PUSHER_APP_CLUSTER=mt1

MIX_PUSHER_APP_KEY="${PUSHER_APP_KEY}"
MIX_PUSHER_APP_CLUSTER="${PUSHER_APP_CLUSTER}"

What did you change after my post "Try an empty port: DB_PORT="?

@staudenmeir I have worked with that too. But with no success. Still returning.

"sqlsrv:Server=DESKTOP-H9OGJE5\MSSQLSERVER;Database=kpi_db"

If you could, I could also screen share with team viewer or so

What did the .env file look like when you got "sqlsrv:Server=DESKTOP-H9OGJE5\MSSQLSERVER,1433;Database=kpi_db"?

@staudenmeir

without port: "sqlsrv:Server=DESKTOP-H9OGJE5\MSSQLSERVER;Database=kpi_db" With port: "sqlsrv:Server=DESKTOP-H9OGJE5\MSSQLSERVER,1433;Database=kpi_db"

What was the content of the .env file?

@staudenmeir

DB_CONNECTION=sqlsrv
DB_HOST=DESKTOP-H9OGJE5\MSSQLSERVER
DB_PORT=1433
DB_DATABASE=kpi_db
DB_USERNAME=root
DB_PASSWORD=123456

and

DB_CONNECTION=sqlsrv
DB_HOST=DESKTOP-H9OGJE5\MSSQLSERVER
DB_PORT=1433
DB_DATABASE=kpi_db
DB_USERNAME=sa
DB_PASSWORD=

I have checked with both of this combination and with user root and sa both times gives same result for with port it also shows port and if no port provided it won't display port

What I meant: Remove the port (1433), the whole line should just be DB_PORT=.

Yeah, I am saying the same. Without port also shows same error. "sqlsrv:Server=DESKTOP-H9OGJE5\MSSQLSERVER;Database=kpi_db"

@staudenmeir I have an update now. If I test with following code.

<?php
$serverName = "(local)";
$connectionInfo = array( "Database"=>"kpi_db","UID"=>"root", "PWD"=>"123456");
$conn = sqlsrv_connect( $serverName, $connectionInfo);

if( $conn ) {
     echo "Connection established.<br />";
}else{
     echo "Connection could not be established.<br />";
     die( print_r( sqlsrv_errors(), true));
}
?>`

It shows following error

Connection could not be established. Array ( [0] => Array ( [0] => 28000 [SQLSTATE] => 28000 [1] => 18456 [code] => 18456 [2] => [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Login failed for user 'root'. [message] => [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Login failed for user 'root'. ) [1] => Array ( [0] => 28000 [SQLSTATE] => 28000 [1] => 18456 [code] => 18456 [2] => [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Login failed for user 'root'. [message] => [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Login failed for user 'root'. ) )

But if I tried with

<?php
$serverName = "DESKTOP-H9OGJE5\MSSQLSERVER";
$connectionInfo = array( "Database"=>"kpi_db","UID"=>"root", "PWD"=>"123456");
$conn = sqlsrv_connect( $serverName, $connectionInfo);

if( $conn ) {
     echo "Connection established.<br />";
}else{
     echo "Connection could not be established.<br />";
     die( print_r( sqlsrv_errors(), true));
}
?>`

I used to got different error Connection could not be established. Array ( [0] => Array ( [0] => 08001 [SQLSTATE] => 08001 [1] => 87 [code] => 87 [2] => [Microsoft][ODBC Driver 13 for SQL Server]SQL Server Network Interfaces: Connection string is not valid [87]. [message] => [Microsoft][ODBC Driver 13 for SQL Server]SQL Server Network Interfaces: Connection string is not valid [87]. ) [1] => Array ( [0] => HYT00 [SQLSTATE] => HYT00 [1] => 0 [code] => 0 [2] => [Microsoft][ODBC Driver 13 for SQL Server]Login timeout expired [message] => [Microsoft][ODBC Driver 13 for SQL Server]Login timeout expired ) [2] => Array ( [0] => 08001 [SQLSTATE] => 08001 [1] => 87 [code] => 87 [2] => [Microsoft][ODBC Driver 13 for SQL Server]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. [message] => [Microsoft][ODBC Driver 13 for SQL Server]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. ) )

Could you get some clue?

To resolve this problem, change the Server authentication from Windows Authentication mode to SQL Server.

To change the authentication mode to SQL Server and Windows, follow these steps:

1. On the computer that is running Microsoft SQL Server, open SSMS.
2. In the Server name box, type the name of the instance of SQL Server. For default, you can use dot(.) or (local)
3. After connecting, in the Object Explorer window pane, right-click the SQL Instance and select Properties.
4. Click Security under the select a page options.
5. Change Server Authentication to SQL Server and Windows Authentication and click ok.
6. Click ok to the prompt message about changes not taking effect until the instance is restarted.
7. Right-click the SQL Instance in the Object Explorer and select Restart. Click Yes to restart the instance and if prompted to restart the SQL Server Agent.

After these changes have been applied and the SQL Instance has been restarted, attempt to verify the ODBC connection with the ‘sa’ account credentials.

Then try to connect through

<?php
$serverName = ".";
$connectionInfo = array( "Database"=>"kpi_db","UID"=>"sa", "PWD"=>"");
$conn = sqlsrv_connect( $serverName, $connectionInfo);

if( $conn ) {
     echo "Connection established.<br />";
}else{
     echo "Connection could not be established.<br />";
     die( print_r( sqlsrv_errors(), true));
}
?>

If it successfully connected, remove port and fill other credentials.

Also, make sure you have copied extensions to ext folder and php.ini both in apache and php folder. As one is responsible for command and other is for the server. Let me know if any error arises.

Thank you actually I need to make change to SQL server authentication. That is the key what I am missing. Also, as you suggest I need to place drive on both ext folder.

Also I was caught out with this error when using xamp with a virtual host. I changed the port from 80 to 8000 but forgot to change the vhost file to reflect the port change. Just thought I'd add this for any other poor soul.

For this problem, after any time of investigation with the same problem I have discovered that it is necessary that I have also installed the ODBC drivers of the Sql server, they are two components, necessary for the installation The SQL Server drivers for PHP The ODBC drivers for the database.

This is a old link wiht a explication of how to work drivers of SQL server of php https://docs.microsoft.com/en-us/sql/connect/php/microsoft-php-driver-for-sql-server?view=sql-server-2017

I dont see an ext folder inside my apache folder, I only have ext in my php folder. I was able to connect through xampp until I tried using the laravel framework, now its refusing my connection.