Category: SQL Server Reporting Services

  • SSRS Conf. Manager is not working, then how to take Reporting Services Encryption Key backup.

    The rskeymgmt utility can be found in the binn sub-directory of your SQL Server install directory. On my local server, it resides in: C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn. Of course depending on the install process, your location may be different. Opening the command prompt and navigating to this directory, we can run rskeymgmt -? Extract…

  • IO Subsystem Analysis

    SQLIO.exe is a tool provided by Microsoft that can be used to determine the I/O capacity of a given configuration.  Installation:-> Step 1. Configure Param.txt The first step is to modify the file param.txt to tell SQLIO where to find its test file which is named testfile.dat. Parameter Description Values file name Name of the test file R:\testfile.dat number…