Solaris stand-alone: Modify SQL Server database properties

You must modify the approriate properties files before transferring data from the default database to the SQL database.


Prerequisites


Install SQL Server :

  1. Create backups:

    • WP_PROFILE/ConfigEngine/properties/wkplc.properties
    • WP_PROFILE/ConfigEngine/properties/wkplc_dbdomain.properties
    • WP_PROFILE/ConfigEngine/properties/wkplc_dbtype.properties

    • If you are transferring from a database other than Derby: WP_PROFILE/ConfigEngine/properties/wkplc_sourceDb.properties

      Default values are listed in these files. Unless otherwise noted, all values are of type alphanumeric text string. Print out the steps below for reference before modifying the properties files. Make sure to enter the appropriate values for each instance of each property. In wkplc_dbdomain.properties, most properties are repeated for each domain.

  2. Edit wkplc_dbdomain.properties

    1. For dbdomain.DbType, type sqlserver2005.

    2. dbdomain.DbName=domain_db_name

        This value is also the database element in the dbdomain.DbUrl property.

    3. dbdomain.DbSchema=domain_schema_name

    4. For dbdomain.DataSourceName, type the name of the data source that WebSphere Portal uses to communicate with its databases.

        Do not use the following reserved words:

          releaseDS
          communityDS
          customizationDS
          jcrDS
          lmdbDS

          feedback

    5. dbdomain.DbUrl=jdbc_db_url

        The database element of this value should match the value of DbName.

    6. dbdomain.DbUser = database configuration user.

    7. dbdomain.DbPassword = password for database configuration user.

    8. dbdomain.DbConfigRoleName = group for database configuration users

      Database rights are granted to this group instead of individuals. The user specified for dbdomain.DbUser must be assigned to this group.

    9. Optional. For dbdomain.DbRuntimeUser, type the user ID of the database user that should be used by WebSphere Portal to connect to the database at runtime. If no value is specified for this setting, the database configuration user will be used to connect to the databases at runtime.

    10. If dbdomain.DbRuntimeUser is specified, set dbdomain.DbRuntimePassword to be the password of the runtime database user.

    11. For dbdomain.DbRuntimeRoleName, type the name of the group for database runtime users

      Database rights are granted to this group instead of individuals. The user specified for dbdomain.DbRuntimeUser must be assigned to this group.

    12. Optional. For dbdomain.DBA.DbUser, type the database administrator user ID for privileged access operations during database creation. If not required, you can accept the default value or leave blank.

    13. Optional. For dbdomain.DBA.DbPassword, database administrator password for privileged access operations during database creation. If not required, you can accept the default value or leave blank.

    14. For dbdomain.DbHome, type the root location for the database.

        Location to store the database files locally.

    15. For dbdomain.AdminUrl, type the sqlserver URL without a database attached.

        This value is used to connect to the server for database administration operations.

    16. For dbdomain.DbHostName, type the hostname of the database.

  3. Save and close the file.

  4. Update the following properties in wkplc_dbtype.properties.

    1. For sqlserver2005.DbDriver, type the name of the JDBC driver class.

    2. For sqlserver2005.DbLibrary, type the directory and name of the .zip or .jar file that contains the JDBC driver class.

    3. For sqlserver2005.JdbcProviderName, type the name of the JDBC provider that WebSphere Portal uses to communicate with its databases.

    4. For sqlserver2005.DbConnectionPoolDataSource, type the name of the implementation class of the connection pool data source.

  5. Save and close the file.

  6. Update the WasPassword value in wkplc.properties. Password for the WAS security authentication used in environment.

  7. Save and close the file.


Parent

Set up a SQL Server database


Previous

Install SQL Server


Next topic

Create databases manually

 


+

Search Tips   |   Advanced Search