Cannot connect to MSSQL Server (Please Help!)

Newbie Spellweaver
Joined
Aug 31, 2014
Messages
42
Reaction score
2
Greetings ..

Last Few Months i was looking for a Shop Solution for My Server ..
As i Found .. This Shop , I Wanted to Use It ..

So i Used "WAMPServer2.0c" As it Require's , and Enabled "php_mssql" in PHP Extensions.
And In The Shop Config , i Put my Default SQL Information , and Saved it.

But When I Try The Shop, Here is What i Get:
Warning: mssql_connect() [ ]: Unable to connect to server: USER-PC\SQLEXPRESS in C:\wamp\www\Shop\inc\functions.phpon line 17
Cannot connect to MSSQL Server.

I Can't Understand The Error, Even i Tried a MSSQL Test File (Written in PHP Site(Examples))
Same Error Also ..

Any Help Please ? ..

 
If this connects then your configuration for the website is wrong and needs to be changed, if it doesn't then you have some other error

Dear Cuvvvie
Here is The Result:
Warning: mssql_connect() [ ]: Unable to connect to server: ZUHER-PC\SQLEXPRESS in C:\wamp\www\test.php on line 7
Something went wrong while connecting to MSSQL

You Were Right, The Wrong is in Wamp Already ..
I use 2.0c Wamp , it Use PHP 5.2.6 , it support MSSQL
but i guess it's Broken , Right?

So What i want is :
Any Way to Fix this MSSQL support? even if i used other Program Like Xampp or Wamp, The matter is it Support MSSQL..

With My Best Regards.
 
It appears that MSSQL connection is supported, since you are getting that message. If it was not, it would say something about not having the mssql-connect function, instead of it not being able to connect. Your server name, username, or password must be incorrect. You're hosting the website on the same computer that the server is on, right? Obviously you wont be able to connect using your computer name if you're on a different network.

I've sent you a PM so be sure to check that when you can.

Alright I Just Checked , Waiting for your Response.



The Final Solution for the Problem:

1- Download This DLL:
2- Paste the file into: "...\xampp\apache\bin\ntwdblib.dll"
----And Here Also: "...\xampp\php\ntwdblib.dll"
3- Restart Server And Done!
Big Thanks to : Cuvvvie
For Finding a Solution for This Noisy Problem.

Good Luck :) .
 
Last edited:
Back