in reply to Re: Connection to MSSQL Database Using Windows NT Authentication
in thread Connection to MSSQL Database Using Windows NT Authentication
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";