How to: |
To use SQL Server for the WebFOCUS Repository, do the following:
The WebFOCUS repository can reside on the same system as the WebFOCUS Client or on a different system, and can be stored in any JDBC-compliant database for which a driver exists. For more information, see WebFOCUS Client Post-Installation Tasks. When the Distribution Server is installed (as explained in Installing the WebFOCUS Client), you will be required to provide a supported database, JDBC driver, and authentication information (user ID and password).
SQL Server provides the following authentication modes:
The JDBC driver that is used by WebFOCUS to connect to the SQL Server database does not support Windows Authentication mode. Perform the following steps to ensure that SQL Server Authentication mode is set:
The following form appears for adding a new user ID.
A form appears for adding a database.
You can leave the remaining defaults. An initial size of 1-5MB for the database should be adequate for most departmental applications, but you may want to increase the initial size of the database if you anticipate a lot of use.
It is a good idea to set this database as the default for your user ID. To do this, under Security and Logins, right-click your user ID and choose Properties. Then set the Default database and click OK.
The application server where the WebFOCUS Client and the ReportCaster Distribution Server is deployed on use the SQL Server JDBC driver to access the WebFOCUS Repository. You should download the SQL Server JDBC driver for your SQL Server release. You can downloaded the drivers free of charge from:
http://microsoft.com
Search the site for the driver for your SQL Server release.
The following file is the SQL Server 2014, 2012, and 2008 driver:
sqljdbc4.jar
The following file is the SQL Server 2005 driver:
sqljdbc.jar
If WebFOCUS Client and ReportCaster Distribution Server are on separate machines, the driver must be on both machines. Running the driver installation program is not necessary, so you can manually copy the driver files between different machines.
During the ReportCaster Distribution Server installation, you are prompted for the file or files, as explained in Installing the WebFOCUS Client. In addition, if you manually configure your application server, you must also provide the file or files, as explained in Configuring Web and Application Servers.
SQL Server 2014, 2012, 2008, and 2005 have TCP/IP disabled, by default. Since the WebFOCUS Client and ReportCaster require TCP/IP, you must perform the following steps to enable TCP/IP in SQL Server.
A list of valid network protocols for the SQL Server engine is displayed in the right pane.
A message is displayed, which indicates that the MSSQLSERVER service must be restarted before the change is applied.
WebFOCUS |