Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Browse by Tags · View All
#SQLServer 46
SQL Server 44
SSRS EXPERT 41
BI 36
#BI 33
brh 28
SSIS BEST PRACTICES 23
TSQL 19
MS BI STACKS 18
SSRS 17

Archive · View All
March 2011 24
July 2011 17
February 2011 15
April 2010 13
June 2011 11
May 2011 11
April 2011 11
July 2010 11
March 2010 8
December 2011 7

SSRS & SSAS #62 – Create a data source on Report Server for an Analysis Services database

Dec 30 2011 12:34AM by Sherry Li   

The team I recently moved into had never had a data source created on their report server for an Analysis Services source.

A co-worker helped me got a data source created with Microsoft SLQ Server Analysis Services as the Data Source Type.

For credentials for connection, we correctly flagged “Credentials stored securely in the report server” with the right User name and Password.

The initial try of using the newly created data source failed, however. After fixing two issues, the configuration for the data source finally worked. The final configuration is shown below.

Since I don’t do this kind of task every day, I thought it would be a good idea to write down how we fixed the issues.

1. The user name for the connection should be part of the server role

This is the error message from the report server before we made sure that the user name is part of the server instance role.

In SSMS, right click on the Analysis Services server instance, select Properties. On the Security tab, make sure that the user name is added. I have a little doubt about the user being part of the Server administrators. It seems to be too much privilege to me.

2. Check "Use as Windows credentials when connecting to the data source”

Before we check this option, here is the error we got:

I guess this has to do with the fact that we can only connect to Analysis Services (and also Integration Services) instance via Windows Authentication.

(Note: in the screen shot above, ignore the red warning about invalid password. I changed the User name to be a fake user name for this blog.)

Tags: SSRS EXPERT,


Sherry Li
14 · 12% · 3827
1 Readers Liked this
Guru Samy Liked this on 3/27/2012 4:10:00 AM
Profile · Blog
1
Liked
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

Your Comment


Sign Up or Login to post a comment.

"SSRS & SSAS #62 – Create a data source on Report Server for an Analysis Services database" rated 5 out of 5 by 1 readers
SSRS & SSAS #62 – Create a data source on Report Server for an Analysis Services database , 5.0 out of 5 based on 1 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]