Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL 2000 Connection problem Expand / Collapse
Author
Message
Posted Monday, September 22, 2008 2:39 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 25, 2008 7:36 AM
Points: 3, Visits: 5
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.
Post #573312
Posted Monday, September 22, 2008 6:02 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Saturday, April 12, 2014 12:17 AM
Points: 282, Visits: 2,208
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
Post #573950
Posted Monday, September 22, 2008 11:30 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 25, 2008 7:36 AM
Points: 3, Visits: 5
I'm using my own dedicated server and i'm using SQL 2000 , not 2005.
Post #574034
Posted Tuesday, September 23, 2008 7:07 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Saturday, April 12, 2014 12:17 AM
Points: 282, Visits: 2,208
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
Post #574292
Posted Tuesday, September 23, 2008 11:41 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 25, 2008 7:36 AM
Points: 3, Visits: 5
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.
Post #574904
Posted Thursday, September 25, 2008 7:35 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 9:05 AM
Points: 331, Visits: 549
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


Post #575978
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse