Error al tratar de conectar una base de datos sql azure con una instancia de sql instalada en una maquina virtual de azure

Carlos Eduardo Vasquez 46 Reputation points
2021-08-13T20:00:53.057+00:00

Buenos días,
Estoy tratando de conectarme desde mi base de datos SQL azure para vincularme a la base de datos SQL instalada en una maquina virtual de azure
Si intento conectarme a otra base de datos azure la conexión se realiza de forma correcta
Sin embargo, cuando intento ejecutar los mismos pasos para conectarme a la base de datos de la maquina virtual recibo el siguiente error:
A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.).
Los pasos que estoy haciendo para crear la conexión son los siguientes:
En el sql instalado en la maquina virtual:
• Crear un login y un usuario en el sql con permisos sobre la base de datos
En el sql azure:
• Se crea la clave de encriptación
CREATE MASTER KEY ENCRYPTION BY PASSWORD='<password>';

• Se crea la credencial
CREATE DATABASE SCOPED CREDENTIAL credencialdemootro
WITH IDENTITY = '<loginusuariomaquinavirtual>',
SECRET = '<password>'

• Se crea el external datasource
CREATE EXTERNAL DATA SOURCE [deexternal] WITH (TYPE = RDBMS, LOCATION = N'servidormaquinavirtual', CREDENTIAL = [credencialdemootro], DATABASE_NAME = N'basededatos')

Al tratar de realizar una consulta desde la base de datos sql azure conectando a la que está instalada en la maquina virtual.
EXEC sp_execute_remote N'deexternal', N'select * from tabla'
se genera el siguiente error:
Error retrieving data from shard [DataSource=< servidormaquinavirtual> Database= basededatos]. The underlying error message received was: 'A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)'.

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,631 questions
0 comments No comments
{count} votes

Accepted answer
  1. Dave Patrick 426.2K Reputation points MVP
    2021-08-13T21:03:28.453+00:00

    Q&A forums are currently English only. I'd try asking for help over here in dedicated forums.
    https://social.msdn.microsoft.com/Forums/es-es/home
    https://social.technet.microsoft.com/Forums/es-es/home
    https://answers.microsoft.com/es-es

    --please don't forget to upvote and Accept as answer if the reply is helpful--

    0 comments No comments

0 additional answers

Sort by: Most helpful