Report Server Tab of the Weblink Form

Use the Report Server tab to specify report server connection information.

Contents

Toolbar

Field	Description
Save	Select this option to save your changes.
Test	Click this option to test the connection for the Database Connection (Vantagepoint, not Report Server) and Report Server Configuration.
Change Password	Select this option to change your Weblink password.

Report Server Web Service Access

Field	Description
Server URL	Enter the URL of the SSRS report server.
Windows Username	Enter the Windows username that will be used to access the report server Web service.
Windows Password	Enter the password for the Windows username.
Use HTTPS for Reporting Services Server-Side Calls (See Documentation for More Information)	Server side calls (from the web/application server to the SSRS server) and client side calls (from the Vantagepoint Smart Client to the SSRS server) occur when running reports. By default, all server side calls to SSRS will use HTTP, and client side calls to SSRS will use whatever was used to access the Vantagepoint application (HTTP or HTTPS). Select this check box to override the current reporting framework behavior to use HTTPS for server side SSRS calls. If you do so, the client side behavior remains unchanged. If your enterprise is using HTTP for Vantagepoint, do not select this check box. It is only designed to be used with an SSL configuration. If your enterprise is using HTTPS for Vantagepoint and you select this check box, then the call will be made using HTTPS for SSRS server side and HTTPS for SSRS client side.

Report Server Database Access

Field	Description
Server Name	Enter the server name. This field is only used to access the report server database catalog.
Database Name	Enter the name of the report server database used for the report server URL configured above.
Windows Authentication	Select this check box to use the Windows Username and Windows Password to access the Report Server database. This user account must have been created as a valid user account in SQL Server and must have the appropriate rights to the ReportServer and ReportServerTempDB databases as well as the Vantagepoint transaction database. If this check box is selected, then the Database Username and Database Password fields are disabled. The Windows username and password will be used instead. If this box is cleared, then you must specify a Database Username and Database Password to use.
Database Username	Enter the username that will be used to access this Report Server database.
Database Password	Enter the password for the database username.

Use Alternate Database for Reporting Section

Field	Description
Use Alternate Database for Reporting	Select this check box to enable the use of an alternate database for reporting. The database configuration fields in the section are enabled after you select the option. When you use an alternate database for reporting, consider the following: Find an appropriate method to create a copy of the database on the second SQL Server (for example, SQL Server Availability Groups, transactional replication, log shipping, database backup/restore, or third party tools that support SQL Server snapshot backup). Ensure that the database copy used for reporting is kept in sync with the transaction database. Not keeping the databases in sync will result in stale data for reporting purposes. Ensure that the SQL login used for authentication has read-only access to the database or that the database is marked as read-only.
Server Name	Enter the name of the SQL Server hosting the alternate database. This field is enabled when you select the Use Alternate Database for Reporting check box.
Database Name	Enter the name of the alternate database. This field is enabled when you select the Use Alternate Database for Reporting check box.
Windows Authentication	Select this check box if you are using Windows Authentication for the database connection. This field is enabled when you select the Use Alternate Database for Reporting check box.
Database Username	If you are not using Windows Authentication, enter the SQL server username with read-only rights to the alternate database. This field is enabled when you select the Use Alternate Database for Reporting check box. It is disabled when you select the Windows Authentication check box.
Database Password	If you are not using Windows Authentication, enter the SQL server password with read-only rights to the alternate database. This field is enabled when you select the Use Alternate Database for Reporting check box. It is disabled when you select the Windows Authentication check box.
Alternate Planning Temp Database	Select this check box if you use an alternate database for report processing, and you want Resource Planning and Project reports that use a Planning budget source (specified in report options) to be processed through the alternate reporting database. If you have the alternate database for report processing set up, but you don't have the Planning temporary database set up, these reports are processed through the main Vantagepoint transaction database and temporary work tables are written to that database. You must create a Planning temporary database (Planning TempDB) on the server that hosts the read-only alternate reporting database. The Planning temporary database is an empty SQL Server database configured in Weblink with specific settings. Vantagepoint uses this writeable temporary database on the alternate report server to store temporary data for Resource Planning and Project reports. Vantagepoint regularly removes older temporary tables that were written to this database. After you select this check box, enter information in the fields below for the Planning temp database.
Server Name	This is the server where the Planning temporary database resides. This field prefills with the name of the server that you entered for the alternate database for reporting above. Both databases must reside on the same server.
Database Name	Enter the name the Planning temporary database. This is a writeable, blank database used for temporary data storage. You must manually create the database. It must also have a schema created with the same name as either of the following: The Windows identity used by the AppPool on the webserver if you selected the Windows Authentication check box ("DOMAIN\USER") below. The SQL Server login used. This field is enabled when you select the Alternate Planning Temp Database check box.
Windows Authentication	Select this check box if you want Vantagepoint reporting to use Windows Authentication for logging in to the Planning temporary database. This field is enabled when you select the Alternate Planning Temp Database check box.
Database Username	Enter the SQL server login name for logging in to the Planning Temporary database. This is required if you don't use Windows Authentication. Unlike the login used for the alternate reporting database, this login must have write access to this database. This field is enabled when you select the Alternate Planning Temp Database check box. It is disabled when you select the Windows Authentication check box.
Database Password	Enter the SQL server password for logging in to the Planning Temporary database. This field is enabled when you select the Alternate Planning Temp Database check box. It is disabled when you select the Windows Authentication check box.

Field	Description
Report Root Folder	Enter the name of the root folder where all Vantagepoint reports are installed.