Azure SQL Database
An Azure relational database service.
6,326 questions
I had to upgrade to the latest and greatest ODBC version (18.x). I was using 17.x
ODBC connection on prem to Azure SQL Managed Instance - Windows Authentication
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 64%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERP%3C/text%3E%3C/svg%3E)
Ryan Pighin
91
Reputation points
We are trying to get an on prem application to connect to our Azure SQL Managed Instance. From on prem we can connect to SSMS with the windows authenticated user (we us AD Sync) and manage the database without issue. The vendor told use the application itself needs to community to the database via ODBC connection. I can't seem to get it to work. I keep getting Error code 0xCAA90018; state 10 Could not discover a user realm when I try to do a user DSN "With integrated Windows authentication". I can make this connection fine with a SQL account or if I use "With azure Activity Directory" option and the AAD account that our on prem is synced with.
I am logged in to the On prem server as the same windows user that launching SSMS fine so I am at a loss. Wondering if anyone else has had success doing this?
thanks in advance
Azure SQL Database
{count} votes
-
Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator2023-05-24T22:25:35.6633333+00:00 Ryan Pighin Thank you for reaching out.
Seems like you are facing issue when trying to add a user DSN with option integrated windows authentication.
What is the version of SSMS that you are able to successfully connect.
Regards,
Oury
-
Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator
2023-05-25T00:08:53.6833333+00:00 Following the doc below https://learn.microsoft.com/en-us/sql/connect/odbc/using-azure-active-directory?view=sql-server-ver16#new-andor-modified-connection-attributes
Could you please try setting the ADALuseWAM option.
see pic below.
Regards,
Oury
-
Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator
2023-05-30T16:19:41.2133333+00:00 Just checking if you were able to go through the above comment I posted. Did that resolve your issue?
Please comment below if you are still facing issue and need further support.
Regards,
Oury
-
Ryan Pighin 91 Reputation points
2023-05-30T19:58:53.7833333+00:00 thanks for that info Oury. I was able to make a successful connection this afternoon. I was testing using 17.x ODBC driver. I upgraded to 18.x and it connected right away. I am going to review the links you sent me though also in case our software vendor needs to try those options.
Sign in to comment
1 answer
Sort by: Most helpful
-
Ryan Pighin 91 Reputation points
2023-05-30T19:59:40.9133333+00:00 -
Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator
2023-06-09T21:27:34.54+00:00
Sign in to comment -