How to connect MSSQL with php

a) search the variable mssql.secure_connection in your php.ini file and put it to on mode if its off
b) remove comment from the dll extention php_mssql.dll (i.e. remove the ; from the front of the extention )

2. Settings related to the dll files.

download a file name ntwdblib.dll from the internet. you can download it from here or can search on internet for that. copy the downloaded dll to the apache/bin directory and for IIS copy it to the php extention directory (if path not known can be found in php.ini for variable extension_dir)

also you need to have your php_mssql.dll in your php extension directory. if its not present please download it and copy it to the default php extension directory.

3. restart all your services (i.e. php and apache or iis) and you can use the script given below to connect to your SQL Server.

I followed your instructions and connected first time to Windows NT Server 2003 from Windows XP running XAMPP !!

XAMPP for windows installs ntwdblib.dll and php_mssql.dll in the right directories if you use the windows installer version of XAMPP, but if you use the ZIP file to install XAMPP they are not included and you have to manually put ntwdblib.dll into \xampp\apache\bin and manually put php_mssql.dll into \xampp\php\ext.

I used versions that I had previously got with XAMPP when I used the windows installer version of XAMPP.

sir i connect mssql server 2005 above step but follwing error message can be display so i can’t connect.

Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: MAC-PC\SQLEXPRESS in c:\wamp\www\krunal\mssql_connect_php\index.php on line 12
Couldn’t connect to SQL Server on MAC-PC\SQLEXPRESS

Howdy outstanding blog! Does running a blog similar to
this take a large amount of work? I’ve no expertise in coding however I was hoping to start my own blog soon. Anyhow, should you have any suggestions or techniques for new blog owners please share. I understand this is off topic nevertheless I simply needed to ask. Thanks a lot!

I am curious to find out what blog system you happen to be using?
I’m experiencing some minor security problems with my latest blog and I’d like to find something more
secure. Do you have any recommendations?

You may wonder how this can be accomplished even without
dieting. To be fair, the same patterns set out by our guardiansto take upon ourselves the same routines of our
parents. A wide variety of pure green coffee bean extract reviews, but how do you really know?