I am not able to connect to Analysis services

I have installed a SQL server 2005.

i built a cube in SQL server BI studio but unable to deploy the project. giving a msg

Error 1 The project could not be deployed to the 'localhost' 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.

please help me in getting the project deployed.

thanx in advance.
LVL 1
amiteshanandAsked:
Who is Participating?
 
PedroCGDConnect With a Mentor Commented:
1. You can connect to SSAS Server via SQL Server Management Studio?
2. Is your server in LOCALHOST?
Check the attached image... to change the server name...

Remember: You have 2 connections in a normal SSAS Project... one the OLTP/Source database and one to the OLAP/Destination database.

Helped?
regards!
Pedro
www.pedrocgd.blogspot.com
SSASserver.JPG
0
 
PedroCGDCommented:
IMprovements?
0
 
amiteshanandAuthor Commented:
I am trying to connect to SSAS cube from Excel. I have been following this link : http://www.microsoft.com/technet/prodtechnol/sql/2005/httpasws.mspx This worked for in the staging environment where i have WFE and Database server both as same server. On the production environment the database server and WFE are two different server. I am unable to connect to server as it throws an error message: Unable to connect to database.
0
 
PedroCGDCommented:
Your original question as 2 months ago, and you never replied.
Open another topic for the new question and close this as resolved.
Regards,
Pedro
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.