Hi, SSRS R2. I have to create a Report Model on a cube on a remote server. When a Data Source is created with "Credentials Stored Securely in the report server. and the below option checked. "Use as Windows credentials when connecting to the data source". But When a report is created on a top of the report model. The users are not able to run the report. I have also tried to create a data source with a domain account. It doesn't let me allow to create a Data Souce. "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." Please let me know how to get around this problem.Thanks in advance Tinku

Can you check if the users who are running report have access to the cube?

Does the user need to have access to the cube? Is there any other option without providing users access to the cube?

Check the connection properties in the data source. Select Do not use credentials. If you still facing this issue then check the analysis service data source view and select inherit option.

Tarakq, To be more clear. I am creating a Data source in report manager. I am unable to understand what you are saying can please elaborate. Tinku.

To be more clear. I am creating a Data source in report manager. I am unable to understand what you are saying can please elaborate. If you are not sure how to create a data source in Report Manager, create the data source in BIDS and copy the connection string and paste it when creating the data source in Report Manager. Also, check my post above. Hope that helps.

Your question is confusing so I thought you are doing it from BIDS. In the report manager, go to your report model and check what data sources it has and check their credentials. These credentials should be Windows Integrated Security. Tarak

Hi Tarak and Shahfaisal, Sorry for the confusion. I hope this is little more clear. Thanks Task is to create a Data Source in the Report Manager for the Report Model. Option 1: 1. Already, Created Data Source with my windows Username/pwd. "Credentials Stored Securely in the report server. and the below option checked. "Use as Windows credentials when connecting to the data source". 2. Create a report model successfully. But Users not able to access the reports. Because the users don't have access to the SSAS Database. Q1. Do the users need to have access to the SSAS Database? Is there any other option without giving access to the SSAS Database? Option 2: 1. Not a able to create a data source with a domain account(non windows). error returned as "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." Q2. Can we create a Data source(SSAS) with domain account? Q3. Please let me know which is correct way? Tinku

SSAS database connections only accept Windows Integrated Security. Check this option and let me know the result.

Windows integrated security is throwing the following error. The connection either timed out or was lost.

How do you want your users to connect or view the report or reports...http:???

Yes, by giving the user the report server url. and a data analysts should be able to run the reports from report builder.

Hello Tinkureddy, When creating your new data source with the dialogue option selected: Credentials stored securely in the report server Type in an username and password with the appropriate credentials..Do not check any dialogue boxes boxes below Password: Then select OK On your Home page select the properties tab choose New Role Assignment and add user or groups...Example for Group: SSRS_Group...Give them the browser Role...If you have separate folders setup under your Home page for example: Accounts Receivable Reports, Inventory Management Reports, etc...You will want to create additional groups for access...For example: Accounts Receivable Reports Folder = Account_Receivables_Users_SSRS, Inventory Management Reports Folder = Inventory_Management_Users_SSRS, etc...Then you would want to apply the individual users groups to the main Reporting services Group: SSRS_Group...From there you would want to apply the individual specific groups to the specific folders...Give them no more than the Browser Role... Hope this helps, WCC44

Hi WCC44, Thanks for the reply. The problem is my PWD changes everything three months or before. We also have a domain account and according to Taraq, SSAS only supports windows account. What is the solution in such cases.? Please help. Thanks Tinku

Hi Tinkureddy, What error are your users getting when they try to run the report from you first post???I am assuming these are your initial guidelines??? "Hi, SSRS R2. I have to create a Report Model on a cube on a remote server. When a Data Source is created with "Credentials Stored Securely in the report server. and the below option checked. "Use as Windows credentials when connecting to the data source". But When a report is created on a top of the report model. The users are not able to run the report."

Hi Tinkureddy, What error are your users getting when they try to run the report from your first post???I am assuming these are your initial guidelines??? "Hi, SSRS R2. I have to create a Report Model on a cube on a remote server. When a Data Source is created with "Credentials Stored Securely in the report server. and the below option checked. "Use as Windows credentials when connecting to the data source". But When a report is created on a top of the report model. The users are not able to run the report."

Hi Tinku, Please refer to the following link, and then check if it works for you. SQL Server Analysis Services Connectivity Issues: http://support.dundas.com/Dashboard25.SSAS_Connectivity.ashx If the issue still exists, could you please supply more details about it, such as the connect string for connect to the SSAS, is the SSAS server on the same domain with your domain? Thanks, Eileen