Find the answer to your Linux question:
Results 1 to 2 of 2
I have got a server with running MS SQL server. I have ubuntu linux working at my workstation. I would like to connect to this server. I have installed freeTDS ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Apr 2011
    Posts
    2

    ubunntu freetds connection without user


    I have got a server with running MS SQL server.

    I have ubuntu linux working at my workstation. I would like to connect to this server. I have installed freeTDS from repository and set everything up and it does not work

    /etc/freetds/freetds.conf
    [myServer]
    host=ip
    port=port
    tds version=4.2

    /etc/odbcinst.ini
    [TDS]
    Driver=/usr/lib/odbc/libtdsodbc.so
    Setup=/usr/lib/odbc/libtdsS.so
    UsageCount = 1

    /etc/odbc.ini
    [MyDSN]
    Driver=TDS
    Database=mydb
    Servername=myServer

    The problem is that server is set with 'trusted connection'. Well at least I think it is set like this, because when I am connecting to this server through windows I do not have to pass UID and PID into connection strings (no user and password required).
    Or maybe Windows driver passses user and password via domain?

  2. #2
    Linux Guru Rubberman's Avatar
    Join Date
    Apr 2009
    Location
    I can be found either 40 miles west of Chicago, in Chicago, or in a galaxy far, far away.
    Posts
    11,707
    You may need to install the OpenLDAP client on your Linux system, and join to the Windows domain, so you will be properly authenticated.
    Sometimes, real fast is almost as good as real time.
    Just remember, Semper Gumbi - always be flexible!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •