SQL Server 2008 - 报表管理器 URL 显示没有“属性”选项卡的页面
我有 SQL Server 2008 Developer Edition，但在 Reporting Services 方面遇到以下问题。
当我在浏览器中打开报表管理器 URL（从 Reporting Services 配置管理器获取）时，它会显示一个 SQL Server Reporting Services 页面，左上角有一个文件夹图标，并带有文本“Home”、“的链接”我的订阅”，右上角的“帮助”。就这样吧，我看不到其他东西了。 我有一个与 Reporting Services 配置管理器中为报表管理器指定的名称相同的虚拟目录。
在浏览器中打开报表服务器会出现以下错误消息-
报告服务错误 报表服务器无法打开与报表服务器数据库的连接。所有请求和处理都需要与数据库的连接。 (rsReportServerDatabaseUnavailable) 获取联机帮助 与 SQL Server 建立连接时发生与网络相关或特定于实例的错误。找不到服务器或无法访问服务器。验证实例名称是否正确以及 SQL Server 是否配置为允许远程连接。 （提供程序：共享内存提供程序，错误：40 - 无法打开与 SQL Server 的连接）
我在命令提示符下尝试了以下操作来解决它 -
rsconfig -c -s <SQLSERVERNAME> -d reportserver -a Windows -u <MYDOMAIN\MYACCOUNT> -p <PASSWORD>
但我收到另一个错误，提示 Report Server WMI提供者错误：无效的命名空间
我非常感谢对此的任何帮助。
干杯
I have SQL Server 2008 Developer Edition and I'm facing the following issues with the Reporting Services.
When I open the Report Manager URL (I get it from the Reporting Services Configuration Manager) in a browser, it shows me a SQL Server Reporting Services page with a folder icon on top left and links with text 'Home', 'My subscriptions', 'Help' on top right. That's it, I don't get to see anything else.
I have a virtual directory with the same name as specified for Report Manager in Reporting Services Configuration Manager.Opening the Report Server in the browser gives the following error message-
Reporting Services Error
The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) Get Online Help
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Shared Memory Provider, error: 40 - Could not open a connection to SQL Server)
I tried the following at the command prompt in order to resolve it-
rsconfig -c -s <SQLSERVERNAME> -d reportserver -a Windows -u <MYDOMAIN\MYACCOUNT> -p <PASSWORD>
but I got another error saying Report Server WMI Provider error: Invalid namespace
I would really appreciate any help on this.
cheers
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
我最终通过在 Windows 防火墙中为报表服务器打开一个端口来解决这两个问题。
对于 Windows 2003 和 Vista，此处提到的步骤 http://msdn.microsoft。 com/en-us/library/bb934283.aspx
干杯
I was finally able to get through both the problems by opening a port in Windows firewall for the Report Server.
For Windows 2003 and Vista the steps are mentioned here http://msdn.microsoft.com/en-us/library/bb934283.aspx
cheers
1) 打开开始 -> SQL Server（20xx）->在子文件夹中找到“Reporting Services 配置管理器”->转到数据库选项卡 ->检查“sql服务器名称”和“数据库名称”是否选择正确。它是报告服务在其中存储报告的数据库。
2)如果没问题，请检查是否有多个该sql实例。如果您的计算机上有多个实例，请决定要使用哪一个。例如 sql server 2008 或 sql server 2012。也许您使用的是 reporting services 2008 的 URL，而该 URL 未在其“Reporting Services 配置管理器”中使用正确的数据库
1) Open Start -> SQL Server (20xx) -> find "Reporting Services Configuration Manager" in subfolders -> go to Database tab -> check if "sql server name" and "Database Name" are selected correctly. It is the database which reporting services stores reports in it.
2) if it was OK, check if you have more the one sql instances. If you have more than one instances on your machine, decide which one you want to use. for example sql server 2008 or sql server 2012. Maybe you are using the URL of the reporting services 2008 that is not using a correct database in its "Reporting Services Configuration Manager"