Access Denied

Hi, i'm facing a problem, I have SQL Server 2000 instaled, the problem is when I try to connect using another computer, it can see the server, but when I try to connect i receive a Access Denied message. My TCP port is opened, and I can enter in the remote server using Query Analyzer, but I can't start the server using SQL Server Service Manager.

What is the problem?

Thanks.

Hi, I discovered what was wrong, I created a New Server Registration and added the remote computer on it.

Now everything is working fine.

sql

About Drilling down and drilling up in kpi's

hi all,

I am just a beginner in proclarity

I am facing a problem with the drill down and drill up operations in KPIDesigner

I am using the first option in the wizzard(Add a KPI with goal,status,trend to an existing KPI)

The measure that i selected is an aggregate value(Average)

But whenever i am trying to perform a drill down operation on the Data there is no correspondance between the drill down operation and the data displayed.

Pls help me asap

I would guess the drillthough into calculated cell or member is not possible. It is simply the fact that Analysis Services wouldnt know how to get the rows that contributed to the calculation.

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.