Azure SQL Database
An Azure relational database service.
5,151 questions
if you are using a Mac, just use "ticket viewer" to create the kerberos token. its typically username@domain for the user name.
How to connect to existing SQL Server in Azure Data Studio 3?
![](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(83.2, 2%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENA%3C/text%3E%3C/svg%3E)
Nuako, A
0
Reputation points
When I attempt to connect to my institution's SQL Server I get this message "A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 35 - An internal exception was caught)" then when I disable the Trust Settings I get "Connection failed due to Kerberos error. Help configuring Kerberos is available at https://aka.ms/sqlopskerberos If you have previously connected you may need to re-run kinit." I attempted to follow the Kerberos instructions unsuccessfully.
{count} votes
-
Erin Stellato 481 Reputation points Microsoft Employee2024-03-29T21:43:28.6333333+00:00 Can you please confirm the version of Azure Data Studio you are using? The latest release is 1.48. You can check within ADS through Help > About. Thanks.
Sign in to comment
2 answers
Sort by: Most helpful
-
![](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(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Bruce (SqlWork.com) 56,846 Reputation points2024-03-26T16:30:43.9633333+00:00 -
Nuako, A 0 Reputation points
2024-03-26T17:17:43.4133333+00:00 Thank you. I'm still stuck on how the Kerberos ticket relates to the SQL server. Do I create any username and domain?
-
GeethaThatipatri-MSFT 27,642 Reputation points Microsoft Employee2024-03-27T17:18:11.2+00:00 Hi, @Nuako, A Can you share Azure Data Studio Version and OS Version also please the steps to reproduce the issue and any screenshot of the error.
Regards
Geetha.
-
Nuako, A 0 Reputation points
2024-03-27T17:31:55.45+00:00 Azure Data Studio 3, Mac iOS Ventura 13.4
- Create new connection
- Connection Type "Microsoft SQL Server"; Server PHSEDW; Authentication Type: Windows; Encrypt: Mandatory; Trust server: True; Server Group: Default
- Today I got a different error as above
-
Nuako, A 0 Reputation points
2024-03-27T17:35:45.2066667+00:00 This is what accessing the server is suppose to look like with Microsoft's SQL server
-
GeethaThatipatri-MSFT 27,642 Reputation points Microsoft Employee
2024-04-02T19:38:05.6+00:00 @Nuako, A We haven't heard back from you. In case you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.
Can you please confirm the version of Azure Data Studio you are using? The latest release is 1.48. You can check within ADS through Help > About.
Regards
Geetha
-
![](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(80, 48%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPR%3C/text%3E%3C/svg%3E)
Pavithra Ravi 0 Reputation points2024-04-23T22:53:58.6933333+00:00 I have installed azure data studio yesterday on mac book, as i am trying to connect with docker. i am facing the above error.
-
Pavithra Ravi 0 Reputation points
2024-04-23T22:55:11.2933333+00:00 I am facing this error in azure data studio new connection. Please help me. i just installed the latest version of azure data studio yesterday.
Sign in to comment -
-
Erin Stellato 481 Reputation points Microsoft Employee
2024-04-24T00:51:49.43+00:00 For TCP error 35 (Nuako, A), if connecting to a docker container, try using the IP address of the container, rather than the container name.
For TCP error 40 (Pavithra Ravi), were you able to connect to the SQL Server previously from that workstation, either with an earlier version of Azure Data Studio, or with another application (e.g. SSMS)? If this is a local SQL install (e.g. SQL Express), do you have Named Pipes enabled?
In all cases, please confirm the version of Azure Data Studio using Help > About and include it, as well as the version of SQL to which you are connecting, in any reply with additional questions.