Error A Connection To The Olap Server Cannot Be Established
Samples & SAS Notes Focus Areas SUPPORT License Assistance Manage My Software Account Downloads & Hot Fixes TRAINING & BOOKS Books Training Certification SAS Global Academic Program SAS OnDemand For Academics USERS GROUPS Advanced Search support.sas.com Knowledge Base Support Training & Books Store Support Communities Knowledge Base Products & Solutions System Requirements Install Center Third-Party Software Reference Documentation Papers Samples & SAS Notes Browse by Topic Search Samples Search Usage Notes Search Installation Notes Search Problem Notes Focus Areas Problem Note 20001: The DEFINE statement for PROC OLAP does not honor SAS® Metadata Server connection options specified outside of the METASVR statement The METASVR statement in the OLAP procedure allows you to specify the connection options for your metadata environment. However, even if the SAS Metadata Server options are defined at initialization of the server or before the PROC OLAP code is submitted, the DEFINE statement within the OLAP procedure does not honor the settings. Errors will be generated when the DEFINE statement is encountered in the code. The SAS code and log output listed below illustrate the error received when the PROC OLAP code is submitted with metadata server connection options predefined, but no METASVR statement has been specified. options metaserver = host.name.com; options metaport = 8561; options metauser = "userid"; options metapass = "password"; options metaprotocol=bridge; option metarepository="Foundation"; PROC OLAP; METASVR olap_schema="SASMain - OLAP Schema"; define member '[Cubename].[Measures].[double]' AS '[Measures].[Quantitysum]*2'; run; NOTE: The default repository "Foundation" will be used. NOTE: The Data Cache is inactive COM Remote Server: host.name.com. ERROR: COM CoCreateInstanceEx() failed: (HRESULT=80080005). ERRO
Samples & SAS Notes Focus Areas SUPPORT License Assistance Manage My Software Account http://support.sas.com/kb/20/001.html Downloads & Hot Fixes TRAINING & BOOKS Books Training Certification SAS Global Academic Program SAS OnDemand For Academics USERS GROUPS Advanced Search http://support.sas.com/kb/.../kb/&ct=55000?qt=release:%229.21_M2%22+product:%22SAS+OLAP+Server%22+releasesystem:%229.3.9%22&s1=3&la=en&nh=100&ct=5260 support.sas.com Knowledge Base Support Training & Books Store Support Communities Subset Results by: Knowledge Base (11) Support Training & Books Happenings Standard Search Advanced Search Results Filter Find information containing... all these words this exact wording or phrase one or more of these words or or Don't show information containing... any of these words Results per page 10 25 50 100
(עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeOnline20132010Other VersionsLibraryForumsGallery Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: Can't Access OLAP Cubes https://social.technet.microsoft.com/Forums/projectserver/en-US/a91c2b58-0dcc-40e3-b0b6-3b0d21504092/cant-access-olap-cubes-in-excel-with-pwa-2010?forum=projectserver2010general in Excel with PWA 2010 Project , Project Server > Project http://stackoverflow.com/questions/2028837/cant-connect-to-analysis-services-via-excel Server General Questions and Answers Question 0 Sign in to vote I can't access the OLAP cubes either through Excel or by going into the BI Center in PWA. I have followed the TechNet instructions and walked-through the video and as far error a as I can tell everything is set up correctly as I can open the Sample Reports with no problems. I get the following error message when I try to access the OLAP cubes from within Excel: "The following system error occurred: A connection attempt failed because the connected party did not properly respond error a connection after a period of time, or established connection failed because connected host has failed to respond." When I try to open the OLAP cubes from the BI Center in PWA I get the same message as above, but another error message after it: "Errors in the OLE DB provider. An error occurred while loading the connection dialog box component for prompting." I've re-read all of the posts and TechNet articles I can find and the only thing I can think of is user login issues in SQL. I'm running Project Server 2010 and SharePoint Server 2010 on a single server installation. Not sure what other information is useful but I would be than happy to provide more. Thanks in advance for your help! Thursday, January 20, 2011 9:17 PM Reply | Quote Answers 1 Sign in to vote Hi Bryan Also would suggest tocheck if the ports 2383,2382(in case of default instance, else if named instance is bei
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Cant connect to analysis services via excel up vote 5 down vote favorite 1 I have an analysis services cube in SQL server 2005 which I'm connecting to via an excel front end. When I connect via one user its fine, but when I log on to the same machine as another user I get an error in my excel spreadhseet - "user...does not have access to the [Cube name] database" Obviously the first user has the correct permissions, but how do I set up analysis services to allow other users to join the party? sql-server olap business-intelligence ssas share|improve this question asked Jan 8 '10 at 16:04 AJM 12k38120206 add a comment| 4 Answers 4 active oldest votes up vote 3 down vote accepted Login to the machine with an account that is an administrator (Domain\CubeAdmin) on the cube. Connect to the cube in BIDS (run devenv.exe and open Analysis Services Database). Under Roles, create a reader role and in the Membership tab, add the user account (Domain\NewUser). All this will only work if the SSAS Server Administrator gives the Domain\NewUser access to the server. share|improve this answer answered Jan 8 '10 at 16:16 Raj More 29.8k1786155 add a comment| up vote 1 down vote The Windows user accounts that you are trying to access SQL Analysis Services with need to be added to the Roles in the Cube that would allow the permissions you want. If you are connecting over HTTP using msmdpump.dll through IIS you need to turn on Authentication for that site and allow the Windows user account to access the site. If the IIS site using msmdpump is on another machine and you aren't using a domain then the accounts would need to exist on both servers with the same password. share|improve this answer answered Jan 8 '10 at 16:18 duckworth 3,67231732 add a comment| up vote 0 down v