| Author |
Topic |
|
darkston3e
Starting Member
4 Posts |
 Posted - 2008-09-22 : 03:42:09
|
| Hello people,I have a very big problem which I don't understand:Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: 127.0.0.1 in C:\xampp\htdocs\include\class.mssql.php on line 42Database error: connect (127.0.0.1, sa, $Password) failedMSSQL 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. |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-22 : 04:46:48
|
| seewww.connectionstrings.com Also, I would advice you not to put your real IP here |
 |
|
|
raveekumarg
Starting Member
36 Posts |
Posted - 2008-09-22 : 06:07:30
|
quote:
Originally posted by afrika
seewww.connectionstrings.com Also, I would advice you not to put your real IP here
pl change ur p/wravi |
|
|
|
darkston3e
Starting Member
4 Posts |
Posted - 2008-09-22 : 06:36:13
|
quote:
Originally posted by raveekumarg
quote:
Originally posted by afrika
seewww.connectionstrings.com Also, I would advice you not to put your real IP here
pl change ur p/wravi
I allready did change my password several times, and same problem ... |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-22 : 08:45:42
|
Do a search on the error code you are gettint online....Well this is not a php forum, try sitepoint.com/forums or php.netthis forums focus more on microsoft technologies  |
|
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2008-09-22 : 12:19:30
|
| the ip address 127.0.0.1 specifically refers to the local machine and is reserved as such.Try using the same ip address to connect to your sql server as It was using on the other webserver.SQL can have access limited to specific ip addresses. 127.0.0.1 wont necessarily be one of them. |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-22 : 12:38:35
|
quote:
Originally posted by tripodal
the ip address 127.0.0.1 specifically refers to the local machine and is reserved as such.Try using the same ip address to connect to your sql server as It was using on the other webserver.SQL can have access limited to specific ip addresses. 127.0.0.1 wont necessarily be one of them.
He just changed it from the real ip to the Loop back machine IP |
|
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2008-09-23 : 11:27:14
|
| Is sql configured to respond to that IP? |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-23 : 11:50:45
|
quote:
Originally posted by tripodal
Is sql configured to respond to that IP?
You are not understanding the point. When he first posted the thread, he put his real IP, then i adviced him not to post his real IP, so he replaced it with the present IP.  |
|
|
|
darkston3e
Starting Member
4 Posts |
Posted - 2008-09-24 : 01:50:19
|
| That is not the idea people, i can't solve this problem... i did change the ip / password / host several times.The SQL pretends to not have any problems , but , i think there is a problem with it... something about a restriction, and i don't know where i can change that.If some one is capable of helping me , i will really appreciate that.I inform you again: " I'm using SQL 2000, running on a WINDOWS SERVER 2003 DEDICATED SERVER RC2 " |
|
|
|
darkston3e
Starting Member
4 Posts |
Posted - 2008-09-25 : 05:29:52
|
| Any help ? P.S: I did change the SQL 2000 in 2005 now, and same problem. |
|
|
|
|
SQL 2000 Connection problem