关于SQL 2008 R2 Reporting services设置问题

brio8425 2010-09-01 04:44:42
大家好啊~!
sql 2008 R2版本在win 7 安装完生成的文件夹:ReportManager与ReportServer下的配置文件与win 2003不一样;
我按照步骤一步步安装,对所有服务设置账号两系统都是一样的;即:local system。
可是装完后发现2003系统下可以正常访问 http://localhost/reportserver但是win7下却访问不了提示系统账户无权限。
在2005里我知道可以在iis的虚拟目录下设置权限,但是2008 R2里却找不到可以设置权限的地方?

各位有了解这方面情况的吗?

谢谢!
...全文
196 5 打赏 收藏 转发到动态 举报
写回复
用AI写文章
5 条回复
切换为时间正序
请发表友善的回复…
发表回复
brio8425 2010-09-02
  • 打赏
  • 举报
回复
我想我大概知道原因了:
win7 把administrator管理员给禁用了;必须启用,并且在administrator账户下安装;才能顺利的安装。

且:不管是用机器名还是localhost都是可以一样的。
Me_online 2010-09-01
  • 打赏
  • 举报
回复
从 SQL Server 2008 开始,SSRS 就不使用 IIS 了。

1)打开你的 Report Configuration Manager, 检查 Reporting Services 是否正常启动了;同时检查 Report Server 的URL路径, 我猜 Localhost 这个主机名应该是不正确,它应该是机器的名字。

2)如果上面的方法不行,你可以将 SSRS 的启动用户从 Local System, 改为 NetWork Account 试试看。
brio8425 2010-09-01
  • 打赏
  • 举报
回复
就是在IIS里没发现有report 虚拟目录;
claro 2010-09-01
  • 打赏
  • 举报
回复
检查IIS配置。
检查sql 2008 R2 报表服务;
检查sql 2008 R2 报表管理器配置。
brio8425 2010-09-01
  • 打赏
  • 举报
回复
其他的服务:ssis 运行生成没问题,ssas 部署也没问题;就是ssrs有点问题。
通过慢sql分析的学习,了解什么是慢sql,以及慢SQL会引起那些性能问题。清楚慢sql日志的设置,然后再通过慢sql分析工具的学习,清楚慢sql分析的步骤和流程。慢sql分析工具:mysqldumpslow工具、explain工具、profile工具、Optimizer Trace工具。 提供课程中所使用的sql语句。 课程内容:第一章:课程简介1、课程介绍2、课程大纲 第二章:慢sql简介1、慢sql简介2、慢sql会引起的问题 第三章:慢日志的设置1、慢sql的分析流程2、慢日志参数理解3、慢日志参数设置:第1种方式:my.ini文件设置4、慢日志参数设置:第2种方式:sql脚本设置5、慢日志参数设置-效果验证 第四章:如何发现慢sql1、如何发现慢sql:第1种方式:慢日志文件2、如何发现慢sql:第2种方式:mysql库的slow_log表 第五章:慢sql分析工具1、慢sql提取-mysqldumpslow工具-使用方法2、慢sql提取-mysqldumpslow工具-操作实战3、慢sql的执行计划分析-explain分析-执行计划结果说明4、慢sql的执行计划分析-explain分析-索引介绍+type类型举例5、慢sql的资源开销分析-profile分析-分析步骤6、慢sql的资源开销分析-profile分析-show profile执行阶段说明7、慢sql的资源开销分析-profile分析-完整列表说明+操作实战8、慢sql的跟踪分析-Optimizer Trace分析-分析步骤9、慢sql的跟踪分析-Optimizer Trace表的介绍10、索引失效场景举例 第六章:慢日志清理1、慢日志清理
中文名: SQL Server 2008 R2详解手册 原名: Microsoft SQL Server 2008 R2 Unleashed 作者: Ray Rankins Paul Bertucci Chris Gallelli Alex T.Silverstein 资源格式: PDF 版本: 影印版 出版社: Sams书号: 978-0672330568发行时间: 2010年09月26日 地区: 美国 语言: 英文 简介: 内容简介: Microsoft SQL Server 2008 R2 Unleashed includes full coverage of SQL Server 2008 in addition to R2 coverage This is the industry the most comprehensive and useful guide to SQL Server 2008 and 2008 R2. It presents start-to-finish coverage of SQL Server core database server and management capabilities, plus complete introductions to Integration, Reporting, and Analysis Services, application development, and much more. Four expert SQL Server administrators, developers, and consultants have packed this book with real-world information, tips, guidelines, and samples drawn from their own extensive experience creating and managing complex database solutions. Writing for intermediate-to-advanced-level SQL Server professionals, they focus on the product most complex and powerful capabilities, and its newest tools and features. For example, you will find invaluable information on administering SQL Server more efficiently, analyzing and optimizing queries, implementing data warehouses, ensuring high availability, and tuning performance. The accompanying CD-ROM contains an extraordinary library of practical tools and information including sample databases and all code examples. Whether you’re responsible for SQL Server 2008 analysis, design, implementation, support, administration, or troubleshooting, no other book offers you this much value. * Understand the Microsoft SQL Server 2008 environment, R2 for newest features, and each edition capabilities * Manage SQL Server 2008 more effectively with SQL Server Management Studio, the SQLCMD command-line query tool, and Powershell * Efficiently manage security, users, backup/restore, replication, Database Mail, and database objects from tables and indexes to stored procedures and triggers * Increase availability with clustering, database mirroring, and other features * Use new Policy-Based Management to centrally configure and operate SQL Server throughout the organization * Use SQL Server Profiler to capture queries and identify bottlenecks * Improve performance by optimizing queries, design more effective databases, and manage workloads with the new Resource Governor * Develop applications using SQL Server 2008 enhancements to T-SQL and SQLCLR, .NET integration, LINQ to SQL, XML, and XQuery 作者介绍: Ray Rankins, president of Gotham Consulting Services, has worked with Sybase and Microsoft SQL Server for more than 23 years and is coauthor of Sybase SQL Server Unleashed, Microsoft SQL Server 2000 Unleashed, and Microsoft SQL Server 2005 Unleashed. Paul Bertucci, founder of Database Architechs, has more than 30 years of experience in database design, architecture, replication, tuning, integration, and high availability. Chris Gallelli, president of CGAL Consulting Services, specializes in database administration, tuning, and programming. Alex T. Silverstein is managing principal and chief architect of Unified Digital Group, LLC, a developer of custom SQL Server and Microsoft .NET solutions. 目录: Introduction Part I Welcome to Microsoft SQL Server 1. SQL Serve 2008 Overview 2. What’s new in SQL Serve 2008 3. Examples of SQL Server Implementations Part II SQL Server Tools and Utilities 4. SQL Server Management Studio 5. SQL Server Command-Line Utilities 6. SQL Server Profiler Part III SQL Server Administration 7. SQL Server System and Database Administration 8. Installing SQL Serve 2008 9. Upgrading to SQL Serve 2008 10. Client Installation and Configuration 11. Security and User Administration ………

594

社区成员

发帖
与我相关
我的任务
社区描述
提出问题
其他 技术论坛(原bbs)
社区管理员
  • community_281
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧