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.
I search about 3 days and hope this answer help someone : There are an option on SSRS for each report:
This Image
If u set there your information. this error will be fixed.
精彩评论