Bad ANSI Settings through DBLib and FreeTDS

Please accept my warm regards . I need some guidance move ahead.

I am from SQL Server background and have been doing some work on Linux machine offlate and making it connect with SQL Server. I have succesfully installed FreeTDS and can connect to Windows SQL Server machine. Now, I try installing Drupal in Linux and during its installation it creates multiple tables in the database. I am using DBLib module in this case as this supports Linux flavors and is meant for Drupal

After creating few tables it quits. I traced and found that it stopped because it needed ANSI settings ON to create an index on the table date_formats but found it off. I cannot set it at my DB because it chooses the client settings at the runtime. this is the error I get in my trace as well as FreeTDS log:

' Cannot create index. Object 'date_formats' was created with the following SET options off: 'ANSI_NULLS'.

I am not sure if Drupal install.php opens a connection with ANSI off settings because this causes the index creation to fail. Please help to investigate it.