SQL Server Pre-Installation Steps

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).


Top of page

x
Procedure: How to Configure Security

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:

  1. Open the SQL Server Management Studio.
  2. Connect to your database server.
  3. Right-click your SQL Server and choose Properties.
  4. On the left, click Security.
  5. Ensure that Server authentication is set to SQL Server and Windows Authentication mode. If Authentication is set to Windows Authentication mode, change the setting.
  6. Click OK.
  7. If you changed the authentication mode, restart SQL Server.

Top of page

x
Procedure: How to Create the Login ID
  1. In the SQL Server Management Studio, expand your SQL Server and expand the Security folder.
  2. Right-click Logins.
  3. Select New Login.

    The following form appears for adding a new user ID.

  4. Enter the user ID you wish to use in the Login name field.
  5. Select SQL Server authentication.
  6. Enter and confirm your password.
  7. Uncheck the boxes for Enforce password policy, Enforce password expiration, and User must change password at next login.
  8. Click OK.

Top of page

x
Procedure: How to Create the Repository Database
  1. In the SQL Server Management Studio, right-click the Databases folder.
  2. Select New Database.

    A form appears for adding a database.

  3. Type a name for the repository database in the Database name field.
  4. In the Owner field, enter the user ID you created in How to Create the Login ID.

    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.

  5. Click OK, and the database is created.

    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.


Top of page

x
Procedure: How to Install the JDBC Driver for SQL Server 2014, 2012, 2008, or 2005

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.


Top of page

x
Procedure: How to Enable TCP/IP in SQL Server 2014, 2012, 2008, and 2005

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.

  1. Open the SQL Server Configuration Manager.
  2. Under the SQL Server Network Configuration select Protocols for MSSQLSERVER.

    A list of valid network protocols for the SQL Server engine is displayed in the right pane.

  3. Select TCP/IP from the list of available protocols.
  4. Right-click TCP/IP and select Enable from the context menu.

    A message is displayed, which indicates that the MSSQLSERVER service must be restarted before the change is applied.

  5. Restart the MSSQLSERVER service.

WebFOCUS