SQL Server error while connecting

[Rohanbhowmick]

Hello ,

I need help while trying connecting to SQL server from powerbi desktop below error is throwing

So I am trying to connect the RDS string that is connected with SQL server , and that particular database string has multiple database in it , but when I am trying to connect a particular database this error is coming, not with any other database, so what is this issue can someone help me.

Even I have tried this below method

• For on-premises data gateway
  1. Ask your on-premises data gateway administrator go to the local machine where the on-premises data gateway is installed, navigate to C:\Program Files\On-premises data gateway.
  2. Make a backup of the configuration file named Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config.
  3. Open the original Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config configuration file and locate the SqlTrustedServers entry.
  4. Update the SqlTrustedServers value with the names of the SQL servers to trust and connect to.

Still not working. 

Need help!

[wardy912 · Accepted solution]

Hi @Rohanbhowmick 

Unfortunately I don't have a direct solution for you, but this should help. It discusses the issue you're facing in detail and provides a possible kerberos fix towards the end.

Cannot generate SSPI context when connecting to SQL Server - SQL Server | Microsoft Learn

Hope this helps.

[v-pgoloju]

Hi @Rohanbhowmick,

Just following up to see if the responses provided was helpful in resolving your issue. Please feel free to let us know if you need any further assistance.

Best regards,

Prasanna Kumar

[v-pgoloju]

Hi @Rohanbhowmick,

Just following up to see if the solutions provided by community members were helpful in addressing the issue.

If one of the responses helped resolve your query, please consider marking the perticular response as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.

Best regards,
Prasanna Kumar

[v-pgoloju]

Hi @Rohanbhowmick,

Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to @tharunkumarRTK  and @wardy912 for their prompt and helpful respons.

Just following up to see if the responses provided by community members were helpful in addressing the issue.

If one of the responses helped resolve your query, please consider marking it as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.

Best regards,
Prasanna Kumar

[tharunkumarRTK · Accepted solution]

@Rohanbhowmick 

Are you using Service principal authentication? if yes then does that SPN has permissions to access the db that you are trying to connect? 

Have you tried connecting to that db from other client tools like SSMS, excel and data studio etc? if yes then were you able to connect?

Gateway instllation is not required in your case. 

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!

[wardy912 · Accepted solution]

Hi @Rohanbhowmick 

Unfortunately I don't have a direct solution for you, but this should help. It discusses the issue you're facing in detail and provides a possible kerberos fix towards the end.

Cannot generate SSPI context when connecting to SQL Server - SQL Server | Microsoft Learn

Hope this helps.