question

CarlosEduardoVasquez-4444 avatar image
0 Votes"
CarlosEduardoVasquez-4444 asked DSPatrick answered

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

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-supported
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

DSPatrick avatar image
0 Votes"
DSPatrick answered

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--


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.