Hi Rodolfo - we haven't got so far yet as to implement the SSL over our
SQL 2005 RS connection to BW with the new SQL SP1 .NET Netweaver
provider - have been grappling all week with what appear to be
intermittent 'disconnects' to BW web service on reports that contain 3
or 4 subreports of BW queries / grids.
Have trawled the logs, analysed the network traffic and cannot yet
understand why we seem to be reaching some limit during report
processing that results in AdomdConnection errors in our RS log file.
When it works it's great - but then up it pops under a bit of load and
the frustration begins!!
Even applied the latest MS SQL hotfix last night but appears the
problem remains.
Sorry to not be able to address your issue but I'm very interested to
know if you can pull data from SAP BW into RS every time without these
kind of issues ? If we can get past this then it's on to the SSL and
production - right now I'm feeling like we are too close to the
'bleeding edge' - how you finding it?
Thanks mate
Phil
[quoted text, click to view] Rodolfo Roim wrote:
> Hi Everybody
>
> We're trying to connect Reporting Services with SAP/BW using SAP NetWeaver but we've been having some problems.
>
> One of the problem we're facing is regarding with HTTPS connection string. We can't connect using a SSL protocol. Using HTTP protocol, we have no problems to connect to SAP, only with SSL.
>
> After we connect to SAP with HTTP address, we can't use SAP cubes. These problems might be happening because we DON'T have Support Package 16 installed in SAP server.
>
> I'd like to know if there's another way to connect to SAP/BW to use their CUBES in Report Builder.
>
>
> Thanks a lot
> Rodolfo
>
> ------=_NextPart_000_000B_01C6C6D3.ADC425B0
> Content-Type: text/html; charset=iso-8859-1
> Content-Transfer-Encoding: quoted-printable
> X-Google-AttachSize: 1575
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD>
> <META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
> <META content="MSHTML 6.00.2900.2963" name=GENERATOR>
> <STYLE></STYLE>
> </HEAD>
> <BODY>
> <DIV><FONT face=Verdana size=2>Hi Everybody</FONT></DIV>
> <DIV><FONT face=Verdana size=2></FONT> </DIV>
> <DIV><FONT face=Verdana size=2>We're trying to connect Reporting Services with
> SAP/BW using SAP NetWeaver but we've been having some problems.</FONT></DIV>
> <DIV><FONT face=Verdana size=2></FONT> </DIV>
> <DIV><FONT face=Verdana size=2>One of the problem we're facing is regarding with
> HTTPS connection string. We can't connect using a SSL protocol. Using HTTP
> protocol, we have no problems to connect to SAP, only with SSL.</FONT></DIV>
> <DIV><FONT face=Verdana size=2></FONT> </DIV>
> <DIV><FONT face=Verdana size=2>After we connect to SAP with HTTP address, we
> can't use SAP cubes. These problems might be happening because we DON'T have
> Support Package 16 installed in SAP server.</FONT></DIV>
> <DIV><FONT face=Verdana size=2></FONT> </DIV>
> <DIV><FONT face=Verdana size=2>I'd like to know if there's another way to
> connect to SAP/BW to use their CUBES in Report Builder.</FONT></DIV>
> <DIV><FONT face=Verdana size=2> </FONT></DIV>
> <DIV><FONT face=Verdana size=2></FONT> </DIV>
> <DIV><FONT face=Verdana size=2>Thanks a lot</FONT></DIV>
> <DIV><FONT face=Verdana size=2>Rodolfo <BR></FONT></DIV></BODY></HTML>
>
> ------=_NextPart_000_000B_01C6C6D3.ADC425B0--