RSS Reporter for SQL Server

Adding SQL Servers to the user profile

 

You can add multiple SQL Server instances to your profile. For each SQL Server you choose to add, you should specify:

• The SQL Server instance name
• An optional display name or alias that appears on the left panel
• The authentication method that will be used to connect to the specified SQL Server instance
• The username and password if SQL Server authentication has been selected

You can add the same SQL Server multiple times in the profile with different display names or aliases. This can be especially useful if you wish to generate job feeds with different preferences for the same SQL Server. If you have, for example, a SQL Server named XYZ for which you want to generate two job feeds, one that contains all the jobs that failed and another feed that contain all the jobs that succeeded, you can add the XYZ server in the profile twice, with aliases XYZ_JobFailure and XYZ_JobSucceeded. Then, on XYZ_JobFailure, you can choose to include the jobs that failed in the predefined feeds, whereas on the case of the XYZ_JobSucceeded you can choose to include only the jobs that succeeded.
RSS Reporter licensing considers multiple aliases of the same SQL Server as one instance.

Note on the authentication method: Windows authentication will work only if the ASP.NET Worker Process account has access to the given SQL Server instance otherwise you must use SQL Server authentication

Important note: SQL Server authentication information that you provide here is encrypted and stored in the profile's Xml file on the machine on which the RSS Reporter is installed.