| Author |
 Topic  |
|
|
fgiusti
7 Posts |
 Posted - 01/03/2007 : 03:33:14
|
My configuration:
SQL Server 2005 (Server 1)
web serveur-ReportPortal (Server 2).
Server WEB 2 is public, Server 1 is private.
My problem is to succeed to create OLAP Report through Server 2 from a public address… I do not succeed to us… you can help me? Thanks. |
|
|
marco
Netherlands
588 Posts |
Posted - 01/04/2007 : 08:49:28
|
Hi,
Can you connect from ReportPortal (Public) to the OLAP server (Privat) or are you not able to connect to the ReportPortal from teh internet ?
Internet URL for OLAP for Internet based on Statistics from city of Rotterdam in The Netherlands with use of ReportPortal:
http://213.160.249.87/reportportal/login.aspx
Best regards,
Marco Groeneveld
www.gmsbv.nl
|
 |
|
|
fgiusti
7 Posts |
Posted - 01/04/2007 : 08:55:59
|
I do not succeed through Public ReportPortal, to approach OLAP private Server… How I can make? Thanks…
INTERNET --->> SERVER PUBLIC REPORTPORTAL ---->> MY LAN (OLAP PRIVATE)
Thanks… |
|
|
|
marco
Netherlands
588 Posts |
Posted - 01/04/2007 : 10:56:31
|
Hi,
Please visit:
http://www.sqljunkies.com/WebLog/edwardm/
Here you will find documentation regarding XMLA / firewalls etc.
In any way you should add the XMLA on the privat server and in ReportPortal add a connection to the server and make an OLAP report based on the new connection.
Marco |
|
|
|
fgiusti
7 Posts |
|
|
fgiusti
7 Posts |
Posted - 01/08/2007 : 07:57:59
|
| my problem is to shape IIS that heads for the Private Server… does NOT succeed… Thanks. |
|
|
|
rbarrientos
El Salvador
29 Posts |
Posted - 01/08/2007 : 11:37:09
|
Firts: Your server (olap and web) must be into the same domain; or it must to have relationship trust.
A server must trust another one.
You Database server must be seen only through the local connection from IIS.
The Server Name in msmdpump.ini must be
<ServerName>Server 1</ServerName>
Informar significa descubrir necesidades y crear oportunidades para El Salvador |
|
|
|
fgiusti
7 Posts |
Posted - 01/09/2007 : 07:10:22
|
OK...
1) Your server (olap and web) must be into the same domain;
2) <ServerName>Server 1</ServerName>
es. <ServerName>SRVERSQL2005</ServerName>
ok???
Thanks. |
|
|
|
admin
1644 Posts |
Posted - 01/14/2007 : 19:23:16
|
Can you connect to your Analysis Services database using a UDL?
On your web server:
Start > Programs > Report Portal Application Setup > XMLA for Analysis Setup > Create UDL.
|
|
|
|
fgiusti
7 Posts |
Posted - 01/16/2007 : 01:53:47
|
Created UDL, I see the CUBE, but on report portal I do not know like using it… If I put the Server, in the same DOMAIN it works. My question, works nache on DOMAIN amuses, Server1 (DOMAIN A), Server2 (Standalone)??
Thank.... |
|
|
|
admin
1644 Posts |
Posted - 01/17/2007 : 10:30:04
|
| Both servers have to belong to the same domain or workgroup. |
|
|
|
fgiusti
7 Posts |
Posted - 01/18/2007 : 03:37:59
|
| Thank.... |
|
|
| |
Topic |
|
Report Portal
Help Configuration Web Server Pubblic and SQL2005
