Anyone has connected the bi portal with analisys services 2005?
I have a security problem.
Thanks
Are you trying to troubleshoot connectivity to Analysis Services?
Is this HTTP or TCP connection?
See if this troubleshooting guide is going to help you: http://www.sqljunkies.com/WebLog/edwardm/archive/2006/05/26/21447.aspx
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
I had to do this a couple of days ago.
The only way I could get it to work was if I went into the advanced options on the Data Source and specified the full connection string myself, making sure to specify MSOLAP.3 as the provider. When I just chose the options from the standard connection dialog, I could not get it to work, however I was running the BI Portal for a demonstration from a virtual server so their could have been other complicating factors involved.
Note: because BI Portal uses OWC you will need to have the OLEDB provider for AS 2005 installed on all your client machines.
Hope this helps.
|||I did what you said, i connect with the as2005 when i test the connection all work fine, i make the datasource but the webcomponents don't show the pivot table... it gives me an error and show nothing...
i don`t know what i can do... (i have the owc11 installed)
|||
Well, if the datasource tests OK then that is one hurdle we are over.
What is the exact error you are getting?
It may be something to do with the security in IE. As you may know OWC is an ActiveX control that runs on the browser and it needs to have higher than normal security rights. When you are connected to the BI Portal do you see "Trusted Zone" down in the bottom right hand corner? If so you might want to double check the rights for the Trusted zone and make sure that none of the ActiveX related permissions are disabled.
|||
When i am creating the dataosource i get this error:
The object doesn't accept this property or method.
The connection string i get is:
"Provider=MSOLAP.3;Cache Authentication=False;Persist Security Info=False;User ID=administrador;Initial Catalog=OnAlert2;Data Source=w2k3sql2005;Impersonation Level=Impersonate;Location=w2k3sql2005;Mode=ReadWrite;Protection Level=Pkt Privacy;Auto Synch Period=20000;Default Isolation Mode=0;Default MDX Visual Mode=0;MDX Compatibility=0;MDX Unique Name Style=0;Non Empty Threshold=0;SQLQueryMode=Calculated;Safety Options=1;Secured Cell Value=0;SQL Compatibility=0;Compression Level=0;Real Time Olap=False;Packet Size=4096;Initial Catalog=OnAlert2"
I am creating the connection using Analysis Services 9.0.
The pivot table doesn't load the cube i get the error, the pivot table says:
There is no details, the data provider doesn't provide more information.
Then i click in more information: Error = 0x80004005
|||I open excel to test, and i can connect to the cube.. so i don't have connections problems, the problem is with the owc..|||
I'm a bit confused, I thought you said earlier that you created and tested the connection OK, now you say that you are getting an error when you create the data source.
Why don't we try just setting the absolute minimum settings in the connection string and see if we can get a connection created without an error. Try a connection string like the following:
|||Provider=MSOLAP.3;Initial Catalog=OnAlert2;Data Source=w2k3sql2005;
ok, how i set this connection string, now i am clicking in advanced then in create i put the name of the server etc, and it generates the connection string i can't modify it...
|||
Sorry, I don't know. I cannot enter a connection string directly into the advanced box, but if I connect first, or if I click Advanced and then browse and select a .oqy file, I can then edit the connection string.
I have not used BI Portal extensively, maybe you have an issue with your installation.
The main reason I suggested that you try a simpler connection string was the the sample you provided had the Initial Catalog setting listed twice and you had a User Id and no Password set, even though User Id only works with HTTP connections.
You could try creating an OWC page outside of BI Portal just to test the the OWC components are working. The easiest way to do this is to setup a pivot table in Excel and then choose File -> Save As Web Page and click on the add interactivity option.
This will setup a stand alone html page with an embedded pivot table, if it is running from a local drive, it will be running in the My Computer Zone, so it will probably have a different security profile than when you are running from the BI Portal, but it should atleast show us if the OWC components are working.
|||I did what you say, i save the excel as a web page, and the owc give me an error:
"Can't process consult"
"The following system error ocurred: . "
I have the last owc...
|||Those error messages don't really look like anything I have come across before.
If you can connect via Excel, that means your OLEDB provider is installed and working correctly.
If we cannot setup OWC in a simple html page on the local PC (I'm assuming that you save the file to a local drive, files running from network drives may have reduced priviledges) then there is little chance of it working from BI Portal.
Are you using at least IE 5?
In Internet Explorer, under Tools - Internet Options, there is an Advanced tab and under the security section there is a setting for "Enable Intergrated Windows Authentication" - Is this option ticked?
|||I don't know what to do... perhaps i have to enable the http access?
The owc connect to the as2005 via http?
I really don't understand what is happening, i can connect with the cube via excel but when i am using the owc i have errors....
|||I have Internet explorer 6, i have the option you say enable...|||
I don't think http access will change much.
The fact that Excel works, proves that
You can authenticate to the AS server using your Windows credentials
No comments:
Post a Comment