Databases Reference
In-Depth Information
Reporting Services 2012 in Native mode has two options (refer to
the installation steps of SQL Server 2012). There is an Install and
Conigure option and an Install Only option. In the first case,
the Report Server is installed and configured for the most part,
and is operational at the end of the SQL Server 2012 installation.
When installed using the Install Only option, the user will have
to configure the Report Server by using the Reporting Services
Configuration Manager from scratch.
However, if SharePoint Integrated mode is chosen, only the
required files are installed and you need to work with SharePoint
Central administration to complete the configuration.
In case this option ( Install Only ) is chosen, you need to manually create the catalog
by using this page. Using the Change Database and Change Credentials buttons, you
can invoke the wizards to make your desired changes. Regarding the credentials to
access the Reporting Services catalog, the Windows Integrated Security login specified
during SQ Server 2012 installation is used, as we have done during the SQL Server
installation. The Windows user account for the local machine (domain account for
remote) and SQL Server logins can also be used for the credentials.
Although SQL Server 2012 on the local machine hosts the database, the Report
Server catalog can be hosted on a remote machine or on a SQL Server 2005 instance.
For this topic, the default databases are accepted. The catalog schema is not public,
and the applications should not run queries against this catalog. The recommended
procedure is to use the Reporting Services API to access the databases.
Just like the Report Server, the Report Manager can also be accessed by a URL.
The virtual directory of Report Manager is very similar to the virtual directory of the
Report Server and shows the instance name. Since the Native mode installation option
was chosen, it is configured with the default. The Advanced button on the Report
Manager URL would bring up the Advanced Multiple Web Site Configuration
window, wherein you can configure various identities for Report Manager. These
options are not used in the topic.
Regarding the e-mail delivery, SMTP is chosen for the mail transfer, and you must
supply the correct information for configuring this screen. SMTP needs a sender's
address as well as an SMTP server for sending out the mail. The SMTP server can be
local or remote. Using Internet SMTP servers did not work, as the Internet Web mail
providers such as gmail.com, live.com, and Yahoo.com have made changes to their
SMTP servers, which make it difficult to use them from Reporting Services.
 
Search WWH ::




Custom Search