Guest_imported
New member
- Jan 1, 1970
- 0
SQL Server Ver. 7.0
We have problems to publish an HTML page with a Pivot Table Active X for the cube analysis in an IIS Server, the main problem is in fact the user autentication in OLAP SERVICES, in the cube's roles I includes the user IUSR_SERVER granted with read privilegies.
If the cube is browsed with an HTML plain cell-set with only two dimentions the information can be published, but if we try to use a pivot table the element fails and send the security access message: "0x80004005: Cannot connect to server..."
In a Microsoft documentation i found that Pivot Tables connects to SQL Server 7.0 OLAP Services using ports 2393 and 2494, however both ports are opened in IIS server
We have problems to publish an HTML page with a Pivot Table Active X for the cube analysis in an IIS Server, the main problem is in fact the user autentication in OLAP SERVICES, in the cube's roles I includes the user IUSR_SERVER granted with read privilegies.
If the cube is browsed with an HTML plain cell-set with only two dimentions the information can be published, but if we try to use a pivot table the element fails and send the security access message: "0x80004005: Cannot connect to server..."
In a Microsoft documentation i found that Pivot Tables connects to SQL Server 7.0 OLAP Services using ports 2393 and 2494, however both ports are opened in IIS server