cannot connect to SQL with managment studio

64 Views Asked by At

I created a virtual machine with SQL in Azure. but I can't connect with management studio (SSMS) from out of my VM

enter image description here

any idea?

1

There are 1 best solutions below

0
Aravind On

There is no trusted CA certificate in the root store of the VM . Either you get a certificate and install that and have

Encrypt= true

in the connection string or you have to set

TrustServerCertificate=True

in the connection string or in the connection properties of the login pop up screen in SQL server management studio.