{"id":719,"date":"2008-10-12T22:10:31","date_gmt":"2008-10-13T03:10:31","guid":{"rendered":"http:\/\/blogs.devhorizon.com\/reza\/?p=719"},"modified":"2008-10-16T23:24:10","modified_gmt":"2008-10-17T04:24:10","slug":"ssrs-2008-integrated-mode-on-an-existing-web-apps","status":"publish","type":"post","link":"https:\/\/blogs.devhorizon.com\/reza\/2008\/10\/12\/ssrs-2008-integrated-mode-on-an-existing-web-apps\/","title":{"rendered":"SSRS 2008 Integrated Mode on Existing Apps"},"content":{"rendered":"<p>As you can see , I&#8217;ve started to gradually blog my notes that I have gathered so far with regards to installing SSRS 2008 in an integrated mode with MOSS 2007 , also including the solutions and workarounds if possible. Here is a tricky one:<\/p>\n<p><strong>Before<\/strong> we performed the integration , we had provisioned a SharePoint Web application and extended it to an internet zone. We used domain user account for the application pool of this Web application ;therefore for its extended Web application. Default zone was configured to use Windows Authentication and extended zone with our custom auth provider.<\/p>\n<p><a href=\"https:\/\/blogs.devhorizon.com\/reza\/wp-content\/uploads\/2008\/10\/applicationpoolundercustomaccount.png\" title=\"applicationpoolundercustomaccount.png\"><img decoding=\"async\" src=\"https:\/\/blogs.devhorizon.com\/reza\/wp-content\/uploads\/2008\/10\/applicationpoolundercustomaccount.png\" alt=\"applicationpoolundercustomaccount.png\" \/><\/a><\/p>\n<p align=\"left\"><strong>** Snapshots are from an environment I used to replicate the issue** <\/strong><\/p>\n<p>We went ahead and performed the exact configuration steps on both report server and SharePoint WFE server. We also used domain user accounts for services accounts\u00a0 all the way through as recommended <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/bb326356.aspx\">here<\/a> and verified that integration is in a healthy state. I documented part of our verification tests <a href=\"https:\/\/blogs.devhorizon.com\/reza\/?p=718\">here<\/a>.\u00a0 In the <strong>Reporting Services Integration<\/strong> tab in the Central Administration site We specified <strong>Windows Authentication<\/strong>.<\/p>\n<p><!--more--><\/p>\n<p>We created a Data Connection Library\u00a0 and Report Library and deployed all of our data sources and rdl files.Our datsources were using <strong>Windows Authentication (Integrated Security)<\/strong> too.<\/p>\n<p>Clicking on any of the deployed reports resulted in the following nasty error message thrown in the report viewer Web part:<\/p>\n<p><em>&#8220;An error occurred during client rendering. The remote server returned an error: (500) Internal Server Error&#8221;<\/em><\/p>\n<p><a href=\"https:\/\/blogs.devhorizon.com\/reza\/wp-content\/uploads\/2008\/10\/internalservice500.png\" title=\"internalservice500.png\"><img decoding=\"async\" src=\"https:\/\/blogs.devhorizon.com\/reza\/wp-content\/uploads\/2008\/10\/internalservice500.png\" alt=\"internalservice500.png\" \/><\/a><\/p>\n<p><strong>** Snapshots are from an environment I used to replicate the issue** <\/strong><\/p>\n<p>Event Viewer showed nothing , but on *one* of the installations we noticed the the following entry in the ULS logs. Basically we went through the same configuration steps on two different farms , but we discovered the following exception in one of the farms only, the other one was throwing the same error message as shown in the picture above , but nothing was logged in the ULS log.<\/p>\n<blockquote><p>10\/12\/2008 19:24:47.93<br \/>\nReportingServicesService.exe (0x0F98)<br \/>\n0x0A84<br \/>\nWindows SharePoint Services<br \/>\nDatabase<br \/>\n6f8g<br \/>\nUnexpected<br \/>\nUnexpected query execution failure, error code 282. Additional error information from SQL Server is included below.<br \/>\n&#8220;The &#8216;proc_GetTpWebMetaDataAndListMetaData&#8217; procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead.&#8221; Query text (if available): &#8220;{?=call proc_GetTpWebMetaDataAndListMetaData(?,&#8217;4A27185A-3FEF-4BF5-9C71-C009FF8D1944&#8242;,?,NULL,1,?,?,6187)}&#8221;<\/p><\/blockquote>\n<p>Basically tried everything , but the sucker didn&#8217;t want to get solved! In one of the testing servers , I deleted the Web application and provision a new Web Application and reports were happy. On the actual server\u00a0 on the other hand, we couldn&#8217;t delete the existing Web application , so I had to go for backup and restore kind of approach!<\/p>\n<p>This tells me that Integration doesn&#8217;t apply the required configuration steps (most likely permission settings) for the existing Web applications. I am still following up on this with two of my contacts inside MS to see if I can find an answer, but until then I guess the best shot is to recreate the Web applications that were there before the integration happened!<\/p>\n<p><font color=\"#ff0000\"><strong>Update <\/strong><font color=\"#000000\">(October\/16\/2008<\/font><\/font><font color=\"#000000\">)<\/font>: Jimmy has kindly sent me an email and said that he gets the same error when he enables anonymous access on the Web application using NTLM with SSRS authentication mode set to Windows Authentication. When he disabled anonymous access ,eveything works just fine. He also can&#8217;t find anything in the event viewer or ULS logs. Apparently when he switched the SSRS authentication mode to the Trusted Account he got the following error message and that&#8217;s how he found out that disabling anonymous access is the way to go:<\/p>\n<p><em>&#8220;Reporting Services does not support anonymous user from a SharePoint site&#8221;<\/em><\/p>\n<p><a href=\"https:\/\/blogs.devhorizon.com\/reza\/wp-content\/uploads\/2008\/10\/anonymous.png\"><img decoding=\"async\" src=\"https:\/\/blogs.devhorizon.com\/reza\/wp-content\/uploads\/2008\/10\/anonymous.png\" alt=\"anonymous.png\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>As you can see , I&#8217;ve started to gradually blog my notes that I have gathered so far with regards to installing SSRS 2008 in an integrated mode with MOSS 2007 , also including the solutions and workarounds if possible. Here is a tricky one: Before we performed the integration , we had provisioned a [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[43,47],"tags":[],"class_list":["post-719","post","type-post","status-publish","format-standard","hentry","category-moss-2007","category-ssrs"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SSRS 2008 Integrated Mode on Existing Apps - Reza Alirezaei&#039;s Blog %<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/blogs.devhorizon.com\/reza\/2008\/10\/12\/ssrs-2008-integrated-mode-on-an-existing-web-apps\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Reza Alirezaei\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2008\\\/10\\\/12\\\/ssrs-2008-integrated-mode-on-an-existing-web-apps\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2008\\\/10\\\/12\\\/ssrs-2008-integrated-mode-on-an-existing-web-apps\\\/\"},\"author\":{\"name\":\"Reza Alirezaei\",\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/#\\\/schema\\\/person\\\/cdbb24d283697a65951cb4a14e474938\"},\"headline\":\"SSRS 2008 Integrated Mode on Existing Apps\",\"datePublished\":\"2008-10-13T03:10:31+00:00\",\"dateModified\":\"2008-10-17T04:24:10+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2008\\\/10\\\/12\\\/ssrs-2008-integrated-mode-on-an-existing-web-apps\\\/\"},\"wordCount\":615,\"commentCount\":3,\"image\":{\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2008\\\/10\\\/12\\\/ssrs-2008-integrated-mode-on-an-existing-web-apps\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/wp-content\\\/uploads\\\/2008\\\/10\\\/applicationpoolundercustomaccount.png\",\"articleSection\":[\"MOSS 2007\",\"SSRS\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2008\\\/10\\\/12\\\/ssrs-2008-integrated-mode-on-an-existing-web-apps\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2008\\\/10\\\/12\\\/ssrs-2008-integrated-mode-on-an-existing-web-apps\\\/\",\"url\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2008\\\/10\\\/12\\\/ssrs-2008-integrated-mode-on-an-existing-web-apps\\\/\",\"name\":\"SSRS 2008 Integrated Mode on Existing Apps - Reza Alirezaei's Blog %\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2008\\\/10\\\/12\\\/ssrs-2008-integrated-mode-on-an-existing-web-apps\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2008\\\/10\\\/12\\\/ssrs-2008-integrated-mode-on-an-existing-web-apps\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/wp-content\\\/uploads\\\/2008\\\/10\\\/applicationpoolundercustomaccount.png\",\"datePublished\":\"2008-10-13T03:10:31+00:00\",\"dateModified\":\"2008-10-17T04:24:10+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/#\\\/schema\\\/person\\\/cdbb24d283697a65951cb4a14e474938\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2008\\\/10\\\/12\\\/ssrs-2008-integrated-mode-on-an-existing-web-apps\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2008\\\/10\\\/12\\\/ssrs-2008-integrated-mode-on-an-existing-web-apps\\\/#primaryimage\",\"url\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/wp-content\\\/uploads\\\/2008\\\/10\\\/applicationpoolundercustomaccount.png\",\"contentUrl\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/wp-content\\\/uploads\\\/2008\\\/10\\\/applicationpoolundercustomaccount.png\",\"width\":632,\"height\":246},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/#website\",\"url\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/\",\"name\":\"Reza Alirezaei's Blog\",\"description\":\"Blogging from the field!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/#\\\/schema\\\/person\\\/cdbb24d283697a65951cb4a14e474938\",\"name\":\"Reza Alirezaei\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3ba940d84e0ecb909e62e93df4c56daf0395c7e53c914467ab2ee73124a7d7b6?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3ba940d84e0ecb909e62e93df4c56daf0395c7e53c914467ab2ee73124a7d7b6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3ba940d84e0ecb909e62e93df4c56daf0395c7e53c914467ab2ee73124a7d7b6?s=96&d=mm&r=g\",\"caption\":\"Reza Alirezaei\"},\"url\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/author\\\/rezaa\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SSRS 2008 Integrated Mode on Existing Apps - Reza Alirezaei's Blog %","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/blogs.devhorizon.com\/reza\/2008\/10\/12\/ssrs-2008-integrated-mode-on-an-existing-web-apps\/","twitter_misc":{"Written by":"Reza Alirezaei","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blogs.devhorizon.com\/reza\/2008\/10\/12\/ssrs-2008-integrated-mode-on-an-existing-web-apps\/#article","isPartOf":{"@id":"https:\/\/blogs.devhorizon.com\/reza\/2008\/10\/12\/ssrs-2008-integrated-mode-on-an-existing-web-apps\/"},"author":{"name":"Reza Alirezaei","@id":"https:\/\/blogs.devhorizon.com\/reza\/#\/schema\/person\/cdbb24d283697a65951cb4a14e474938"},"headline":"SSRS 2008 Integrated Mode on Existing Apps","datePublished":"2008-10-13T03:10:31+00:00","dateModified":"2008-10-17T04:24:10+00:00","mainEntityOfPage":{"@id":"https:\/\/blogs.devhorizon.com\/reza\/2008\/10\/12\/ssrs-2008-integrated-mode-on-an-existing-web-apps\/"},"wordCount":615,"commentCount":3,"image":{"@id":"https:\/\/blogs.devhorizon.com\/reza\/2008\/10\/12\/ssrs-2008-integrated-mode-on-an-existing-web-apps\/#primaryimage"},"thumbnailUrl":"https:\/\/blogs.devhorizon.com\/reza\/wp-content\/uploads\/2008\/10\/applicationpoolundercustomaccount.png","articleSection":["MOSS 2007","SSRS"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/blogs.devhorizon.com\/reza\/2008\/10\/12\/ssrs-2008-integrated-mode-on-an-existing-web-apps\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/blogs.devhorizon.com\/reza\/2008\/10\/12\/ssrs-2008-integrated-mode-on-an-existing-web-apps\/","url":"https:\/\/blogs.devhorizon.com\/reza\/2008\/10\/12\/ssrs-2008-integrated-mode-on-an-existing-web-apps\/","name":"SSRS 2008 Integrated Mode on Existing Apps - Reza Alirezaei's Blog %","isPartOf":{"@id":"https:\/\/blogs.devhorizon.com\/reza\/#website"},"primaryImageOfPage":{"@id":"https:\/\/blogs.devhorizon.com\/reza\/2008\/10\/12\/ssrs-2008-integrated-mode-on-an-existing-web-apps\/#primaryimage"},"image":{"@id":"https:\/\/blogs.devhorizon.com\/reza\/2008\/10\/12\/ssrs-2008-integrated-mode-on-an-existing-web-apps\/#primaryimage"},"thumbnailUrl":"https:\/\/blogs.devhorizon.com\/reza\/wp-content\/uploads\/2008\/10\/applicationpoolundercustomaccount.png","datePublished":"2008-10-13T03:10:31+00:00","dateModified":"2008-10-17T04:24:10+00:00","author":{"@id":"https:\/\/blogs.devhorizon.com\/reza\/#\/schema\/person\/cdbb24d283697a65951cb4a14e474938"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blogs.devhorizon.com\/reza\/2008\/10\/12\/ssrs-2008-integrated-mode-on-an-existing-web-apps\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/blogs.devhorizon.com\/reza\/2008\/10\/12\/ssrs-2008-integrated-mode-on-an-existing-web-apps\/#primaryimage","url":"https:\/\/blogs.devhorizon.com\/reza\/wp-content\/uploads\/2008\/10\/applicationpoolundercustomaccount.png","contentUrl":"https:\/\/blogs.devhorizon.com\/reza\/wp-content\/uploads\/2008\/10\/applicationpoolundercustomaccount.png","width":632,"height":246},{"@type":"WebSite","@id":"https:\/\/blogs.devhorizon.com\/reza\/#website","url":"https:\/\/blogs.devhorizon.com\/reza\/","name":"Reza Alirezaei's Blog","description":"Blogging from the field!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blogs.devhorizon.com\/reza\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/blogs.devhorizon.com\/reza\/#\/schema\/person\/cdbb24d283697a65951cb4a14e474938","name":"Reza Alirezaei","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/3ba940d84e0ecb909e62e93df4c56daf0395c7e53c914467ab2ee73124a7d7b6?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/3ba940d84e0ecb909e62e93df4c56daf0395c7e53c914467ab2ee73124a7d7b6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3ba940d84e0ecb909e62e93df4c56daf0395c7e53c914467ab2ee73124a7d7b6?s=96&d=mm&r=g","caption":"Reza Alirezaei"},"url":"https:\/\/blogs.devhorizon.com\/reza\/author\/rezaa\/"}]}},"_links":{"self":[{"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/posts\/719","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/comments?post=719"}],"version-history":[{"count":0,"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/posts\/719\/revisions"}],"wp:attachment":[{"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/media?parent=719"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/categories?post=719"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/tags?post=719"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}