Issure trying to connect SQL Server to data gateway

[hapeta]

Hi

I'm trying to connect the installed gateway to an SQL server on the same subnet (two different machines).

I can connect the SQL server with Management Studio from the gateway-PC, but if I try to add this as data source I get the following error.

Any ideas or suggestions?

Best regards

Hans

Unable to connect: We encountered an error while trying to connect to . Details: "We could not register this data source for any gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."Hide details

Activity ID:	50186898-3db2-49ad-b751-41132045c52d
Request ID:	1bffbb7f-0095-d5be-0508-cb2d3ddbac18
Cluster URI:	https://wabi-west-europe-b-primary-redirect.analysis.windows.net
Status code:	400
Error Code:	DMTS_PublishDatasourceToClusterErrorCode
Time:	Sun Sep 09 2018 20:38:09 GMT+0200
Version:	13.0.6617.115

PowerBI Gateway:	Cannot connect to the database.
Underlying error code:	-2146232060
Underlying error message:	Die von der Anmeldung angeforderte SRV02\SQLEXPRESS-Datenbank kann nicht geöffnet werden. Fehler bei der Anmeldung. Fehler bei der Anmeldung für den Benutzer '****'.
DM_ErrorDetailNameCode_UnderlyingHResult:	-2146232060
DM_ErrorDetailNameCode_UnderlyingNativeErrorCode:	4060

[v-jiascu-msft · Accepted solution]

Hi @hapeta,

Can you connect to it from Desktop in the gateway machine? I would suggest you check out the credential. Can you share the connection parameter when you set up the gateway? You can mask some sensitive part. Maybe you try another credential for there is more than one credential type.

Best Regards,

Dale

[hapeta]

Hi Dale,

it worked. My mistake was I wrote the named instance in the Database field.

With the name of the database it worked.

Thank you

[hapeta]

I forgot to mention that on the SQL server are two named instances:

one SQL Server 2014 that works with the data gateway and one SQL Server Express that gives me the error.

Any ideas?

Thank you