Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw

Re: SQL Server 2000 DBI Authentication

by vladdrak (Monk)
on Aug 06, 2009 at 23:12 UTC ( #786617=note: print w/replies, xml ) Need Help??

in reply to SQL Server 2000 DBI Authentication

If you're connecting from a unix host via FreeTDS then Integrated Auth isn't going to be a viable option.

Replies are listed 'Best First'.
Re^2: SQL Server 2000 DBI Authentication
by mje (Curate) on Aug 07, 2009 at 07:39 UTC

    I don't use freeTDS but I thought it supported integrated security by passing the domain\username in the username field

    There are commercial SQL Server ODBC drivers which support integrated security from UNIX.

    There are other ways of connecting from UNIX to MS SQL Server using ODBC and Windows authentication if you can install something on A windows machine (it does not have to be the SQL Server machine). You can use an ODBC-ODBC Bridge which installs a server process on a Windows machine which uses the MS SQL Server Driver to talk to SQL Server. An ODBC driver is installed at the client end which talks to the bridge server and on to SQL Server. Of course the only ones I know of are commercial ones from Easysoft and Openlink.

      Yeah, It doesn't seem like what I need is possible. The problem is that the sql server is going into production tomorrow, and my bosses are very apprehensive about installing 3rd party drivers (even if they are from trusted sources.) It seems to me that my only real option is to either set up replication, or do a sql dump onto a secure file share; unless anyone else has other ideas.

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://786617]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (5)
As of 2023-01-31 10:29 GMT
Find Nodes?
    Voting Booth?

    No recent polls found