When I prcess the (SSAS) cube through management studio, i am able to
process but I open the cube through bussiness intelligence, when i try to
process i am getting this error.

A connection cannot be made to redirector, Ensure that SQL Browser is running.

Even without modifiying anything, if i try to process it fails, Through
control panel i checked Browser is running on server and also on my local
m/c, (Installed SQL Server 2005 on my local m/c also)

any help/suggestions

thanks
Kalyan

hello Kalyan,

are you sure you are connecting to the same server from SSMS and BIDS?
when you open solution in BIDS, in the solution explorer right click on the
project node, select Properties;
the in the popup window select Deployment, and check the Target->Server
setting.

-- mary
--
This posting is provided "AS IS" with no warranties, and confers no rights.
--
"Kalyan" <Kalyan (AT) discussions (DOT) microsoft.com> wrote

Hello Mary

I opened FoodMart database from BI, (File - Open - Analysis Services
Database), it brings me up foodmart cubes. Without changing anything i
proceess the cube, it gives

Connection cann't be made to redirect, make sure SQL Browser is running.

i checked SQL Browser is running on both server and my local pc (installed
SQL Server 2005 on my pc also)



I am connecting Server in the Network (Not my local m/c). When I open from
BI, it ask me to sever name then it display all the database, from there i
selected FoodMart,

This makes clear i am able to connect.

And also as per your suggestion, I cann't see deployment menu, What I did,
on Solutions Explorerer, right click FoodMart (my server name), go to
property it didn't bring any thing, how can i check what is deployment server.


Is there any process i need to do, after open the database.

I want to add new dimension to existing cube, how to do this

Thanks
Kalyan

"Mary Potapova [MS]" wrote:

hello Kalyan,

it looks like i misunderstood: i thought you were working in project mode in
BIDS, but you actually seem to be working in on-line mode there. (in on-line
mode there are no properties that i was referring to)



so do i get it right then that what you see is: from the same box (and same
user), you connect to a database on server x from SSMS and you are able to
connect and process fine; however, when you open the same database from the
same server x, inside BIDS, then at first you are able to connect (since you
are able to see cubes etc.), however later when you try to process you
actually get connection error?

thanks,
-- mary
--
This posting is provided "AS IS" with no warranties, and confers no rights.
--
"Kalyan" <Kalyan (AT) discussions (DOT) microsoft.com> wrote

Marry

Yes, Now you got it, Now we are in same page, can u help me to solve my
problem

thanks
Kalyan


"Mary Potapova [MS]" wrote: