Yes, more specific question. Although they are bundled together, the applications are distinctly, and secured, differently. For SQL Server, use the SQLEM interface or direct administrative sp queries. For OLAP, use the AM interface--for this, you will need to be a member of the OLAP Administrators group on the server hosting the analysis services, even if you are already a local Administrator.

Sincerely,


Anthony Thomas, MCDBA, MCSA


-----Original Message-----
From: RRazzano
[mailto:mssqldba-ezmlmshield-x45247251.[Email address protected]
Sent: Friday, July 30, 2004 10:54 AM
To: LazyDBA Discussion
Subject: RE: OLAP Access in SQL Server


Can you be more specific? Are you trying to access an OLAP server via a
SQL Server query?

-----Original Message-----
From: Khosla Munish
[mailto:mssqldba-ezmlmshield-x35029616.[Email address protected]
Sent: Friday, July 30, 2004 10:46 AM
To: LazyDBA Discussion
Subject: OLAP Access in SQL Server



Hi,

Can anybdy please let me know how we can grant olap access in SQL
Server.

Rgds,
Munish Khosla



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]




***********************************************************************
NOTICE: This electronic mail message and any attached files are
confidential. The information is exclusively for the use of the
individual or entity intended as the recipient. If you are not the
intended recipient, any use, copying, printing, reviewing, retention,
disclosure, distribution or forwarding of the message or any attached
file is not authorized and is strictly prohibited. If you have received
this electronic mail message in error, please advise the sender by reply
electronic mail immediately and permanently delete the original
transmission, any attachments and any copies of this message from your
computer system.
***********************************************************************

MS Sql Server LazyDBA home page