One of my friends finds difficulty to get detail about Advance features in SQL SERVER 2008 Express Advance features and wants to know weather SSRS supported in it or not.
Look at the detail of features in SQL SERVER 2008 Express with Advance Features
I got this detail from different sources of msdn linked below.
You can download it from this link
http://www.microsoft.com/en-us/download/details.aspx?id=1842
list of Supported features and not Supported features in SQL SERVER Express 2008
http://msdn.microsoft.com/en-us/library/ms365248(v=sql.100).aspx
Look at the detail of features in SQL SERVER 2008 Express with Advance Features
I got this detail from different sources of msdn linked below.
You can download it from this link
http://www.microsoft.com/en-us/download/details.aspx?id=1842
features supported and unsupported by SSRS 2008 Express with Advance Edition is
SQL Server Express
provides the following Reporting Services functionality:
·
On-demand report
processing for each user who views a report. When a user opens a report, the
report is initialized, the query is processed, data is merged into the report
layout, and the report is rendered into a presentation format.
·
Rendering formats are
available for HTML, Acrobat, and Excel.
·
Report data sources must
be SQL Server relational databases that run locally in SQL Server Express.
·
Report server management
and report viewing are supported through Report Manager.
·
Configuration is
supported through the Reporting Services Configuration tool.
·
Rs.exe, rsconfig.exe,
and rskeymgmt.exe command line utilities are available in SQL Server Express.
·
Windows Authentication
and predefined roles are used to map existing group and user accounts to a
named collection of operations.
Other editions of SQL
Server include a larger set of Reporting Services features. The following list
describes the features that are documented in SQL Server Books Online, but
cannot be used in this edition:
·
Scheduled report
processing, caching, snapshots, subscriptions, and delivery are not supported.
·
Analysis Services,
Oracle, XML, SAP, SQL Server Integration Services (SSIS), OLE DB, and ODBC
data sources are not supported.
·
Remote data sources are
not supported. Reports that are hosted in a SQL Server Express report server
must retrieve SQL Server relational data from a local SQL Server
Express Database Engine instance.
·
Ad hoc reporting through
semantic models and Report Builder is not supported.
·
TIFF (Image), XML, and
CSV rendering extensions are not supported.
·
The Reporting Services
API extensible platform for delivery, data processing, rendering, and security
is not supported.
·
Custom authentication
extensions and custom role assignments are not supported. You must map existing
Windows domain user and group accounts to predefined role definitions.
·
Custom report items are
not supported.
·
Managing a long-running
report process is not supported. Specifically, you cannot use the Manage Jobs
feature in Report Manager to stop report processing.
·
Scale-out deployment is
not supported.
·
SharePoint integrated
mode is not supported.
·
Report Builder 2.0 is
not supported. Report Builder 2.0 can connect to a SQL Server Express database
on the local computer or on a remote report server.
list of Supported features and not Supported features in SQL SERVER Express 2008
http://msdn.microsoft.com/en-us/library/ms365248(v=sql.100).aspx
SQL Server Express
supports most of the features and functionality of SQL Server 2008. This
includes the following:
Stored procedures
|
SQL Server Configuration Manager
|
Views
|
Replication (as a subscriber only)
|
Triggers
|
Advanced Query Optimizer
|
Cursors
|
SMO/RMO
|
sqlcmd and osql utilities
|
Integration with Visual Studio
|
Snapshot isolation Levels
|
Service Broker (as a client only)¹
|
Native XML support. This includes XQuery and XML schemas
|
SQL CLR
|
Transact-SQL language support
|
Multiple Active Result Sets (MARS)
|
Dedicated Administrator Connection²
|
Full text search
|
Subset of Reporting Services features³
|
Import/Export Wizard
|
The following table
lists the additional SQL Server 2008 database features that are not supported
in this version of SQL Server Express. It also lists database features from
earlier versions of SQL Server that are not supported.
SQL Server features
not supported in SQL Server Express
|
SQL Server
features from earlier versions not supported in SQL Server Express
|
Database mirroring
|
SQL Mail
|
Online restore
|
Failover clustering
|
Database snapshot
|
Distributed partitioned views
|
Parallel index operations
|
VIA protocol support
|
Mirrored media sets
|
Log shipping
|
Partitioning
|
Parallel DBCC
|
Address Windowing Extensions (AWE)
|
Parallel Create Index
|
Hot-add memory
|
Enhanced Read Ahead and Scan
|
Native HTTP SOAP access
|
Indexed views (materialized views)
|
SQL Mail and Database Mail
|
Partitioned views
|
Online Index Operations
|
-
|
SQL Server Agent and SQL Server Agent Service
|
-
|
No comments:
Post a Comment