# Connecting to microsoft sql server

**URL:** <https://discourse.cakephp.org/t/connecting-to-microsoft-sql-server/3607>\
**Category:** Need Help\
**Created:** [December 4, 2017, 3:20pm UTC](https://discourse.cakephp.org/t/connecting-to-microsoft-sql-server/3607 "2017-12-04T15:20:56Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![directshift](https://avatars.discourse-cdn.com/v4/letter/d/c89c15/32.png) [@directshift](https://discourse.cakephp.org/u/directshift)\
**Post date:** [December 4, 2017, 3:20pm UTC](https://discourse.cakephp.org/t/connecting-to-microsoft-sql-server/3607/1 "2017-12-04T15:20:56Z")

</div>

Hello! This php code works wonderful:

```
$serverName = "111.11.111.111\SQLOLEDB, 1111"; 
$connectionInfo = array( "Database"=>"TEST", "UID"=>"test", "PWD"=>"test");
$conn = sqlsrv_connect( $serverName, $connectionInfo);

```

But when trying the same in cakephp, I got an error: "Error: SQLSTATE[08001]: [Microsoft][ODBC Driver 13 for SQL Server]SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. "

This is the connection code:

```
'esanet' => [
            'className' => 'Cake\Database\Connection',
            'driver' => 'Cake\Database\Driver\Sqlserver',
            'persistent' => false,
            'host' => '111.11.111.111\SQLOLEDB',
            'port' => '1111',
            'username' => 'test',
            'password' => 'test',
            'database' => 'TEST',
            'encoding' => 'utf8',
            'timezone' => 'UTC',
            'cacheMetadata' => true,
            'log' => false,
            'quoteIdentifiers' => false,

            'url' => env('DATABASE_URL', null),
        ],

```

Any ideas?? I already tried removing the “sqloledb”