Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
22,992 questions
ActiveDirectoryIntegrated login to Azure SQL server from linux VM.
![](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(131.20000000000002, 79%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Ranjan
6
Reputation points
we have federated Azure AD using on prem DC. Later we create a linux instance and joined it to AAD using Azure ADDS and trying to connect to Azure SQL server using ActiveDirectoryIntegrated based authentication.
we are facing this error when trying to login to SQL
sqlcmd -E -S **************** -d **************
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Login timeout expired.
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Failed to authenticate the user '' in Active Directory (Authentication option is 'ActiveDirectoryIntegrated').
Error code 0x191; state 401
Error requesting SAML token.
.
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : TCP Provider: Timeout error [258]. .
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Unable to complete login process due to delay in login response.
We followed the doc for connecting linux server to AD https://learn.microsoft.com/en-us/azure/active-directory-domain-services/join-ubuntu-linux-vm
Similar thing is working for Windows based VM.
{count} votes
-
![](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(195.2, 0%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVM%3C/text%3E%3C/svg%3E)
VipulSparsh-MSFT 16,291 Reputation points Microsoft Employee2021-05-17T12:12:25.317+00:00 @Ranjan Thanks for reaching out and apologies for long delay on this. Looking at the error message, this needs more investigation from client side. This scenario will be more suitable to work over a support case as this might need deeper investigation and few logs analysis.
-
![](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(118.4, 51%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
SRITHARAN, Deepak 0 Reputation points2023-07-06T03:53:44.2566667+00:00 I am facing a similar issue, Can you please share us the solution
Sign in to comment
Sign in to answer