Report Builder and Forms Authenticaton in SQL Server Reporting Services 2005

I’ve had a fair number of questions from my customers around the use of Forms Authentication in conjunction with Report Builder. The basic thing people want to know is “does it work?”. As a matter of fact, it does. It functions the same way as with Windows Auth except for one behavior: Basically, there is no way…

45

SQL Express and SQL Reporting Services 2005 – Soon, but not yet

2005 Books Online and/or microsoft.com readers know that you can use SQL Express and SSRS together (with a few caveats – hit http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx to view them). However, you’re going to have to wait a little while longer before you actually can start putting SSRS and SQLExpress together. Mike Wachal (a SQLExpress PM) and Brad Syputa…

0

Browsing Reporting Services 2005 Reports without IE for Windows

In 2005, there is limited report browsing support for non IE 6 SP1 browsers (IE 6 SP1 with scripting enabled, that is) This info will be fully documented at some point in the future, but in the meantime here are some general nuggets (BTW, none of this info is official and could change at any…

0

Impersonating another user with the Web Form Report Viewer control and SQL Server Reporting Services 2005

I covered how to do impersonation with the Winform ReportViewer control a few weeks ago, so here’s how to do it with the WebForm version. The first thing to keep in mind is that by default the WebForm ReportViewer will run under the security context of your application’s AppPool identity. So, depending on the identity of…

45

New Reporting Add-In for Microsoft Visual Web Developer 2005 Express

This one is flying under the radar — Thought I’d publicize it a bit:   http://www.microsoft.com/downloads/details.aspx?FamilyID=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en [Scroll to the very bottom]   “The Reporting Add-In for Microsoft Visual Web Developer 2005 Express includes a ReportViewer control, an integrated report designer, and a comprehensive API that lets you customize run-time functionality. You can use the control…

4

SQL Server 2005 Report Builder and Basic Authorization

I have a customer who needs to use Basic Auth with SQL Reporting Services 2005, so I wanted to make sure they could get at Report Builder too. WARNING: Don’t EVER do this unless you are using SSL with Reporting Services! If you turn Basic Authentication on for the /ReportServer and /Reports vdirs, then turn…

36

Using Forms Authentication with the Report Viewer control and SQL Server Reporting Services 2005

I’ve been playing around with using different forms of authentication / impersonation with the Report Viewer controls, and I thought I’d post the fruits of my efforts. Here we go: Using Forms Authentication with the Winform Report Viewer control is easy — Just pass in the creds and you’re all done: reportViewer1.ServerReport.ReportServerCredentials.SetFormsCredentials(null, “userName”, “password”, “domainName”);this.reportViewer1.RefreshReport();…

39