Does anyone know how to resolve the issue when presented with the following error message when trying to select a datasource for a report in SQL Server Analysis Services?
Non-Windows user credentials were supplied for a non-http connection to Analysis Services. The Microsoft SQL Server Analysis Services data extension requires Windows Integrated Security unless connecting via http or https.
The answer depends on configuration - protocols, whether SQL Server is local/remote, in Active Directory/Workgroup, on versions/editions of operating system and SQL Server, etc. and how they are configured.
SSAS supports only Windows Integrated Authentication.
The topic starter devlife answered that he should have checked ""Use as windows credentials when connecting to the data source".
I answer it because I want to have this post in my lists and comments will be lost.