\n
Now, it’s important to note the Juy CTP doesn’t provide the complete configuration and management experience, because after all Katmai is still a work in progress. But enough is there for me to start poking on the parts to see what’s new and different. After installing Katmai on a Windows Server 2003 server, the Reporting Services Windows service is running under the Network Service account. I have not installed IIS (and won\u2019t) but the default installation sets up my report server databases so I should be good to go. No dependency on IIS means I don\u2019t have to set up application pool identities. As an initial test, I try to access Report Manager using the standard URL (localhost\/reports) and see that it displays the Home page so everything is working under the default configuration. So far, so good. Next, I want to peruse the Reporting Services Configuration to see what the current settings are, so I open the configuration tool and connect to the local report server instance. I can immediately see a difference in the configuration tool layout (including the absence of little green or red buttons to indicate whether that page has been configured): I only need to have one service account configured for the Reporting Services service, rather than configure one for its Windows service and another for the Web service. On the Service Account page of the configuration tool, I can change to a different built-in account (which I don\u2019t recommend) or to a domain account (which I do recommend). Although IIS is no longer required, you still need to configure an IP address, TCP port, a URL, a virtual directory, and optionally an SSL certificate to create a URL reservation. A URL reservation is the mechanism by which http.sys \u2013 the operating system API required to run the Web service without IIS \u2013 allows users to access a specific URL. You can configure these settings on the Web Service URL page. An Advanced button on this page displays a dialog box that I can use to configure a variety of IP addresses, ports, host headers, and SSL ports if necessary. (I\u2019ll delve into your options with URL reservations in more detail in a future blog.) When you apply the configuration settings, the applicable URL reservations are created. <\/SPAN>If you\u2019re curious about how http.sys enables applications to run without IIS, see this article from MSDN Magazine<\/a>.<\/SPAN><\/P> The Database page of the configuration tool does what it always did. You can create a new report server database or connect the current report server instance to a different existing report server database or even switch to a different mode (native or SharePoint integrated). The main thing different here is the interface. Configuring the database now is a series of pages in a wizard. I\u2019m not sure whether this is a good thing or not \u2013 no opinion, really \u2013 but for one thing. One you walk through the wizard, there\u2019s no option to save the database script. I hope this is fixed in a future CTP as I have a current client that always has one group build the report server and the database needs to be built on a separate server to which that server-building group doesn\u2019t have permissions needed to execute the script. So we generate the script and hand it off to the DBAs. This omission is pretty big in the product, but as I mentioned earlier, Katmai is a work in a progress. I\u2019ll keep my eye on this one. The next page is the Report Manager URL which you use to set the virtual directory for, well, Report Manager. I\u2019m not sure why this isn\u2019t positioned after the page for the Web Service URL. It doesn\u2019t matter in the grand scheme, but it feels out of place here to me. This page also includes an Advanced button allowing you to set up IP address, ports, host headers, and SSL ports if needed. The Email Settings page hasn\u2019t changed from SQL Server 2005\u2019s configuration tool. All it does is allow you to put in a sender address and set up a SMTP server, so I wouldn\u2019t expect a change here. However, if I could submit a wish, it would be nice to have other configurable settings for SMTP on this page. Currently in SQL Server 2005 \u2013 and it appears this won\u2019t change in Katmai \u2013 you have to change the configuration file for important properties like SendUsing or SMTPAuthenticate (see RSReportServer Configuration file<\/a> for other SMTP-related properties). The Execution Account settings page hasn\u2019t changed either, but I can live with that. There\u2019s nothing I would change. <\/SPAN>J<\/SPAN><\/SPAN> Similarly, the Encryption Keys page hasn\u2019t changed functionally, but the UI has been modified to include test to better explain each option (Backup, Restore, Change, Delete). The Scale-out Deployment page is the new name for SQL Server 2005\u2019s Initialization page and, in my opinion, is a better name for it. I don\u2019t currently have an environment set up to test setting up a report server farm, so I can\u2019t comment on what differences you might find here, but I would not expect much different from the SQL Server 2005 experience. If I find otherwise in the future, I\u2019ll blog about it. Setting the authentication method no longer occurs in IIS, obviously. Now authentication configuration happens only in configuration files which I\u2019ll be exploring in much greater detail in a forthcoming blog (because it\u2019s near and dear to my heart at the moment since I’m speaking on SSRS and authentication configuration next week at SQL Server Magazine Connections<\/SPAN> \u2013 I need to find out what changes in that presentation once Katmai releases!). For now, you should be aware the default configuration of Reporting Services requires users to have a Windows domain account. Authentication is set to Negotiate, much like IIS, which will use Kerberos if it\u2019s enabled or NTLM if Kerberos is not enabled. You can force Kerberos only or NTLM only by changing the report server configuration. Alternatively, you can use Basic authentication (although this feature will come in a future CTP) or Anonymous authentication if you\u2019re adding in custom security like forms authentication. Note that the report server will reject anonymous authentication unless you are explicitly using custom security. Also, Single Sign-On (SSO), Passport, and Digest authentication will not be supported. More to come soon! \u2013Stacia<\/SPAN><\/P><\/p>\n","protected":false},"excerpt":{"rendered":" One of the benefits of SQL Server 2008 Reporting Services is the removal of the dependency on IIS. This architectural change is huge because it opens the door to Reporting Services for those IT shops that wouldn\u2019t allow installations of SQL Server components on a Web server. Plus it removes one more layer of potential […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-465","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/stacia\/wp-json\/wp\/v2\/posts\/465","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/stacia\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/stacia\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/stacia\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/stacia\/wp-json\/wp\/v2\/comments?post=465"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/stacia\/wp-json\/wp\/v2\/posts\/465\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/stacia\/wp-json\/wp\/v2\/media?parent=465"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/stacia\/wp-json\/wp\/v2\/categories?post=465"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/stacia\/wp-json\/wp\/v2\/tags?post=465"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n
\n
\n
\n
\n![](\"https:\/\/www.sqlskills.com\/blogs\/stacia\/content\/binary\/ssrs_config_1.gif\")
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n