Mssql_connect(): Unable to connect to server:

Dev Shed Forums Sponsor:

October 12th, 2012, 07:40 AM

epanagio

Contributing User

Join Date: Nov 2003

Posts: 660

Time spent in forums: 1 Week 3 Days 5 h 32 m 17 sec
Reputation Power: 94

Mssql_connect(): Unable to connect to server:

I've tried many different configurations of:

PHP Code:


		
			
 $link = mssql_connect('IP:1433', 'id', 'password');

PHP Code:


		
			
 $link = mssql_connect('DNS Name:1433', 'id', 'password');

also all of the above by adding \instance_name
also all of the above by adding the port ID :1433
and every time I receive a

PHP Code:


		
			
 mssql_connect(): Unable to connect to server:

message
I am going from a freebsd to a Windows server. The freebsd server has freetds with a section

PHP Code:


		
			
[MyServer2k]

host = 10.1.1.16

instance = KCSD

port = 1433

tds version = 8.0

What else can I do to debug this connection?
Any ideas?

__________________
Evan

October 12th, 2012, 08:08 AM

ptr2void

I haz teh codez!

Join Date: Dec 2003

Posts: 2,477

Time spent in forums: 1 Month 2 Weeks 2 Days 7 h 33 m 54 sec
Reputation Power: 2194

What happens when you attempt to telnet to the DB server on port 1433 from the FreeBSD box? Do you connect?

__________________
I ♥ ManiacDan & requinix

This is a sig, and not necessarily a comment on the OP:
Please don't be a help vampire!

October 12th, 2012, 09:24 AM

epanagio

Contributing User

Join Date: Nov 2003

Posts: 660

Time spent in forums: 1 Week 3 Days 5 h 32 m 17 sec
Reputation Power: 94

Interesting:

PHP Code:


		
			
 telnet: connect to address 10.1.1.16: Connection refused 

telnet: Unable to connect to remote host

I wonder why but I have a good lead low! THANKS!

October 12th, 2012, 12:25 PM

danramosd

Registered User

Join Date: Oct 2012

Location: Jersey

Posts: 16

Time spent in forums: 2 h 35 m 46 sec
Reputation Power: 0

Also try just a regular ping to see if the box is even online. If it is then you know either the port isn't open or the service isn't running.

October 12th, 2012, 12:43 PM

badger_fruit

Confused badger

Join Date: Mar 2009

Location: West Yorkshire

Posts: 760

Time spent in forums: 1 Week 4 Days 5 h 15 m 18 sec
Reputation Power: 339

Is the SQL server configured to listen on that port?

No response to ping could be anything though so don't go on that result, make sure that the port's open in any firewalls that stand between your box and the server.

__________________
The number for UK Emergencies is changing, the new number is 0118 999 881 999 119 7253

"For if leisure and security were enjoyed by all alike, the great mass of human beings who are normally stupefied by poverty would become literate and would learn to think for themselves; and when once they had done this, they would sooner or later realise that the privileged minority had no function and they would sweep it away"
- George Orwell, 1984

Last edited by badger_fruit : October 12th, 2012 at 12:54 PM. Reason: edited out typo

October 12th, 2012, 12:51 PM

ManiacDan

Likely to be eaten by a grue.

Dev Shed God 10th Plane (9500 - 9999 posts)

Join Date: Oct 2006

Location: Pennsylvania, USA

Posts: 9,811

Folding Points: 127430 Folding Title: Super Ultimate Folder - Level 1

Time spent in forums: 2 Months 3 Weeks 19 h 13 m 52 sec
Reputation Power: 6112

Try connecting from another windows box using the MSSQL client.

__________________
HEY! YOU! Read the New User Guide and Forum Rules

"They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety." -Benjamin Franklin

"The greatest tragedy of this changing society is that people who never knew what it was like before will simply assume that this is the way things are supposed to be." -2600 Magazine, Fall 2002

Think we're being rude? Maybe you asked a bad question or you're a Help Vampire. Trying to argue intelligently? Please read this.

Mssql_connect(): Unable to connect to server:

Developer Shed Advertisers and Affiliates