- #Sql server connection string from putty windows 10
- #Sql server connection string from putty windows
Several questions here and thank you for following up with the additional details.
Please let me know if you have additional questions. The documentation I have referenced is based upon SQL Managed Instance but the concept applies to Azure SQL Database. So, by using a couple VNets with Routes and VNet peering you will be able to connect with Azure AD. Additionally, there is a Point-2-Site tutorial: Quickstart:Ĭonfigure a point-to-site connection to an Azure SQL Database Managed Instance from on-premises I realize this is how you would set this up with Azure Site-2-Site VPN but the concept is the same. Troubleshooting connectivity issues section which details the route entries needed by the client. Please take a look at the following: Connect If you attempt the above by using SQL Authentication, it would likely work but because you want to use AAD authentication, you need to set-up a route and VNet peering. The attached data contains the server certificate."īecause you are using Azure AD authentication (Universal with MFA), you need to call the database with the FQDN as it is referenced by the certificate being used to authenticate the connection. The server name we were expecting is 127.0.0.1. It is therefore not possible to determine whether we are connecting to the correct server. "The certificate received from the remote server does not contain the expected name. I am also seeing below error in event viewer: What am I missing? is there anyone who can help me setting up putty tunnel and connect to SQL PaaS using the tunnel? I played with the firewall settings but to no avail. I modified hosts file 127.0.0.1 to point to I am using "Azure AD Universal MFA authentication". (provider: SSL Provider, error: 0 - The target principal name is incorrect.) (Microsoft SQL Server, Error: -2146893022) It fails with the following message.Ī connection was successfully established with the server, but then an error occurred during the login process. When I try to connect to the SQL server I use 127.0.0.1, 1433 as my server name. In putty I created a tunnel for the SQL Server and logged into the Linux jumpbox.
#Sql server connection string from putty windows
On my local Windows host I installed SSMS and Putty. We created a Linux jumpbox server in a different resource group in a different subscription. We created a SQL Database(PaaS) in a resource group in our subscription. We do not want to whitelist the IP address of client system in SQL firewall.
#Sql server connection string from putty windows 10
We want to connect to SQL server hosted in Azure PaaS from our laptop running windows 10 using SSMS.