Database Configuration Guide

CHAPTER 4

Configuring Microsoft SQL Server Databases

This chapter describes how to use Microsoft SQL Server databases with the Novell exteNd Application Server. It includes information about using Microsoft SQL Server as a SilverMaster or deployment database. It contains these sections:

For more information    For the latest information on supported database versions, see the Novell exteNd Application Server Release Notes.

 
Top of page

Basic setup for Microsoft SQL Server databases

You'll perform the following setup steps whether your Novell exteNd Application Server will access a Microsoft SQL Server database via JDBC or ODBC:

  1. Create the database and configure SQL Server.

  2. Create a database login to be used by the application server.

 
Top of section

Create the database and configure SQL Server

Before you can install the application server, you must first create the actual SQL Server database (and underlying database devices). You can create these objects using either ISQL or a graphical tool such as SQL Enterprise Manager.

 
Top of section

Create the database login

Create a login (with a name such as SilverUserLogin) to be used by the application server. Note the following:

 
Top of page

Setting up JDBC access

The application server can connect to Microsoft SQL Server using the JDBC driver supplied by Microsoft.

 
Top of section

Install the JDBC driver

You must have the Microsoft SQL Server JDBC driver installed on the machine where the application server will be. It must be able to connect to the destination SQL Server database.

 
Top of section

Add the driver path to AGCLASSPATH

The location of the Microsoft SQL Server JDBC driver (JAR files msbase.jar, mssqlserver.jar, and msutil.jar) must be specified in the AGCLASSPATH variable. For Windows, AGCLASSPATH is a system environment variable. For UNIX, you'll find it in the .agprofile file. For NetWare, you need to use the setenv command to set AGCLASSPATH (setenv AGCLASSPATH=path1;path2;path3;...).

For more information    For details, see the chapter on data source configuration in the Administrator's Guide.

 
Top of page

Setting up ODBC access

The application server can connect to Microsoft SQL Server using the ODBC driver supplied by Microsoft as part of the SQL Server client. There are different versions of this ODBC driver.

 
Top of section

Install the Microsoft SQL Server client

You must have the Microsoft SQL Server client software installed on the machine where the application server will be. Your client must be configured to connect to the destination SQL Server database.

 
Top of section

Create the ODBC System DSN entry

Configure an ODBC System DSN entry for the SilverMaster or deployment database.

Procedure To create the ODBC System DSN for a Version 7 or 2000 database:

  1. Add an entry using SQL Server as the driver type.

  2. Enter the server name for the target SQL Server.

  3. Enter the SQL Server user authentication information for the login you created and click Next.

  4. Select the proper default database name.

  5. Deselect Use ANSI quoted identifiers.

  6. Deselect Use ANSI nulls, paddings, and warnings and click Next.

  7. Accept the proper language and region settings, then click Finish.

 
Top of page

Using the database with the application server

Now you're ready to access the Microsoft SQL Server database from the application server. This enables you to do any of the following, as appropriate:

For more information    For more information, see the chapter on data source configuration in the Administrator's Guide.



Copyright © 2004 Novell, Inc. All rights reserved. Copyright © 1997, 1998, 1999, 2000, 2001, 2002, 2003 SilverStream Software, LLC. All rights reserved.  more ...