Jump to content

Unable to connect to MS SQL Server 2005 using PHP


atitthaker

Recommended Posts

Hi,

 

I am trying to connect to MS SQL Server 2005 using PHP. But I am unable to connect to the SQL Server.

 

Following things are in place.

 

-- mssql extension is enabled in PHP and I can see MSSQL details in php info.

-- named pipes and TCP/IP is enabled in SQL Server Configuration

-- mssql.allow_persistent = On in php.ini

-- I copied ntwdblib.dll to /windows directory.

 

I am not sure what is going wrong but I am unable to connect to MS SQL Server 2005.

 

thanks

Atit

Link to comment
Share on other sites

It gives me only one message:

 

Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: node200 in E:\php_scripts\mssql_connection.php on line 28

 

I do not know what is going wrong here...

 

I have also installed MS SQL Server Client tools on my system which is the web server for the application.

 

Thanks

Atit

Link to comment
Share on other sites

hey there,

 

I am having the exact some problem as you(givin the error) connecting to SQL. I am running Vista, SQL2005, and I am getting the same error connecting the database. My login is connecting, but seems to be permissions...........can you tell me what steps you took to overcome this

 

Thank you

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.