Databases Reference
In-Depth Information
The Try... Catch() part of the code will catch errors,
if any. WmiNamespace , and WmiRSClass are strings, and if
they are not correctly formatted, they will throw exceptions
Reporting Services command prompt
utilities
The following are the available command prompt utilities in SQL Server 2012
(see Chapter 1 , Overview and Installation-SQL Server Reporting Services 2012 :
• The RSS utility ( rs.exe ) supported on both the Native mode and SharePoint
Integrated mode servers helps to write scripts to carry out operations such
as copy data between Report Servers, publish reports, and other deployment
and administrative tasks.
Rsconfig ( rsconfig.exe) is used to configure and manage a Report Server
connection in the Native mode to the Report Server database.
Rskeymgmt utility ( rskeymgmt.exe) is supported in the Native mode
only, Rskeymgmt utility manages encryption keys. Associated tasks such
as backup, restore, apply, and recreate symmetric keys are also handled.
Rskeymgmt is also used for database recovery tasks. You can also delete
encrypted content and recreate new ones, and so on.
• PowerShell cmdlets used exclusively with SharePoint Integrated installations
were explored in an earlier section of this chapter.
Three of the above are found in the SQL Server installation folder ( C:\Program
Files (x86)\Microsoft SQL Server\110\Tools\Binn ), as follows:
 
Search WWH ::




Custom Search