SSAS datasource connection issue
Hi there, I have difficulties to connect to an SSAS-database, which i can only access in SSMS (Management Studio) with administrive rights. I tried to create a datasource connection for Reporting Services with that (special) SSAS-Database, but its not shown in the database catalogue. I started BIDS with admin rights, but it wasnt shown neither. Has someone an idea or could provide with some hints? ;) Thanks for your anticipation.... Regards
April 23rd, 2011 7:06am

Hi, You could try adding your username in the Roles section in SSAS database. Provide full permission to the user and then try connecting it from BIDS. HTH, Ram
Free Windows Admin Tool Kit Click here and download it now
April 23rd, 2011 7:47am

Are you using sql or windows authentication in Management Studio?
April 23rd, 2011 9:30am

Sorry for my late reply, I edited the roles in SSAS and could fix that issue. Thanks for your help and efforts. Regards
Free Windows Admin Tool Kit Click here and download it now
April 28th, 2011 7:42am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics