Cant conect with ms sql

13 years 7 months ago #601

Just bought it and unfortunately I have the same problem.

Have SBS2003 with SQLServer2005.
Ended up installing PHP5.3 with FastCLI. All apps work except I can not get to the DB.
Unable to connect to the database:The MSSQL adapter "mssql" is not available.
The modules you are refering here are no longer supported, I tried in all ways imaginable and it would not work - this is the current version: SQL Server Driver for PHP

Q: The PHP module is actually called php_sqlsrv.dll - it the Database type still mssql?

If I do a PHP test I can reach the server as well, reporting back the version:
"DriverDllName: sqlncli10.dll DriverODBCVer: 03.52 DriverVer: 10.00.2531 ExtensionVer: 1.1.428.1"
The PHP module is:

/*Connect to the local server using Windows Authentication and 
specify the AdventureWorks database as the database in use. */
$serverName = "(local)";
$conn = sqlsrv_connect( $iciserver);

if( $conn === false )
     echo "Could not connect.\n";
     die( print_r( sqlsrv_errors(), true));

if( $client_info = sqlsrv_client_info( $conn))
       foreach( $client_info as $key => $value)
              echo $key.": ".$value."\n";
       echo "Client info error.\n";

/* Close connection resources. */
sqlsrv_close( $conn);

phpinfo also reports it is loaded: sqlsrv
sqlsrv support enabled
Directive Local Value Master Value
sqlsrv.LogSeverity 0 0
sqlsrv.LogSubsystems 0 0
sqlsrv.WarningsReturnAsErrors On On

Thanks for any help to get this working.
on a sidenote: your pictures at the bottom are not working on the documentation

Last edit: 13 years 7 months ago by user62.

Please Log in or Create an account to join the conversation.

13 years 7 months ago #602

Hi Peter,

You should connect with SQL Server Authentication. So you should have prepared a DB user (standard user: sa, db name: master)

My settings are as folows:

Select connection: Other
Database type: SI_VI\VILJEMSQL2008
Database host: localhost
Database user: sa
Password: *********
Databasename: master

Before connection be sure you have enabled as follows:
1. copy ntwdblib.dll to folder where php is installed (e.g. \xampp\php) and also to apache\bin
2. out comment extension=php_mssql.dll in php.ini (delete ; before). Please, restart apache.
3. try to connect (also try with e.g. SQL server Management Studio if connection is ok)

please see documentation:

I am sending you mine dll via email.

Best regards,

Please Log in or Create an account to join the conversation.

Moderators: tomaz
Time to create page: 0.189 seconds

Contact Us

Contact us on Facebook