SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Reporting Services Part I: Overview, Architecture and Installation


Reporting Services Part I: Overview, Architecture and Installation

Author
Message
James Luetkehoelter
James Luetkehoelter
Mr or Mrs. 500
Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)

Group: General Forum Members
Points: 579 Visits: 33
Comments posted to this topic are about the content posted at http://www.sqlser



ckempste
ckempste
SSCarpal Tunnel
SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)

Group: General Forum Members
Points: 4775 Visits: 1

Hi there

Great overview.

Some items to add to the list that I have come accross:

a) SQL Authentication for report server db - on install, it will attempt to connect to the database via the windows account you have logged onto the server with, it uses this to verify if the DB exists and the user account is setup (and do the build if not there). This is typically via builtin\administrators group. Be aware of this if you get the classic windows login error re trusted connections.

b) Anonymous ReportServer report access - as a simple approach, I replicated the /reportserver virtual directory (must copy the properties identically) and enabled anonymous logins - both virtual dirs point to the same binaries of course. I created a /private and /public root folders within reportserver and the anonymous account having /public access only. Be carefully playing with your primary /reportserver virtual dir in relation to /reports (reportmanger), especially IIS security settings and domain/realm properties.

c) Web farms - I had a senario where I wanted two webservers sharing the same reporting services repository but they are NOT in a webfarm. On install to the second server, it "assumes" you do want a webfarm, and are asked for the details. To get around this, I let it create a new reportserver repository, then used rsconfig to point back to the shared repository thereafter.

d) SQL client net utility alias - when asked for the sql server to connect to, I recommend you use sql client net utility and create an alias instread to quickly point RS to another repository (as need be of course)

Cheers

Ck




Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
James Luetkehoelter
James Luetkehoelter
Mr or Mrs. 500
Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)

Group: General Forum Members
Points: 579 Visits: 33

Thanks for the feedback Chris!

I agree with the login stuff -- it's very confusing when presented on install -- what's logging on to what? I'd like to so MS clean the install up a bit on the next version. It's a deceptively complicated architecture -- I hope I brought that out a bit in this first article.

The web farm stuff is very misleading. I've got more on that coming. I wanted to approach this from a crawl-before-limp-before-walk-before-run kind of thing





Toby Waldock
Toby Waldock
SSC Rookie
SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)

Group: General Forum Members
Points: 42 Visits: 1

Thanks for your part 1 article. I wish it had been published 4 weeks ago as it took me several hours to get to the stage of being ready to try out the Report Designer (using a real database of ours in a dev VM)! I think I really need to see Part2 - when is it due to be published?





LeeFAR
LeeFAR
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1763 Visits: 342

Well done James. I glad to see someone has taken the time to do this. We just installed SSRS into our test lab this week. I have played with it on and off and I really like this product. I do have a concern though. The first one is printing. I have already posted my concerns in the Reporting Services discussion forum. Check it out.

I also believe another discussion I have seen is configuration management. What are the best practices for SSRS.

Keep up the good work. I nice to have tons if info to go by, especially for a new product.





JohnMarks
JohnMarks
Old Hand
Old Hand (371 reputation)Old Hand (371 reputation)Old Hand (371 reputation)Old Hand (371 reputation)Old Hand (371 reputation)Old Hand (371 reputation)Old Hand (371 reputation)Old Hand (371 reputation)

Group: General Forum Members
Points: 371 Visits: 569

My initial impressions of this addition to the SQL Server family are very positive. This was a great introduction article and like some others have said it would have been very useful for me to have prior to installing RS :-) I look forward to more articles on the subject.

One very big drawback for my company and our use of RS is the lack of a calendar control or date picker for use when supplying parameters to reports. MS said that this type of control might be included in the next release of the product. I am keeping my fingers crossed.

Does anyone have any good suggestion in terms of allowing end users to supply dates as parameters to reports? Right now we use a couple of drop down boxes that they can select dates from but this is not as easy to use as a calendar control.





James Luetkehoelter
James Luetkehoelter
Mr or Mrs. 500
Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)

Group: General Forum Members
Points: 579 Visits: 33
Thanks for the feedback everyone. I have two articles coming soon on deport development, with more to follow. As with this one, it won't simply follow the training or the BOL, but hit upon some of the more crucial and "what the..." elements.



jvElecenter
jvElecenter
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1620 Visits: 179

Hi great article indeed

But i'm still fighting against that last error.

I've deleted all files I guess d:\program files\sql\reporting services and their responding databases. But I still receive the error by the end of the install.

I just can't wait to get it fixed becoz i just think it's a great product and just the one i need.

Kind regards

Jeff




JV
James Luetkehoelter
James Luetkehoelter
Mr or Mrs. 500
Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)Mr or Mrs. 500 (579 reputation)

Group: General Forum Members
Points: 579 Visits: 33

Grrr! Don't you just hate that error? And then you have to wait for EVERYTHING (almost) to roll back.

The service (on my test box at least) is referenced at "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\bin\ReportingServicesService.exe". THe file version for the exe is 8.0.743.0, the Assembly Version is 8.0.242.0.

A couple things to try. First, I'd try reinstalling the beta, uninstalling it, deleting that silly directory, the databases and the virtual directories in IIS, and THEN reinstalling the developer edition.

You may want to try removing the service altogether from the registry (I would advise not). Or try to use the .NET Configuration Assistant in Administrative tools to repair the ReportingServices exe. Again, make sure these last two are tried on test box -- there could be unpredictable results.

I haven't tracked down exactly what causes this, so if anyone else has, please add.





balcon
balcon
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 1

Hi,

The article is very helpbut but but I am getting an error during the install of evaluation version of Reporting services on win 2000 server.

It goes thru the setup and towards the end i get an erorr "WMI Registration error -2147023836"

Any ideas..

Thanks

GB





Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search