Skip to Content.
Sympa Menu

freetds - [freetds] is the server there?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Evan Panagiotopoulos <epanagio AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: [freetds] is the server there?
  • Date: Tue, 16 Oct 2012 08:54:20 -0400

In the conf file I have
[MyServer2k]
host = 10.1.1.16
port = 1433
tds version = 8.0


When I go through the "is the server there?" steps I see the following:

root@kcsd-grades [/usr/local/etc/rc.d]# 27 > tsql -H 10.1.1.16 -p 1433 -U
osdadmin
locale is "C"
locale charset is "US-ASCII"
Password:
Msg 18456, Level 14, State 1, Server KCSD-ZONE-INT, Line 1
Login failed for user 'osdadmin'.
Msg 20014, Level 9, State 0, Server OpenClient, Line 0
Login incorrect.
There was a problem connecting to the server
root@kcsd-grades [/usr/local/etc/rc.d]# 28 > tsql -S 10.1.1.16 -U osdadmin
locale is "C"
locale charset is "US-ASCII"
Password:
Msg 20009, Level 9, State 0, Server OpenClient, Line 0
Server is unavailable or does not exist.
There was a problem connecting to the server

In the php script I have

putenv('FREETDSCONF=/usr/local/etc/freetds.conf');
$link = mssql_connect('10.1.1.16:1433', 'osdadmin', '...');
if (!$link) ...

In the php logs I see:

mssql_connect(): message: Login failed for user 'osdadmin'. (severity 14)


I know that the user ID and password that I am using are correct. We tested
them on the ms sql server and they worked.
HELP!

--
Evan Panagiotopoulos




Archive powered by MHonArc 2.6.24.

Top of Page