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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

PedroCGDCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.