[unixODBC-support] Problem connecting to a MSSql server in domain

Giovanni Marra giovanni.marra at meware.it
Fri Apr 4 09:15:03 BST 2014


Hello Lorenzo,

try to set the server parameter in this way:

Server = 10.15.15.13 <http://10.15.15.13/ISYSTEM>

This parameter indicate the IP address of the machine where DBMS is
installed.

Regards.



2014-04-04 9:29 GMT+02:00 Lorenzo Milesi <maxxer at ufficyo.com>:

> Hi.
> I'm having troubles connecting to a MSSQL server in a network. I apologise
> if the question is stupid, but I've been on this for so long I don't know
> where other to look at.
>
> The remote connection works fine from another Windows machine via ODBC,
> but I cannot make it work from Linux.
> Sadly I don't have all the details of the server configuration, but I'm
> sure it uses Dynamic Port Allocation as port 1433 is closed...
>
> The windows machine connects to the server using an hostname with the
> following syntax: IT1111111\ISYSTEM.
> Other than that it uses NT Windows authentication, while I should
> authenticate using username and password (which I do have).
> One first question: could this be a problem? My Linux machine is NOT part
> of the domain.
>
> I followed the guides here [1] and here [2] with no success. I tried using
> IT1111111 and IP address for server name (always keeping the \ISYSTEM part)
> but no change, I always get a failed connection in reply. But I cannot
> understand exactly why the connection fails.
>
> Configuration summary:
> tds.driver.template:
> [TDS]
> Description     = FreeTDS Driver for Linux & MSSQL on Win32
> Driver          = /usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so
> Setup           = /usr/lib/x86_64-linux-gnu/odbc/libtdsS.so
>
> tds.dsn.template:
> [SQLMAND]
> Description     = Maxxer test
> Driver          = TDS
> Trace           = No
> Server          = 10.15.15.13/ISYSTEM
> TDS_Version     = 8.0
>
>
> Result:
> root at docuts:~# isql -v SQLMAND userread systempassword
> [S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
> [01000][unixODBC][FreeTDS][SQL Server]Unknown host machine name.
> [ISQL]ERROR: Could not SQLConnect
>
>
> I'm using the IP address here because the IT1111111 name is not
> resolvable, even by querying the Windows domain controller's DNS.
> I don't know MSSQL environment very well, any help is welcome.
>
> Thanks
>
>
> [1] http://www.unixodbc.org/doc/FreeTDS.html
> [2] http://lucasmanual.com/mywiki/unixODBC
> --
> Lorenzo Milesi - lorenzo.milesi at yetopen.it
>
> YetOpen S.r.l. - http://www.yetopen.it/
>
> _______________________________________________
> unixODBC-support mailing list
> unixODBC-support at mailman.unixodbc.org
> http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support
>



-- 


Dott. Giovanni Marra

Meware s.r.l.
SOA&BPM B.U. Junior TIBCO Specialist

Via della Sierra Nevada, 108 - 00144 Roma

tel.: 06/5911669 fax: 06/56561042
giovanni.marra at meware.it
www.meware.it
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20140404/8787a1d5/attachment.html>


More information about the unixODBC-support mailing list