Forum Discussion
An error while connecting to SQL base
Hello! When I try to connect to SQL Server I recieve an error: An error happened while reading data from the provider: 'Could not load file or assembly 'System.EnterpriseServices, Version=4.0.0...
FarhanAhmed We use the latest version of PBI desktop. Trying to Get Data -> SQL Server.
There's no doubt the user has all needed permissions to SQL DB because when I run PBI desktop as Administartor and we authetificate using "alternative credentials" and enter user's credentials, everything works properly. But when user runs PBI desktop in usual way he gets this error just after he clicks Get Data -> SQL Server.
This is very known issue when using Alternate Credentials. Microsoft itself recommend it to open it using "Run As Administrator." Unfortunately whenever you will try to add new table in your model, you need to do it same.
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-error-launching-desktop