Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

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

Hi @Anonymous,

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!

Blog: nickyvv.com | @NickyvV


View solution in original post

2 REPLIES 2
nickyvv
Community Champion
Community Champion

Hi @Anonymous,

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!

Blog: nickyvv.com | @NickyvV


Anonymous
Not applicable

Thank you.

 

it was bad credentials.

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors