php - How to integrate the sql server in cakephp
Here is my connection string.
public $default = array( 'datasource' => 'Database/Sqlserver', 'persistent' => false, 'host' => 'SAI-PC\\SQLEXPRESS', 'login' => 'sa', 'password' => '123', 'database' => 'SFAC_Connectmp', 'prefix' => '', //'encoding' => 'utf8', );
- I am able to login the sql server using the above credentials and it works fine
- I have checked all the options from the sql server manager.
eg. -Sql server and browser services are running fine.
-Remote server connection is checked
-windows firewall is off
-Still i get the error
A Database connection using "Sqlserver" was missing or unable to connect.
The database server returned this error: SQLSTATE: [Microsoft][SQL Server Native Client 11.0]Named Pipes Provider: Could not open a connection to SQL Server .