Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 242025 - Last Review: November 6, 2003 - Revision: 3.1
INF: How to Set Up Security for Linked Server to OLAP Services
This article was previously published under Q242025
A linked server configuration for OLAP Services allows SQL Server to execute commands against OLAP Services using the OLE DB provider for OLAP.
The following article in the Microsoft Knowledge Base provides information on how to set up linked server to OLAP services and send distributed queries:
218592Â
(http://kbalertz.com/Feedback.aspx?kbNumber=218592/EN-US/
)
HOW TO: Perform a SQL Server 7.0 Distributed Query with OLAP Server
This article explains some security considerations when linking to OLAP Services.
When setting up linked services to OLAP Server, the following should be considered:
- If the login is made to SQL Server using SQL Server security (login name and password), SQL Server passes the credentials of the SQL Server services startup account to OLAP services for authentication. If SQL Server authentication is used, then setup SQL Server services to run under either a local or domain user account rather than using SYSTEM account.
- If the login is made to SQL Server using Microsoft Windows NT authentication, then SQL Server passes the credentials of this Microsoft Windows NT account to OLAP services.
Depending on the login made to SQL Server, either the SQL Server services startup account or the Microsoft Windows NT account should have access to OLAP services. This can be done in one of the following two ways:
- Make this account part of the 'OLAP Administrator' local group on OLAP server computer.
-or- - Create a database role within OLAP Manager and provide this role with read/write access to the cubes.
Also, note that since the login name and password cannot be used to access OLAP services, the linked server login mappings do not serve any purpose.
APPLIES TO
- Microsoft SQL Server OLAP Services
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate