I am trying to connect to an Analysis service server using basic authentication from the application which already uses SQL authentication to connect to the SQL database. Can I use both SQL authentication and Basic authentication from the same application. It is a .Net application
What I have tried:
The application uses SQL authentication for login pages and for all function that uses SQL database.When ever I am changing the application pool from Integrated to classic the application is throwing error 'The page you are requesting cannot be served because of the ISAPI and CGI restrictions list settings on the web server'
Can you please tell me whether both Basic and SQL authentication works from the same application