Failed to install on-prem Data Gateway Standard (Enterprise)

[Anonymous]

Hi there,

I'm trying to install gateway on the server to connect to SQL Server on prem. The installation was almost finished but failed at the very end. I open the error log, and at the very last line it shows this:

I tried several times and still same error. I also tried installing personal gateway, and it worked. But i dont want personal version. I also checked the requirements and everything is ticked. Windows Server 2012 R2, high RAM and storage.

Strange thing is i can install personal but not standard version.

Can anyone help me with this?

Thank you.

[v-jingzhang]

Hi @Anonymous 

Try the solution from this link On-premises_data_gateway install procedure fails in the end...

Right click on GatewayInstall file and select Run as administrator. And don't change the default installation path.

Other references:

Power BI On-premises data gateway install failed - Microsoft Power BI Community

MSI installation error 1603 - Windows Server | Microsoft Docs

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

[HashamNiaz]

Hi @Anonymous !

Please follow the MS documentation to Install Standard gateway;

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-install 

Please pay attention to points;

• A 64-bit version of Windows 8 or a 64-bit version of Windows Server 2012 R2 with current TLS 1.2 and cipher suites

Also see Related considerations section.

Regards,

Hasham