Hi,
although I read thru several threads I still did not really find a solution for my problem. I have installed a SQL server on a server, including all components (SP1 is already installed) but I cannot connect to SSAS nor can I deploy a solution with BIDS.
I receive the error message
Error 1 The project could not be deployed to the 'server\instancename' server because of the following connectivity problems : A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server.
As far as I understood other threads it has to do with permissions. I am using domin accounts for sql server, analysis server and sql browser. Those domain accounts are member of the administration group. I already tested the case, that the sql browser service is running under the same account as the SSAS but the result is still the same. I also added this account to the AdventureWorksDW database, aliased it to the dbo but it had no effect.
Can someone give some hints what kind of permissions need to be set on the different levels or where else I should take a look at.
Thanks in advance
Norbert
Problem with connecting to SSAS and also deploying projects to SSAS
hwiz
Hello. Have you checked the port for your instance like described here: (http://www.sqljunkies.com/WebLog/edwardm/archive/2006/05/26/21447.aspx)
Regards
Thomas Ivarsson
Kolf
thanks for the link. I found the solution there. I installed the newest version of the components and connecting to hostname:portname was succesful (connecting to Analysis services).
I could NOT get it running by using the SQL Browser. Anyway, using a fixed port is ok for me