January 24, 2013 at 3:39 pm
Is there any way to host the Report manager on an IIS Server and the database for SSRS on a database server ? Any insight / direction would be helpful ?
January 24, 2013 at 3:43 pm
It would be considered a scale out deployment. You can see the setup recommendations/instructions here
http://technet.microsoft.com/en-us/library/ms156453(v=sql.105).aspx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 24, 2013 at 4:06 pm
SQLRNNR (1/24/2013)
It would be considered a scale out deployment. You can see the setup recommendations/instructions herehttp://technet.microsoft.com/en-us/library/ms156453(v=sql.105).aspx
Thanks for the info, and i would need Enterprise Edition vs. Standard Edition in order to be able to do this ?
January 24, 2013 at 4:12 pm
No need for scale out here as far as I can see.
Just install SQL database engine but not SSRS on the first machine, and SSRS on the other. The RS databases can be on a different server to the Report Manager.
Note both servers will need to be licensed for SQL Server though.
January 24, 2013 at 4:19 pm
Gazareth (1/24/2013)
No need for scale out here as far as I can see.Just install SQL database engine but not SSRS on the first machine, and SSRS on the other. The RS databases can be on a different server to the Report Manager.
Note both servers will need to be licensed for SQL Server though.
After following this document...
http://msdn.microsoft.com/en-us/library/ms159272.aspx
I have a report server that held both the iis and report database responsibilities (Server A), and have started working to split the responsibility off to an IIS server (Server B) so i installed SSRS on the *B and tried to set the databases on the report server config on *B to the report database on *A and it showed up as a "scale out deployment" on *A
January 24, 2013 at 4:27 pm
If you've got 2 or more Report Manager instances pointing at the same RS databases, yes that's scale out. Wasn't sure if you already had RS installed or not on the DB server.
January 24, 2013 at 4:29 pm
Gazareth (1/24/2013)
If you've got 2 or more Report Manager instances pointing at the same RS databases, yes that's scale out. Wasn't sure if you already had RS installed or not on the DB server.
The IIS server doesnt need the SSRS. I just want it to host the Report manager for the other server. How would i make that connection without installing SSRS on IIS ? Thanks
January 24, 2013 at 4:40 pm
cjbaum (1/24/2013)
Gazareth (1/24/2013)
If you've got 2 or more Report Manager instances pointing at the same RS databases, yes that's scale out. Wasn't sure if you already had RS installed or not on the DB server.The IIS server doesnt need the SSRS. I just want it to host the Report manager for the other server. How would i make that connection without installing SSRS on IIS ? Thanks
Alright i got it working i had to update my encryption keys on the IIS server report configuration and remove the "report database" server from the scale out on the IIS machine.
January 24, 2013 at 4:44 pm
Sorry if my terminology isn't clear - when I say SSRS I mean Report Manager 🙂
They're the same to my mind.
It needs databases to store info, but they can go on a SQL instance on another machine if you want them to.
January 25, 2013 at 8:02 pm
Alright so i thought i had it working, i blew up the report manager page yesterday and had to reinstall today. Now when i connect the database to the report config on the iis server i restore the encrypt key then remove the database server from the scale out, the page comes up but i get this error when i access it via http://localserver/reports.
User 'DOMAIN\user' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.
I have a whole 'nother set of issues trying to get report manager to work with iis, but ill save that for another thread
January 26, 2013 at 4:20 am
Open your browser as administrator - should allow you in & then you can set up relevant security (Site Settings if I recall correctly).
January 28, 2013 at 1:46 pm
Gazareth (1/26/2013)
Open your browser as administrator - should allow you in & then you can set up relevant security (Site Settings if I recall correctly).
Oh no, ive already tried all that. Still no luck
January 30, 2013 at 6:46 pm
So i have a sound working copy if i access it via http://+:80/Reports, which is the setup under Report Configuration
I get a completely blank page if i access it via "subdomain.domain.com" which i setup in IIS to direct to the ReportManager folder under SQL on the C:\ drive
Any new ideas ?
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply