cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
achude
Helper I
Helper I

data source not able to connect

 

hello,

 

I need a little guidance,

i am trying to add a data source (SQL Server) to a newly installed gateway and I keep getting this error

error.JPG

I have searched in this community and online and most solutions are usually to update the gateway. but in my case, the gateway is up to date since it was downloaded today.

 

please how do I solve this?

1 ACCEPTED SOLUTION
nickyvv
Super User I
Super User I

Hi @achude,

What exactly do the details say if you click on Show details?

If it's an Azure SQL DB, you might have to open the firewall for the IP-address (or range) of the gateway server to reach that DB. Otherwise it might be bad credentials, but that's hard to guess from this point.



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


Blog: nickyvv.com | @NickyvV


View solution in original post

2 REPLIES 2
nickyvv
Super User I
Super User I

Hi @achude,

What exactly do the details say if you click on Show details?

If it's an Azure SQL DB, you might have to open the firewall for the IP-address (or range) of the gateway server to reach that DB. Otherwise it might be bad credentials, but that's hard to guess from this point.



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


Blog: nickyvv.com | @NickyvV


View solution in original post

Thank you.

 

it was bad credentials.

 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors
Top Kudoed Authors