Re: FreeTDS with MSSQL 2005 Issue [NC]
"J. Bobby Lopez" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
Yeah, thats how I figured out it the port was filtered :\ Unfortunately it was after I posted to the list. On Fri, Jul 10, 2009 at 2:00 PM, Cedric ROUVRAIS <[email protected]>wrote: > second dumb question of the day, from the client machine where TDS is not > connecting did you try a simple telnet to the server on the port? > > a++ Cedric > > > > |------------------------------ > | "J. Bobby Lopez" > | <[email protected]> > | Sent by: > | freetds-bounces@l > | ists.ibiblio.org > | > | > | 07/10/2009 12:32 > | PM > | > | > | Please respond to > | FreeTDS > | Development Group > | <[email protected] > | iblio.org> > | > | > > > To > FreeTDS Development Group > <[email protected]> > cc > > Subject > Re: [freetds] FreeTDS with > MSSQL 2005 Issue [NC] > > > > > > > > > > > I just confirmed with the DB admin that the database is indeed running on > port 1433. Also, I did a 'netstat -an' on the system that the RazorSQL > client was running, and it's destination port was 1433. There must be > something else I'm missing. > > > On Fri, Jul 10, 2009 at 12:09 PM, Cedric ROUVRAIS > <[email protected] > > wrote: > > > Hi, > > > > I get this error when using the incorrect port for SQL Server. > > > > a++ Cedric > > > > > > |------------------------------ > > | "J. Bobby Lopez" > > | <[email protected]> > > | Sent by: > > | freetds-bounces@l > > | ists.ibiblio.org > > | > > | > > | 07/10/2009 12:05 > > | PM > > | > > | > > | Please respond to > > | FreeTDS > > | Development Group > > | <[email protected] > > | iblio.org> > > | > > | > > > > > > To > > FreeTDS Development Group > > > <[email protected]> > > cc > > > > Subject > > Re: [freetds] FreeTDS with > > MSSQL 2005 Issue [NC] > > > > > > > > > > > > > > > > > > > > > > I hadn't before (thanks for reminding me), but I got the same error: > > > > root@DEVTEST01:/usr/local/freetds/etc# tsql -S Reporting -U > > "domain\\username" > > locale is "en_CA.UTF-8" > > locale charset is "UTF-8" > > Password: > > 189Msg 20009, Level 9, State -1, Server OpenClient, Line -1 > > Unable to connect: Adaptive Server is unavailable or does not exist > > There was a problem connecting to the server > > > > > > On Fri, Jul 10, 2009 at 11:58 AM, Cedric ROUVRAIS > > <[email protected] > > > wrote: > > > > > dumb question. > > > > > > We agree that you wrote domain\\user in order to escape the \ ? > > > > > > a++ Cedric > > > > > > > > > > > > |------------------------------ > > > | "J. Bobby Lopez" > > > | <[email protected]> > > > | Sent by: > > > | freetds-bounces@l > > > | ists.ibiblio.org > > > | > > > | > > > | 07/10/2009 11:55 > > > | AM > > > | > > > | > > > | Please respond to > > > | FreeTDS > > > | Development Group > > > | <[email protected] > > > | iblio.org> > > > | > > > | > > > > > > > > > > To > > > > [email protected] > > > > cc > > > > > > > Subject > > > Re: [freetds] FreeTDS > with > > > MSSQL 2005 Issue > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Also, I tried connecting without the configuration file in this way: > > > > > > TDSVER=7.0 tsql -H P reporting.domain.com -p 1433 -U "domain\username" > > > > > > Which is why I got the "Server name not found in configuration files" > > error > > > below. But still nothing. > > > > > > > > > > > > On Fri, Jul 10, 2009 at 11:47 AM, J. Bobby Lopez <[email protected]> > > wrote: > > > > > > > Hello All, > > > > > > > > I'm trying to get FreeTDS working against an MS SQL 2005 > > (v.9.00.4035.00, > > > > Enterprise Edition, SP3). > > > > > > > > I've compiled freetds in the following way: > > > > > > > > ./configure --prefix=/usr/local/freetds > > > > make > > > > make install > > > > > > > > My '/usr/local/freetds/etc/freetds.conf' includes the following entry > > > > > > > > # A typical Microsoft server > > > > [Reporting] > > > > host = 1.2.3.4 > > > > port = 1433 > > > > tds version = 7.0 > > > > > > > > I use the tsql command as follows: > > > > > > > > tsql -S Reporting -U "domain\username" > > > > > > > > I use the domain because the database requires "windows > > authentication". > > > > It seems like it is about to connect. I get prompted for a password, > > and > > > > then I get the counter seconds climbing (0,1,2,3...) > > > > > > > > Eventually it does and throws this error: > > > > > > > > Msg 20012, Level 2, State -1, Server OpenClient, Line -1 > > > > Server name not found in configuration files. > > > > 188Msg 20009, Level 9, State -1, Server OpenClient, Line -1 > > > > Unable to connect: Adaptive Server is unavailable or does not exist > > > > There was a problem connecting to the server > > > > > > > > > > > > After several attempts I figured that there just must be something > > > > incompatible with freetds and this particular server. But then I > went > > > and > > > > tried to connect to the database with my linux-based database query > > > program > > > > (RazorSQL), and it connects just fine with JDBC:JTDS. > > > > > > > > So what am I doing wrong with FreeTDS? > > > > > > > > Thanks in advance. > > > > > > > > Bobby > > > > > > > > > > > > -- > > > > J. Bobby Lopez > > > > Web: http://jbldata.com/ > > > > Twitter: http://www.twitter.com/jbobbylopez > > > > > > > > > > > > > > > > > -- > > > J. Bobby Lopez > > > Web: http://jbldata.com/ > > > Twitter: http://www.twitter.com/jbobbylopez > > > _______________________________________________ > > > FreeTDS mailing list > > > [email protected] > > > http://lists.ibiblio.org/mailman/listinfo/freetds > > > > > > > > > > > > > ************************************************************************* > > > This message and any attachments (the "message") are confidential, > > intended > > > solely for the addressee(s), and may contain legally privileged > > > information. > > > Any unauthorised use or dissemination is prohibited. E-mails are > > > susceptible > > > to alteration. Neither SOCIETE GENERALE nor any of its subsidiaries or > > > affiliates shall be liable for the message if altered, changed or > > > falsified. > > > > ************************************************************************* > > > > > > _______________________________________________ > > > FreeTDS mailing list > > > [email protected] > > > http://lists.ibiblio.org/mailman/listinfo/freetds > > > > > > > > > > > -- > > J. Bobby Lopez > > Web: http://jbldata.com/ > > Twitter: http://www.twitter.com/jbobbylopez > > _______________________________________________ > > FreeTDS mailing list > > [email protected] > > http://lists.ibiblio.org/mailman/listinfo/freetds > > > > > > > > ************************************************************************* > > This message and any attachments (the "message") are confidential, > intended > > solely for the addressee(s), and may contain legally privileged > > information. > > Any unauthorised use or dissemination is prohibited. E-mails are > > susceptible > > to alteration. Neither SOCIETE GENERALE nor any of its subsidiaries or > > affiliates shall be liable for the message if altered, changed or > > falsified. > > ************************************************************************* > > > > _______________________________________________ > > FreeTDS mailing list > > [email protected] > > http://lists.ibiblio.org/mailman/listinfo/freetds > > > > > > -- > J. Bobby Lopez > Web: http://jbldata.com/ > Twitter: http://www.twitter.com/jbobbylopez > _______________________________________________ > FreeTDS mailing list > [email protected] > http://lists.ibiblio.org/mailman/listinfo/freetds > > > > ************************************************************************* > This message and any attachments (the "message") are confidential, intended > solely for the addressee(s), and may contain legally privileged > information. > Any unauthorised use or dissemination is prohibited. E-mails are > susceptible > to alteration. Neither SOCIETE GENERALE nor any of its subsidiaries or > affiliates shall be liable for the message if altered, changed or > falsified. > ************************************************************************* > > _______________________________________________ > FreeTDS mailing list > [email protected] > http://lists.ibiblio.org/mailman/listinfo/freetds > -- J. Bobby Lopez Web: http://jbldata.com/ Twitter: http://www.twitter.com/jbobbylopez