So we got Visual Source Safe installed yesterday and I’ve started uploading projects, so naturally I go to set an Analysis Services Project.
Everything goes fine, I am able to check out the project, but when I go into the “Calculations” page in the Cube I notice the following error:
Unable to query the ‘CUBENAME’ cube: ‘A connection cannot be made to redirector. Ensure that ‘SQL Browser’ service is running.’. The cube must be queried for you to browse data or meta data. Click here to retry the connection.
We have been doing all of our Analysis Services Projects on the Analysis Server itself until recently, so this error was getting thrown while on my laptop (1337 DBA Station). Keeping that in mind, the problem was obvious.
Right click and select the properties of your Analysis Services Project and ensure the target server name is the correct network name.