Forum Discussion
PostgresSQL connection in on-premise gateway
No se puede conectarHemos detectado un error al intentar conectar con . Detalles: "No se pudo registrar este origen de datos para ninguna instancia de puerta de enlace en este clúster. A continuación encontrará más información sobre los errores específicos de cada instancia de puerta de enlace."
| Identificador de actividad: | 9ba071bf-0185-46dd-9971-04fc3cd32203 |
| Identificador de la solicitud: | 591da1d2-0828-f7f9-73ec-6af1dc9d1a92 |
| URI de clúster: | |
| Código de estado: | 400 |
| Código de error: | DMTS_PublishDatasourceToClusterErrorCode |
| Hora: | Wed Jul 03 2019 17:26:31 GMT-0500 (hora de verano central) |
| Versión: | 13.0.9933.240 |
| CNTITBI: | Credenciales de conexión no válidas. |
| Código de error subyacente: | -2147467259 |
| Mensaje de error subyacente: | The credentials provided for the PostgreSQL source are invalid. (Source at 192.168.251.178;postgres.) |
| DM_ErrorDetailNameCode_UnderlyingHResult: | -2147467259 |
| Microsoft.Data.Mashup.CredentialError.DataSourceKind: | PostgreSQL |
| Microsoft.Data.Mashup.CredentialError.DataSourcePath: | 192.168.251.178;postgres |
| Microsoft.Data.Mashup.CredentialError.Reason: | AccessUnauthorized |
| Microsoft.Data.Mashup.MashupSecurityException.DataSources: | [{"kind":"PostgreSQL","path":"192.168.251.178;postgres"}] |
| Microsoft.Data.Mashup.MashupSecurityException.Reason: | AccessUnauthorized |
hello I'm trying to connect to a PostgreSQL database through on premise gateway and I'm getting this error, validate the credentials and even then it does not work, install on the gateway server the npgsql 2.2.4.3 add-on so that the connection could be made without problem, some help in this regard?
3 Replies
Hi Anonymous ,
Please install Npgsql provider on the gateway machine and make sure that you have access to the postgreSQL data source on the gateway machine.
There are two similar threads for your reference:
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.
Best regards
Amy
