cakephp - mssql connection string

[Hariprasad]

Hi,
I have to connect cakephp with mssql server. I have installed mssql in my system. how to specify the connection string?

I tried this:

 public $default = array(
        'datasource' => 'Database/Sqlserver',
        'persistent' => false,
        'host' => 'localhost\SQLEXPRESS',
        'login' => 'username',
        'password' => 'password',
        'database' => 'dbname',
        'prefix' => '',
        //'encoding' => 'utf8',
    );

But getting this error:

SQLSTATE[08001]:[Microsoft][SQL Server Native Client 10.0]SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].

Thank You
Hari

 

[Peter Schmitz]

Are you running cakephp and SQL Server on the same server? Did you install the Microsoft SQL driver for PHP, and did you add it to your php.ini?

You can find more info about the php driver here:

http://robsphp.blogspot.dk/2012/09/how-to-install-microsofts-sql-server.html