SQL 2000 Connection problem
-
Hello people,
I have a very big problem which I don't understand:
Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: 82.77.172.227 in C:\xampp\htdocs\include\class.mssql.php on line 42
Database error: connect (82.77.172.227, sa, $Password) failed
MSSQL Error: 0 ()
Session halted.
The password in the config file is OK, the password in SQL is OK.
I did install the website on a different host connected to the same database, and it's worked, but.. when I install the website in the server , where the database is ... it's not connecting to it and I can't solve this problem !
Allready 24 hours passed since i'm trying to fix it and i can't...
As for web hosting i'm using XAMPP.
Hope some one will answer to me and help me solve this problem.
Regards,
DarkStone.
-
are you using a hosting company who may have settings you aren't aware of?
MCITP, Database Administrator
A hodgepodge of Information Technology and Life
LinkedIn Profile
My Twitter -
I'm using my own dedicated server and i'm using SQL 2000 , not 2005.
-
I see you are using php. I've used it just enough to be dangerous but is there a possibility about the connection to the database and a problem with localhost?
MCITP, Database Administrator
A hodgepodge of Information Technology and Life
LinkedIn Profile
My Twitter -
Jason Crider (9/23/2008)
I see you are using php. I've used it just enough to be dangerous but is there a possibility about the connection to the database and a problem with localhost?I don't know if there is a problem, that is why i'm asking you ...
I saw that the script allows me to connect tho the ODBC .. but i don't know how to change all the script to use only ODBC connection.
-
As a side note, once you get the problem solved I suggest that you do not use the 'sa' account and hardcoding the password in a config file. This could end up being a security issue down the line. Just a word of caution
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply