All of our production instances of reporting services are split into the web server components and the reports database components.
我们的所有报告服务生产实例都分为Web服务器组件和报告数据库组件。
I know that you can detect the instance of SQL Server on a database server by the following TSQL:
我知道您可以通过以下TSQL检测数据库服务器上的SQL Server实例:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'),
SERVERPROPERTY ('edition')
However, in our case, the reporting servers do not have a database server components installed. So how do I detect what service pack is installed in this situation?
但是,在我们的示例中,报告服务器没有安装数据库服务器组件。那么如何在这种情况下检测安装了哪些Service Pack?
3 个解决方案
#1
Manually, or using web scraping, browse to
手动或使用网页抓取,浏览到
http://reportServerName/ReportServer
and the version number is at the bottom of the page.
版本号位于页面底部。
Or programatically:
using System;
using System.Collections.Generic;
using System.IO;
using System.Text;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
class Sample
{
static void Main(string[] args)
{
// Create proxy object and set service
// credentials to integrated
ReportingService2006 rs = new ReportingService2006();
rs.Url = "http://<Server Name>/_vti_bin/ReportServer/" +
"ReportService2006.asmx";
rs.Credentials =
System.Net.CredentialCache.DefaultCredentials;
try
{
// Set the server info header
rs.ServerInfoHeaderValue = new ServerInfoHeader();
// Make a call to the Web service
CatalogItem[] items = rs.ListChildren("/");
// Output the server version and edition to the console
Console.WriteLine("Server version: {0}",
rs.ServerInfoHeaderValue.ReportServerVersionNumber);
Console.WriteLine("Server edition: {0}",
rs.ServerInfoHeaderValue.ReportServerEdition);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
}
#2
In your browser go to
在您的浏览器中转到
http://<reportserverName>/reportserver
Just look at the bottom of the page
只需查看页面底部即可
#3
The Reporting Services Configuration Tool details the SQL Server version running.
Reporting Services配置工具详细说明了正在运行的SQL Server版本。
#1
Manually, or using web scraping, browse to
手动或使用网页抓取,浏览到
http://reportServerName/ReportServer
and the version number is at the bottom of the page.
版本号位于页面底部。
Or programatically:
using System;
using System.Collections.Generic;
using System.IO;
using System.Text;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
class Sample
{
static void Main(string[] args)
{
// Create proxy object and set service
// credentials to integrated
ReportingService2006 rs = new ReportingService2006();
rs.Url = "http://<Server Name>/_vti_bin/ReportServer/" +
"ReportService2006.asmx";
rs.Credentials =
System.Net.CredentialCache.DefaultCredentials;
try
{
// Set the server info header
rs.ServerInfoHeaderValue = new ServerInfoHeader();
// Make a call to the Web service
CatalogItem[] items = rs.ListChildren("/");
// Output the server version and edition to the console
Console.WriteLine("Server version: {0}",
rs.ServerInfoHeaderValue.ReportServerVersionNumber);
Console.WriteLine("Server edition: {0}",
rs.ServerInfoHeaderValue.ReportServerEdition);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
}
#2
In your browser go to
在您的浏览器中转到
http://<reportserverName>/reportserver
Just look at the bottom of the page
只需查看页面底部即可
#3
The Reporting Services Configuration Tool details the SQL Server version running.
Reporting Services配置工具详细说明了正在运行的SQL Server版本。