{"id":2601,"date":"2013-04-07T08:11:53","date_gmt":"2013-04-07T08:11:53","guid":{"rendered":"http:\/\/enjoyasp.net\/?p=2601"},"modified":"2013-04-07T08:33:50","modified_gmt":"2013-04-07T08:33:50","slug":"reportingservices2008%e5%8c%bf%e5%90%8d%e8%ae%bf%e9%97%ae","status":"publish","type":"post","link":"https:\/\/enjoyasp.net\/index.php\/2013\/04\/07\/reportingservices2008%e5%8c%bf%e5%90%8d%e8%ae%bf%e9%97%ae\/","title":{"rendered":"ReportingServices2008\u533f\u540d\u8bbf\u95ee"},"content":{"rendered":"
\n
\n

\n\t\t\t\u5728ReportingServices2005\u4e2d\u6211\u4eec\u9700\u8981\u533f\u540d\u8bbf\u95ee\u62a5\u8868\u7684\u65f6\u5019\uff0c\u53ea\u9700\u8981\u5728IIS\u91cc\u9762\u505a\u4e0b\u7b80\u5355\u8bbe\u7f6e\u5c31\u53ef\u4ee5\u5b9e\u73b0\uff0c\u800c\u5728ReportingServices2008(R2)\u4e2d\u4e0d\u5728\u4f9d\u9760IIS\uff0c\u53ea\u662f\u5360\u7528\u7684\u8fd8\u662f80\u7aef\u53e3\u800c\u5df2\u3002\u5176\u5b9e\u533f\u540d\u8bbf\u95ee\u6709\u5f88\u591a\u4e2d\u89e3\u51b3\u529e\u6cd5\uff0c\u8b6c\u5982\uff1a\u4f7f\u7528ReportViewer\u63a7\u4ef6\u3001\u4e0eSharePoint\u96c6\u6210\u7b49\u7b49……<\/p>\n

\n\t\t\t <\/p>\n<\/p><\/div>\n<\/div>\n

\n
\n

\n\t\t\t\u8f6c\u81ea\u4e00\u6b65\u4e00\u6b65\u5b9e\u73b0ReportingServices2008\u533f\u540d\u8bbf\u95ee<\/a><\/p>\n

\n\t\t\t\u5728ReportingServices2005\u4e2d\u6211\u4eec\u9700\u8981\u533f\u540d\u8bbf\u95ee\u62a5\u8868\u7684\u65f6\u5019\uff0c\u53ea\u9700\u8981\u5728IIS\u91cc\u9762\u505a\u4e0b\u7b80\u5355\u8bbe\u7f6e\u5c31\u53ef\u4ee5\u5b9e\u73b0\uff0c\u800c\u5728ReportingServices2008(R2)\u4e2d\u4e0d\u5728\u4f9d\u9760IIS\uff0c\u53ea\u662f\u5360\u7528\u7684\u8fd8\u662f80\u7aef\u53e3\u800c\u5df2\u3002\u5176\u5b9e\u533f\u540d\u8bbf\u95ee\u6709\u5f88\u591a\u4e2d\u89e3\u51b3\u529e\u6cd5\uff0c\u8b6c\u5982\uff1a\u4f7f\u7528ReportViewer\u63a7\u4ef6\u3001\u4e0eSharePoint\u96c6\u6210\u7b49\u7b49……<\/p>\n

\n\t\t\t\u4e0b\u9762\u6211\u4ecb\u7ecdSQL\u56e2\u961f\u6280\u672f\u535a\u5ba2\u6240\u63d0\u4f9b\u7684\u6bd4\u8f83\u5f7b\u5e95\u800c\u4e14\u901a\u7528\u7684\u65b9\u6cd5 \u3002(\u6ce8\uff1a\u4fee\u6539\u914d\u7f6e\u6587\u4ef6\u524d\u5982\u679c\u5bb3\u6015\u51fa\u95ee\u9898\u8bf7\u63d0\u524d\u5907\u4efd)<\/p>\n

\n\t\t\t\u7b2c\u4e00\u6b65\uff1a\u7f16\u8bd1SQL\u56e2\u961f\u6240\u63d0\u4f9b\u7684\u4ee3\u7801\u5e76\u5c06\u6240\u751f\u6210\u7684Microsoft.Samples.ReportingServices.AnonymousSecurity.dll<\/a>\u6587\u4ef6\u62f7\u8d1d\u5230SQL Server\u7684\u5b89\u88c5\u76ee\u5f55*:\\Program Files\\Microsoft SQL Server\\MSRS10_50.MSSQLSERVER\\Reporting Services\\ReportServer\\bin\u4e0b<\/p>\n

\n\t\t\t <\/p>\n

\n\t\t\t\u7b2c\u4e8c\u6b65\uff1a\u4fee\u6539Reporting Services\\ReportServer \u548cReporting Services\\ReportManager\u6587\u4ef6\u4e2d\u7684web.config\u6587\u4ef6\uff0c\u66ff\u6362\u4e8c\u8005\u4e2d\u7684\u8282\u70b9\uff0c\u5c06<\/p>\n

\r\n<\/pre>\n
    \n
  1. \n
    \r\n<authentication mode=<\/span>"Windows"<\/span> \/>  <\/span><\/span><\/pre>\n<\/li>\n
  2. \n\t\t\t\t<identity impersonate=<\/span>"true"<\/span>\/> <\/span><\/li>\n<\/ol>\n
    \n\t\t\t\u66ff\u6362\u4e3a<\/p>\n
    \r\n<\/pre>\n
      \n
    1. \n
      \r\n<authentication mode=<\/span>"None"<\/span> \/>  <\/span><\/span><\/pre>\n<\/li>\n
    2. \n\t\t\t\t<identity impersonate=<\/span>"false"<\/span>\/>  <\/span><\/li>\n<\/ol>\n
      \n\t\t\t\u7b2c\u4e09\u6b65\uff1a\u4fee\u6539Reporting Services\\ReportServer\u4fee\u6539rereportserver.config\u628a<\/p>\n
      \r\n<\/pre>\n
        \n
      1. \n
        \r\n<Authentication>  <\/span><\/pre>\n<\/li>\n
      2. \n\t\t\t\t   <AuthenticationTypes>  <\/span><\/li>\n
      3. \n\t\t\t\t    <RSWindowsNegotiate\/>  <\/span><\/li>\n
      4. \n\t\t\t\t    <RSWindowsNTLM\/>  <\/span><\/li>\n
      5. \n\t\t\t\t   <\/AuthenticationTypes>  <\/span><\/li>\n
      6. \n\t\t\t\t<EnableAuthPersistence><\/span>true<\/span><\/EnableAuthPersistence>  <\/span><\/li>\n
      7. \n\t\t\t\t<\/Authentication> <\/span><\/li>\n<\/ol>\n
        \n\t\t\t\u4fee\u6539\u4e3a<\/p>\n
        \r\n<\/pre>\n
          \n
        1. \n
          \r\n<Authentication>  <\/span><\/pre>\n<\/li>\n
        2. \n\t\t\t\t   <AuthenticationTypes>  <\/span><\/li>\n
        3. \n\t\t\t\t    <Custom\/>  <\/span><\/li>\n
        4. \n\t\t\t\t   <\/AuthenticationTypes>  <\/span><\/li>\n
        5. \n\t\t\t\t<EnableAuthPersistence><\/span>true<\/span><\/EnableAuthPersistence>  <\/span><\/li>\n
        6. \n\t\t\t\t<\/Authentication> <\/span><\/li>\n<\/ol>\n
          \n\t\t\t\u7b2c\u56db\u6b65\uff1a\u4fee\u6539Reporting Services\\ReportServer\u4fee\u6539rereportserver.config\u5728<\/p>\n
          \r\n<\/pre>\n
            \n
          1. \n
            \r\n<Security>  <\/span><\/pre>\n<\/li>\n
          2. \n\t\t\t\t <Extension <\/span>Name<\/span>=<\/span>"Windows"<\/span> Type=<\/span>"Microsoft.ReportingServices.Authorization.WindowsAuthorization, Microsoft.ReportingServices.Authorization"<\/span>\/>  <\/span><\/li>\n
          3. \n\t\t\t\t<\/Security>  <\/span><\/li>\n
          4. \n\t\t\t\t<Authentication>  <\/span><\/li>\n
          5. \n\t\t\t\t <Extension <\/span>Name<\/span>=<\/span>"Windows"<\/span> Type=<\/span>"Microsoft.ReportingServices.Authentication.WindowsAuthentication, Microsoft.ReportingServices.Authorization"<\/span>\/>  <\/span><\/li>\n
          6. \n\t\t\t\t<\/Authentication> <\/span><\/li>\n<\/ol>\n
            \n\t\t\t\u8282\u70b9\u4e0b\uff0c\u6dfb\u52a0<\/p>\n
            \r\n<\/pre>\n
              \n
            1. \n
              \r\n<Security>  <\/span><\/pre>\n<\/li>\n
            2. \n\t\t\t\t       <Extension <\/span>Name<\/span>=<\/span>"None"<\/span> Type=<\/span>"Microsoft.Samples.ReportingServices.AnonymousSecurity.Authorization, Microsoft.Samples.ReportingServices.AnonymousSecurity"<\/span> \/>  <\/span><\/li>\n
            3. \n\t\t\t\t<\/Security>  <\/span><\/li>\n
            4. \n\t\t\t\t<Authentication>  <\/span><\/li>\n
            5. \n\t\t\t\t       <Extension <\/span>Name<\/span>=<\/span>"None"<\/span> Type=<\/span>"Microsoft.Samples.ReportingServices.AnonymousSecurity.AuthenticationExtension, Microsoft.Samples.ReportingServices.AnonymousSecurity"<\/span> \/>  <\/span><\/li>\n
            6. \n\t\t\t\t<\/Authentication>  <\/span><\/li>\n<\/ol>\n
              \n\t\t\t\u5230\u6b64\u4e3a\u6b62\uff0cReportingServices2008(R2)\u7684\u533f\u540d\u8bbf\u95ee\u5c31\u5927\u529f\u544a\u6210\u4e86\u3002<\/p>\n
              \n\t\t\t\u53c2\u8003\u8d44\u6599\uff1a<\/p>\n
              \n\t\t\thttp:\/\/blogs.msdn.com\/b\/jameswu\/archive\/2008\/07\/15\/anonymous-access-in-sql-rs-2008.aspx (\u5b98\u65b9\u6559\u7a0b)<\/p>\n
              \n\t\t\thttp:\/\/lonely7345.cnblogs.com\/ (\u5bf9\u4e8eAnonymousSecurity.dll\u6709\u4e2d\u6587\u89e3\u91ca)<\/p>\n
              \n\t\t\t\u539f\u6587\u94fe\u63a5\uff1ahttp:\/\/www.cnblogs.com\/zhukuanglong\/archive\/2011\/06\/07\/2074374.html<\/p>\n<\/p><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
              \u5728ReportingServices2005\u4e2d\u6211\u4eec\u9700\u8981\u533f\u540d\u8bbf\u95ee\u62a5\u8868\u7684\u65f6\u5019\uff0c\u53ea\u9700\u8981\u5728IIS\u91cc\u9762\u505a\u4e0b\u7b80\u5355\u8bbe\u7f6e\u5c31\u53ef\u4ee5 […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36],"tags":[],"class_list":["post-2601","post","type-post","status-publish","format-standard","hentry","category-sql-server"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/2601","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/comments?post=2601"}],"version-history":[{"count":0,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/2601\/revisions"}],"wp:attachment":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/media?parent=2601"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/categories?post=2601"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/tags?post=2601"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}