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

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
david_busint
Frequent Visitor

Power BI Gateway SQL Server Connection Issues

Hi all,

 

We've been trying to update our gateway to version 3000.258.5 and whilst the install went OK our SQL Server connections on the gateway have stopped working. We've rolled back the server to the pre-update state and they're working fine again.

 

The error we're getting is...

 

'Unable to update connection credentials. Logging into Sql server failed. Possible reasons for this error include an invalid authentification mode, a missing login in Sql server, a login from an untrusted domain or a prblem contacting the doman controller for the authentification request. 

 

Details:

 

XXXXXXXXX: Received error payload from gateway service with ID XXXXX: SqlException encountered while accessing the target data source.

 

Please have this information handy if you choose to create a support ticket.

 

Session Id: XXXX

RequestId: XXXX

Cluter URL: httops://api.powerbi.com

Status code: 400

Time: XXX'

 

Any ideas why the existing SQL Server connections no longer work with the new version of the gateway?

 

 

2 ACCEPTED SOLUTIONS
v-ssriganesh
Community Support
Community Support

Hi @david_busint,
Thank you for reaching out to the Microsoft fabric community forum.

I appreciate the valuable insights shared by @gtiwari11 and @lbendlin. The troubleshooting guide provided is a great starting point, and checking for domain trust issues, as suggested, is also a valid consideration.

Regarding your issue with SQL Server connections failing after the gateway update, here are some additional steps you can consider:

  • Please verify the authentication mode in your data source settings and confirm that the credentials stored in the gateway are still valid. Updates can occasionally reset or invalidate saved credentials, necessitating reconfiguration.
  • Go to Manage Gateways in the Power BI Service and verify that your SQL data source is still correctly mapped. Try re-entering the credentials and saving the connection again.
  • Some gateway updates enforce stricter security settings. If your SQL Server requires encrypted connections, check if this setting has changed post-update.
  • You can find logs in the installation folder of your on-premises gateway. Look for errors related to authentication or connectivity.


If this helps, then please Accept it as a solution and dropping a "Kudos" so other members can find it more easily.
Thank you.

View solution in original post

12 REPLIES 12
gtiwari11
Regular Visitor

Thanks you, It pickup the defualt Password (Browser saved password) however I have just re-set it(browser). It worked now thanks!! again 

v-ssriganesh
Community Support
Community Support

Hi @david_busint,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

I'm going to test the proposed solution later this week

Hello @david_busint,

Could you please confirm if your query have been resolved? If they have, kindly mark the helpful response and accept it as the solution. This will assist other community members in resolving similar issues more efficiently.

Thank you.

 

I wasn't able to attempt the fix last week. Will be giving it a go this week instead. 

Hi @david_busint,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

 

v-ssriganesh
Community Support
Community Support

Hi @david_busint,
Thank you for reaching out to the Microsoft fabric community forum.

I appreciate the valuable insights shared by @gtiwari11 and @lbendlin. The troubleshooting guide provided is a great starting point, and checking for domain trust issues, as suggested, is also a valid consideration.

Regarding your issue with SQL Server connections failing after the gateway update, here are some additional steps you can consider:

  • Please verify the authentication mode in your data source settings and confirm that the credentials stored in the gateway are still valid. Updates can occasionally reset or invalidate saved credentials, necessitating reconfiguration.
  • Go to Manage Gateways in the Power BI Service and verify that your SQL data source is still correctly mapped. Try re-entering the credentials and saving the connection again.
  • Some gateway updates enforce stricter security settings. If your SQL Server requires encrypted connections, check if this setting has changed post-update.
  • You can find logs in the installation folder of your on-premises gateway. Look for errors related to authentication or connectivity.


If this helps, then please Accept it as a solution and dropping a "Kudos" so other members can find it more easily.
Thank you.

lbendlin
Super User
Super User

Untrusted domain - look at the blog entries for prior gateway versions where they discuss how you can override that if needed.

Do you have a link to where you can see how to override?

 

JB

Thanks for this - was a great help!

 

JB

gtiwari11
Regular Visitor

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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

"); $(".slidesjs-pagination" ).prependTo(".pagination_sec"); $(".slidesjs-pagination" ).append("
"); $(".slidesjs-play.slidesjs-navigation").appendTo(".playpause_sec"); $(".slidesjs-stop.slidesjs-navigation").appendTo(".playpause_sec"); $(".slidesjs-pagination" ).append(""); $(".slidesjs-pagination" ).append(""); } catch(e){ } /* End: This code is added by iTalent as part of iTrack COMPL-455 */ $(".slidesjs-previous.slidesjs-navigation").attr('tabindex', '0'); $(".slidesjs-next.slidesjs-navigation").attr('tabindex', '0'); /* start: This code is added by iTalent as part of iTrack 1859082 */ $('.slidesjs-play.slidesjs-navigation').attr('id','playtitle'); $('.slidesjs-stop.slidesjs-navigation').attr('id','stoptitle'); $('.slidesjs-play.slidesjs-navigation').attr('role','tab'); $('.slidesjs-stop.slidesjs-navigation').attr('role','tab'); $('.slidesjs-play.slidesjs-navigation').attr('aria-describedby','tip1'); $('.slidesjs-stop.slidesjs-navigation').attr('aria-describedby','tip2'); /* End: This code is added by iTalent as part of iTrack 1859082 */ }); $(document).ready(function() { if($("#slides .item").length < 2 ) { /* Fixing Single Slide click issue (commented following code)*/ // $(".item").css("left","0px"); $(".item.slidesjs-slide").attr('style', 'left:0px !important'); $(".slidesjs-stop.slidesjs-navigation").trigger('click'); $(".slidesjs-previous").css("display", "none"); $(".slidesjs-next").css("display", "none"); } var items_length = $(".item.slidesjs-slide").length; $(".slidesjs-pagination-item > button").attr("aria-setsize",items_length); $(".slidesjs-next, .slidesjs-pagination-item button").attr("tabindex","-1"); $(".slidesjs-pagination-item button").attr("role", "tab"); $(".slidesjs-previous").attr("tabindex","-1"); $(".slidesjs-next").attr("aria-hidden","true"); $(".slidesjs-previous").attr("aria-hidden","true"); $(".slidesjs-next").attr("aria-label","Next"); $(".slidesjs-previous").attr("aria-label","Previous"); //$(".slidesjs-stop.slidesjs-navigation").attr("role","button"); //$(".slidesjs-play.slidesjs-navigation").attr("role","button"); $(".slidesjs-pagination").attr("role","tablist").attr("aria-busy","true"); $("li.slidesjs-pagination-item").attr("role","list"); $(".item.slidesjs-slide").attr("tabindex","-1"); $(".item.slidesjs-slide").attr("aria-label","item"); /*$(".slidesjs-stop.slidesjs-navigation").on('click', function() { var itemNumber = parseInt($('.slidesjs-pagination-item > a.active').attr('data-slidesjs-item')); $($('.item.slidesjs-slide')[itemNumber]).find('.c-call-to-action').attr('tabindex', '0'); });*/ $(".slidesjs-stop.slidesjs-navigation, .slidesjs-pagination-item > button").on('click keydown', function() { $.each($('.item.slidesjs-slide'),function(i,el){ $(el).find('.c-call-to-action').attr('tabindex', '-1'); }); var itemNumber = parseInt($('.slidesjs-pagination-item > button.active').attr('data-slidesjs-item')); $($('.item.slidesjs-slide')[itemNumber]).find('.c-call-to-action').attr('tabindex', '0'); }); $(".slidesjs-play.slidesjs-navigation").on('click', function() { $.each($('.item.slidesjs-slide'),function(i,el){ $(el).find('.c-call-to-action').attr('tabindex', '-1'); }); }); $(".slidesjs-pagination-item button").keyup(function(e){ var keyCode = e.keyCode || e.which; if (keyCode == 9) { e.preventDefault(); $(".slidesjs-stop.slidesjs-navigation").trigger('click').blur(); $("button.active").focus(); } }); $(".slidesjs-play").on("click",function (event) { if (event.handleObj.type === "click") { $(".slidesjs-stop").focus(); } else if(event.handleObj.type === "keydown"){ if (event.which === 13 && $(event.target).hasClass("slidesjs-play")) { $(".slidesjs-stop").focus(); } } }); $(".slidesjs-stop").on("click",function (event) { if (event.handleObj.type === "click") { $(".slidesjs-play").focus(); } else if(event.handleObj.type === "keydown"){ if (event.which === 13 && $(event.target).hasClass("slidesjs-stop")) { $(".slidesjs-play").focus(); } } }); $(".slidesjs-pagination-item").keydown(function(e){ switch (e.which){ case 37: //left arrow key $(".slidesjs-previous.slidesjs-navigation").trigger('click'); e.preventDefault(); break; case 39: //right arrow key $(".slidesjs-next.slidesjs-navigation").trigger('click'); e.preventDefault(); break; default: return; } $(".slidesjs-pagination-item button.active").focus(); }); }); // Start This code is added by iTalent as part of iTrack 1859082 $(document).ready(function(){ $("#tip1").attr("aria-hidden","true").addClass("hidden"); $("#tip2").attr("aria-hidden","true").addClass("hidden"); $(".slidesjs-stop.slidesjs-navigation, .slidesjs-play.slidesjs-navigation").attr('title', ''); $("a#playtitle").focus(function(){ $("#tip1").attr("aria-hidden","false").removeClass("hidden"); }); $("a#playtitle").mouseover(function(){ $("#tip1").attr("aria-hidden","false").removeClass("hidden"); }); $("a#playtitle").blur(function(){ $("#tip1").attr("aria-hidden","true").addClass("hidden"); }); $("a#playtitle").mouseleave(function(){ $("#tip1").attr("aria-hidden","true").addClass("hidden"); }); $("a#play").keydown(function(ev){ if (ev.which ==27) { $("#tip1").attr("aria-hidden","true").addClass("hidden"); ev.preventDefault(); return false; } }); $("a#stoptitle").focus(function(){ $("#tip2").attr("aria-hidden","false").removeClass("hidden"); }); $("a#stoptitle").mouseover(function(){ $("#tip2").attr("aria-hidden","false").removeClass("hidden"); }); $("a#stoptitle").blur(function(){ $("#tip2").attr("aria-hidden","true").addClass("hidden"); }); $("a#stoptitle").mouseleave(function(){ $("#tip2").attr("aria-hidden","true").addClass("hidden"); }); $("a#stoptitle").keydown(function(ev){ if (ev.which ==27) { $("#tip2").attr("aria-hidden","true").addClass("hidden"); ev.preventDefault(); return false; } }); }); // End This code is added by iTalent as part of iTrack 1859082
Top Solution Authors