Can not connect to the server

[Kavi_9907]

I logged into my lap from my ad account (####\KavyaD) and login in to power bi using the same account. but due to a security concern, we have separate account to login into servers (####\KavyaDAU) . old server is ##.###.###.209 and recently bought a new server ##.###.###.6. i can go to remote desktop connection and log into the server and see the databases using ssms. and to access the server from local machine, i run the ssms by run as different user and use my KavyaDAU account to login. and i login to power bi using my ad account (KavyaD) and when i select get data and give the server ip address as ##.###.###.209, it connects. but when i add ##.###.###.6, it does not connect. gives an error saying " We encounted an error while trying to connect. Details: "Microsoft SQL: The target principal name is incorrect. Cannot generate SSPI context.". but it works for 209. then i tried login to ssms from my local machine by giving run as different user and gave credentials of my KavyaDAU account. that works for 209 but not works for 6. So there's a issue in server side not from power bi side. What should i do?

[v-veshwara-msft]

Hi @Kavi_9907 ,

Just checking in to see if you query is resolved and if any responses were helpful.
Otherwise, feel free to reach out for further assistance.

Thank you.

[Kavi_9907]

now database works when i open it through ssms seperately but when i import data into power bi, it gets an error. 
"Loading assembly file 'System.EnterpriseServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' failed for data source type 'SQL'"

[v-veshwara-msft · Accepted solution]

Hi @Kavi_9907 ,

Thanks for sharing the update.

The error you are now seeing "Loading assembly file 'System.EnterpriseServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' failed for data source type 'SQL'" is usually related to missing or corrupted .NET Framework components that Power BI depends on. You can try the following:

1. Ensure that the .NET Framework is properly installed and up to date on your machine. Repair or reinstall the .NET Framework if required.
   Microsoft provides .Repair the .NET Framework - .NET Framework | Microsoft Learn.
   .NET Framework & Windows OS versions - .NET Framework | Microsoft Learn

2. Make sure Windows and Power BI Desktop are updated to the latest versions.

3. Clear saved data source credentials from Data Source Settings -> Edit Permissions, then re-enter the SQL credentials.

4. If the issue persists, try reinstalling Power BI Desktop after repairing .NET.

Similar issue threads:
Solved: Getting Connection error while connecting SQL Serv... - Microsoft Fabric Community

Could not load file or assembly 'System.Enterprise... - Microsoft Fabric Community

Hope this helps. Please reach out for further assistance.

Thank you.

[v-veshwara-msft]

Hi @Kavi_9907 ,
Just wanted to check if the response provided was helpful. If further assistance is needed, please reach out.
Thank you.

[v-veshwara-msft]

Hi @Kavi_9907 ,
We wanted to kindly follow up regarding your query. If you need any further assistance, please reach out.
Thank you.

[v-veshwara-msft]

Hi @Kavi_9907 ,

Thanks for reaching out to Microsoft Fabric Community and sharing the details.

The error you are seeing is a Kerberos-related issue that usually occurs with SQL Server authentication.

You can try these steps:

1. First, update the server name in Data Source Settings if the SQL Server’s IP or hostname has changed, and check if the connection works.

2. If that doesn’t resolve it, go to Data Source Settings -> Edit Permissions -> Credentials -> Edit, switch to Database, and re-enter the SQL credentials for the affected database.

3. If the issue still persists, refresh both the server and database credentials instead of only updating the names.

Similar discussions:

ERRORDetails: "Microsoft SQL: The target principal... - Microsoft Fabric Community

Microsoft SQL: The target principal name is incorr... - Microsoft Fabric Community

Hope this helps. Please reach out for further assistance.

Thank you.

[v-veshwara-msft]

Hi @Kavi_9907 ,
Just wanted to check if the response provided was helpful. If further assistance is needed, please reach out.
Thank you.