Skip to Content.
Sympa Menu

freetds - Re: [freetds] FreeTDS "domain" authentication.

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Graeme Stewart" <gstewart AT gmail.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: Re: [freetds] FreeTDS "domain" authentication.
  • Date: Tue, 8 Jul 2008 19:05:36 -0700

Never mind, I figured out the problem. It was a user error! (Isn't it
always?)

I needed to quote q/ / the password rather than escape the characters.

Interestingly it was writing out this e-mail that started me thinking
along that path!

Apologies for the spam.

Graeme

On Tue, Jul 8, 2008 at 6:31 PM, Graeme Stewart <gstewart AT gmail.com> wrote:
> Hi Folks,
>
> I'm new to the list so I appreciate your patience. I have spent
> considerable time on this issue and I'm starting to clutch at straws.
> Any guidance would be appreciated. I also know this isn't a Perl
> mailing list, but I believe my problem lies between DBI::ODBC and
> FreeTDS, hopefully someone may be able to offer some guidance (other
> than; go ask on the DBI mailing list :-)
>
> I'm running Ubuntu 2.6.22-14-server, with FreeTDS version 8.2.
>
> I can use the following string and connect no problem:
>
> $ isql -v dsnname domain\\username password
>
> +---------------------------------------+
> | Connected! |
> | |
> | sql-statement |
> | help [tablename] |
> | quit |
> | |
> +---------------------------------------+
> SQL>
>
> Using "integrated" domain auth. I then try the same thing in Perl with
> the following connection string:
>
> my $dbh = DBI->connect('dbi:ODBC:dsnname', 'domain\\username', 'password');
>
> And immediately see:
>
> DBI connect('dsnname','domain\username',...) failed:
> [unixODBC][FreeTDS][SQL Server]Login failed for user ''. The user is
> not associated with a trusted SQL Server connection. (SQL-42000)
>
> Any guidance on a way to "force" FreeTDS via DBI to use a domain
> authentication style connection?
>
> Enabling mixed authentication mode on the SQL server isn't an option
> within this organization.
>
> Any thoughts? If you'd like to see odbc.ini / odbcinst.ini /
> freetds.conf files please advise and I'll be happy to post.
>
> Many thanks,
>
> Graeme
>




Archive powered by MHonArc 2.6.24.

Top of Page