Open jacobreeves opened 3 years ago
Hi
Just checking to see if anyone has any ideas on this.
Thanks!
Complete guess but have you tried setting the username as username@azure-host.public.some-guid
?
Thanks @bvogelzang. Yes. I've tried every permutation I can think of. I've replicated the problem at the FreeTDS level and am going to post a similar issue there.
Hello,
Do you have any updates on this issue?
We are encountering the same issue.
Thanks!
Hi @aditandrau. Unfortunately, the only update we have is an issue opened against the underlying FreeTDS library here.
Operating System
TinyTDS Version and Information
TinyTds 2.1.1
FreeTDS Version
tsql -C
Description
We are attempting to get TinyTds to connect to an Azure instance via the public endpoint. For public endpoints the host matches the pattern: azure-host.public.some-guid.database.windows.net and the port is 3342.
Using the tsql command below, this works just fine and it connects immediately
tsql -H azure-host.public.some-guid.database.windows.net -U username -p 3342 -P password
However, if we attempt to connect using TinyTds from the same host using the command below client=TinyTds::Client.new( :username=> 'username@azure-host', :password=> 'password', :host=>'azure-host.public.some-guid.database.windows.net', :port=>3342, :encoding=>"UTF-8", :azure=>true )
we get the auth error below (pulled from freetds.log)
19:39:55.052288 2790 (token.c:2384):tds_process_info() reading message 18456 from server
So the questions are:
Thanks!