SQL Server Reporting Service 入门三步走

原创于 2012-06-07 16:26:57 发布 · 4k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#sql server #service #report #properties #server #browser

DB 专栏收录该内容

24 篇文章

订阅专栏

本文提供了一套详细的步骤指南，用于检查 SQL Server 报告服务是否正常运行，包括使用 Reporting Services Configuration Manager 和验证 URL。此外，文章还介绍了如何在 SQL Server Business Intelligence Development Studio 中创建报告项目，并通过配置和部署来预览和访问报告。

1. use Reporting Services Configuration manager to check if Report Server is running normally.
2. go to Computer Management to view the IIS-->ReportServer project(right click to view it)
Or you can enter the url to check if Report Server works normally.
URL like:
SQL Server 2008
http://suzm009893:8080/ReportServer_SQLEXPRESS

SQL Server 2005
管理：http://localhost/Reports$REX_Develop
访问：http://localhost/ReportServer$REX_Develop

3. Create report project in "SQL Server Business Intelligence Development Studio"
Preview it to check if it is correct.
Right click the project root and select properties: configure TargetServerURL, make it like 'http://servername(not

localhost)/ReportServer$Rex_Develop/'
Right click the project root and select "Deploy"
Then view it in Browser by url: http://localhost/ReportServer$REX_Develop