in reply to Connection to MSSQL Database Using Windows NT Authentication

I am sorry that I do not know the answer to your question. However, usually I have pretty good luck when Googling for the actual text of the error message. For example, ODBC SQL Server Driver "Login failed for user" returns some hits that look pretty promising, especially the first one.

HTH,

planetscape
  • Comment on Re: Connection to MSSQL Database Using Windows NT Authentication

Replies are listed 'Best First'.
Re^2: Connection to MSSQL Database Using Windows NT Authentication
by 18th_bronzeman (Novice) on Sep 18, 2007 at 17:19 UTC
    Thank you Planetscape. After reading that I was able to get it going. I googled the entire error code before. With that truncation of the error code that you did the results came back quite different. I will use that trick googling in the future. Thank you again for all of your help.

    And for all of the DBI users using MSSQL ODBC with hopes of a DSN-Less connection with Trusted Connections/Windows Authentication:

    In the DBI string include 'Trusted Connection=yes', i.e.

    my $mssql_dbh = DBI -> connect(dbi:ODBC:driver={SQL Server};server={your_server};Trusted Connection=yes, user, password{
    PrintError => 0,
    RaiseError => 0,
    }) or die "\n\nthe mssql connection died with the following error: \n\n$DBI::errstr\n\n";
[reply]

In Section Seekers of Perl Wisdom