{"id":7327,"date":"2014-06-07T02:25:34","date_gmt":"2014-06-07T02:25:34","guid":{"rendered":"https:\/\/unknownerror.org\/index.php\/2014\/06\/07\/permissions-issues-with-sql-2008-report-builder-2-0-collection-of-common-programming-errors\/"},"modified":"2014-06-07T02:25:34","modified_gmt":"2014-06-07T02:25:34","slug":"permissions-issues-with-sql-2008-report-builder-2-0-collection-of-common-programming-errors","status":"publish","type":"post","link":"https:\/\/unknownerror.org\/index.php\/2014\/06\/07\/permissions-issues-with-sql-2008-report-builder-2-0-collection-of-common-programming-errors\/","title":{"rendered":"Permissions issues with SQL 2008, Report Builder 2.0-Collection of common programming errors"},"content":{"rendered":"<p>So here&#8217;s a bit of context for the horror story:<\/p>\n<ul>\n<li>Win 2003 SP2 64bit running on a VM exposed to outside world for web access.<\/li>\n<li>SQL Server 2008 Std SP2 64bit with Reporting Services (RS) installed for native mode (i.e. not sharepoint mode).<\/li>\n<li>IIS 6 .NET 3.5 web site app written to use the web services from RS. The site has been set to use Windows Authentication and nothing else.<\/li>\n<li>To save writting custom authentication since I don&#8217;t need it for this demo I have set-up a local account in Win 2003, i.e. servername\\myDemoUser, effectively allow fake Windows Authentication.<\/li>\n<li>Default.aspx lists folders on RS and the reports from each folder. It also has a link to the Report Builder 2 on the server.<\/li>\n<li>The rsreportserver.config has been changed so that the only is since can&#8217;t work since it&#8217;s across the internet and users will not be on the same network (hence the local account myDemoUser).<\/li>\n<li>The web site app has url of the form: http:\/\/mysite.mydomain.co.uk\/ and the link on it to the Report Builder is of the form: http:\/\/mysite.mydomain.co.uk\/services\/reportbuilder\/reportbuilder_2_0_0_0.application, in this case RS has been configured so the Web services virtual directory is &#8220;services&#8221;.<\/li>\n<li>The web.config for the website app has been set to<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>So here&#8217;s a bit of context for the horror story: Win 2003 SP2 64bit running on a VM exposed to outside world for web access. SQL Server 2008 Std SP2 64bit with Reporting Services (RS) installed for native mode (i.e. not sharepoint mode). IIS 6 .NET 3.5 web site app written to use the web [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-7327","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/7327","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/comments?post=7327"}],"version-history":[{"count":0,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/7327\/revisions"}],"wp:attachment":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/media?parent=7327"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/categories?post=7327"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/tags?post=7327"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}