One of the servers can’t see it’s own cubes. As a work-around you can Right-Click on the SSMS icon and select > Run as Administrator to get SSMS to see it’s own cubes: If you skip step in the setup where it asked you to add current user to AS server admin role, then you would need to run SSMS as administrator.
Posts from ‘December, 2009’
T-SQL Tuesday Date, Time, tricks with the DateTime Data Type
Adam Machanic told us all about a new craze sweeping the SQL Blogosphere Nation last week and that is T-SQL Tuesdays. Real quick, the way it works is that on Patch-Tuesday everyone who’s got something to say about the topic of the month releases a blog post about it and the “Host” of the topic [...]

