Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Reporting Services Part I: Overview, Architecture and Installation Expand / Collapse
Author
Message
Posted Sunday, February 29, 2004 6:58 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 6, 2011 8:20 PM
Points: 227, Visits: 33
Comments posted to this topic are about the content posted at http://www.sqlser


Post #103196
Posted Wednesday, March 3, 2004 9:49 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, July 31, 2007 8:20 AM
Points: 885, 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"
Post #104146
Posted Wednesday, March 3, 2004 11:51 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 6, 2011 8:20 PM
Points: 227, 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




Post #104150
Posted Thursday, March 4, 2004 4:54 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, November 8, 2005 4:20 AM
Points: 40, 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?

 

 




Post #104214
Posted Thursday, March 4, 2004 6:21 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, August 20, 2013 5:39 PM
Points: 207, Visits: 197

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.

 




Post #104243
Posted Thursday, March 4, 2004 11:06 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 3:39 PM
Points: 64, Visits: 472

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.




Post #104385
Posted Thursday, March 11, 2004 10:56 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 6, 2011 8:20 PM
Points: 227, 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.


Post #105613
Posted Thursday, April 1, 2004 7:39 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, June 1, 2012 2:33 AM
Points: 312, 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
Post #109460
Posted Thursday, April 1, 2004 10:30 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 6, 2011 8:20 PM
Points: 227, 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.

 




Post #109515
Posted Wednesday, July 21, 2004 4:52 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 21, 2004 4:27 AM
Points: 1, 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

 

 

 

 




Post #127386
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse