OData connection authentication error 500

Hello all,  I keep getting a 500 error when trying to access my published OData service.  The OData service has one allowed user: DataAnalist, who has full read rights on the two entities I've published (without associations included in the service) in this OData service. When entering the credentials for this user - either in the browser or in Excel (where I want to import the data), I get an error (see below).    <error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"> <code>500</code> <message xml:lang="en-US">Authentication failed.</message> </error>   In Excel it also gives me the 500 error, and before entering the credentials, it says: 'De server geeft (null) aan als serverbron'.    Can anyone help me?   
0 answers