Blog author:
Jvprabhusanthi | Posted on: 5/4/2012 | Category:
SQL Server Blogs | Views: 615 | Status:
[Member] |
Points: 75
|
Alert Moderator
Here is one of the peculiar issue related to SSAS.Error Details---------------------------Microsoft Visual Studio---------------------------Cannot connect to Analysis Services version '10.50.1600.1'.---------------------------OK ---------------------------Error 1 The project could not be deployed to the 'Venkat-PC' server because of the following connectivity problems : Cannot connect to Analysis Services version '10.50.1600.1'. 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 usual, I have done the changes specified in the error message. Still, I couldn't figure out the issue.Eureka, got a strike on this issue.Can you guess the problem??????????Solution:
1. May be ur SSAS port is blocking( add port 2383 to the SQL Server Connections in the Windows Firewall.) 2. Ensure your SSAS services and Browser services is running fine in Services.msc console.
3. Right click on the project properties and check the deployment server as your server name instead of "local host"
4. Finally :-) Do not open your project in Microsoft Visual studio console. Instead try to open the BIDS tool to deploy your cubes. Some how, SSAS is not allowing the users to deploy the cubes from this console. (here is the mistake, I have done) Fortunately resolved it.
Cheers,Venkatesan Prabu .J Cheers,
Venkatesan Prabu .J
Head, KaaShiv InfoTech
http://kaashivinfotech.com/Ebooks.aspx
Found interesting? Add this to: