Forum Discussion

Steffen_Beach_8's avatar
Steffen_Beach_8
Icon for Nimbostratus rankNimbostratus
Oct 27, 2010

SQL 2008 Reporting Services

Hey all!

 

 

Background:

 

I'm trying to setup what I thought would be a typical http load balancing pool with two pool members. We recently upgraded our SQL reporting services from 2005 (uses IIS) to 2008 (doesn't use IIS). The reporting site uses port 80 like any other M$ site with Windows Authentication.

 

 

Problem:

 

Created 2 nodes (node_reports11, node_reports12)

 

Created a pool (pool_reports_http)

 

Added the 2 nodes as pool members; :80

 

Created virtual server (using SNAT auto map, TCP profile); :80 with port translation for good measure.

 

No monitor at this time...

 

 

Test url directly to server (happily named reports11)

 

 

 

config
design
  • hooleylist's avatar
    hooleylist
    Icon for Cirrostratus rankCirrostratus
    Oct 27, 2010
    Hi Steffen,

     

     

    Your post got a bit munged. You can use [ code ] [/ code ] blocks to preserve the content (without the spaces).

     

     

    What happened when you made a browser request to the virtual server?

     

     

    When you test with curl, you can specify the --ntlm flag to enable NTLM authentication. See 'man curl' for details.

     

     

    Are you able to ping from the LTM command line to the pool members? Can you open a TCP connection with netcat (nc 1.1.1.1 80) to the servers from LTM?

     

     

    Aaron
  • Steffen_Beach_8's avatar
    Steffen_Beach_8
    Icon for Nimbostratus rankNimbostratus
    Dec 10, 2010
    Aaron,

     

     

    Sorry for the extremely late response... I was looking out for a post update notification in my email, but I don't recall ever seeing anything. Well, I popped on today to post another question and saw that you had replied. Once again, sorry to leave you hanging like that; it was totally unintentional.

     

     

    --Steffen

     

  • hooleylist's avatar
    hooleylist
    Icon for Cirrostratus rankCirrostratus
    Jan 12, 2012
    Hi Steffen,

     

     

    Another post has a question on monitoring SSRS. Did you figure something out for this? If so, can you post your solution here or in this post?

     

     

    http://devcentral.f5.com/Community/GroupDetails/tabid/1082223/asg/62/aft/2159191/showtab/groupforums/Default.aspx

     

     

    Thanks, Aaron