How to Register OLAP Server

#1

You will need Analysis Services -> Analysis Manager to
connect to the OLAP Server.

As Enterprise manager is for SQL Server, Analysis Manager
is for Analysis Services (OLAP Server).

Similarly,
As Query Analyser is for executing SQL Queries, MDX Sample
Application is for executing MDX Queries.

Cheers,
Sanka

Quote:

-----Original Message-----
Hello Everybody,
I have SQL Server 2000 and OLAP Server Installed on
remote machine. on
my local machine I have Enterprise Manager to connect to
SQL Server and it
is connecting to SQL Server but it is not connecting to
OLAP Server from
local computer. Can anybody guide me how to connect to
OLAP Server.

.

#2

Check whether

1) You are able to ping to that machine from your machine.
2) MSSQLServerOLAPService is started on the machine you
are trying to connect.
3) Your ID has been added to the OLAP Administrators group
in the machine you are trying to connect.

HTH.
Cheers,
Sanka

Quote:

-----Original Message-----
Hi,
I know that. When I ask it to register the OLAP
Server, it asks me the
name of OLAP Server. When I write OLAP Server Name and
click OK. it gives me
error that "Server not Found.
"Sanka" <loonysan (AT) mailcity (DOT) com> wrote in message
news:024a01c376a6$4f040ca0$a001280a (AT) phx (DOT) gbl...
You will need Analysis Services -> Analysis Manager to
connect to the OLAP Server.

As Enterprise manager is for SQL Server, Analysis
Manager
is for Analysis Services (OLAP Server).

Similarly,
As Query Analyser is for executing SQL Queries, MDX
Sample
Application is for executing MDX Queries.

Cheers,
Sanka

-----Original Message-----
Hello Everybody,
I have SQL Server 2000 and OLAP Server Installed on
remote machine. on
my local machine I have Enterprise Manager to connect
to
SQL Server and it
is connecting to SQL Server but it is not connecting to
OLAP Server from
local computer. Can anybody guide me how to connect to
OLAP Server.

.

.

#3

Right Click on "My Computer" icon in the Desktop.
Select "Manage". "Computer Management" console will open...

Expand "Local Users and Groups".
Select "Groups"
Double Click on the "OLAP Administrators" item....
Add your ID.

HTH.
Cheers,
Sanka

Quote:

-----Original Message-----
Hello Sanka
First two things are OK. the third one "to ADD ID to
the OLAP
Administrators group
" is missing, I think. How to add my ID to OLAP
Administrators group and on
which machine.
waiting for your reply
Thanks

"Sanka" <loonysan (AT) mailcity (DOT) com> wrote in message
news:539301c376bf$b81aefb0$a601280a (AT) phx (DOT) gbl...
Check whether

1) You are able to ping to that machine from your
machine.
2) MSSQLServerOLAPService is started on the machine you
are trying to connect.
3) Your ID has been added to the OLAP Administrators
group
in the machine you are trying to connect.

HTH.
Cheers,
Sanka

-----Original Message-----
Hi,
I know that. When I ask it to register the OLAP
Server, it asks me the
name of OLAP Server. When I write OLAP Server Name and
click OK. it gives me
error that "Server not Found.
"Sanka" <loonysan (AT) mailcity (DOT) com> wrote in message
news:024a01c376a6$4f040ca0$a001280a (AT) phx (DOT) gbl...
You will need Analysis Services -> Analysis Manager
to
connect to the OLAP Server.

As Enterprise manager is for SQL Server, Analysis
Manager
is for Analysis Services (OLAP Server).

Similarly,
As Query Analyser is for executing SQL Queries, MDX
Sample
Application is for executing MDX Queries.

Cheers,
Sanka

-----Original Message-----
Hello Everybody,
I have SQL Server 2000 and OLAP Server
Installed on
remote machine. on
my local machine I have Enterprise Manager to
connect
to
SQL Server and it
is connecting to SQL Server but it is not
connecting to
OLAP Server from
local computer. Can anybody guide me how to connect
to
OLAP Server.

.

.

.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How to Register OLAP Server

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

How to Register OLAP Server - 09-09-2003 , 02:45 AM

Re: How to Register OLAP Server - 09-09-2003 , 05:47 AM

Re: How to Register OLAP Server - 09-09-2003 , 10:22 PM