If this is a new installation, the next step is to set up a database (also known as a repository).
The terms “database” and “repository” are sometimes used interchangeably, but generally a repository is defined as a central place in which an aggregation of data is kept and maintained. The conceptual model for SilkCentral is that of a data repository that contains the Issue Manager, and Test Manager data.
A repository is a database used by SilkCentral products to store, maintain, and analyze data. You must first choose which database system you want to use for your repository and take the necessary steps in the SilkCentral GUI to access the repository. You must have a repository to work with SilkCentral products. For information on the supported databases, refer to the Release Notes.
You may set up multiple repositories, though only one repository at a time may be active.
Creating a repository
Procedure To create a new repository:
1 Once you have specified the location of the application server, you will be presented with the Administration/System/Database dialog.
Alternative Browse to your SilkCentral site with a Web browser (default URL is http://<computer name><port>/login).
Alternative When you use the Standard Setup option for installing SilkCentral, the Administration/System/Database page appears immediately after you connect to the application.
Alternative Select Start/Programs/Silk/SilkCentral/Test Manager/Test Manager Home Page.
2 If not already logged in, log in (‘admin’ is the default value for both the username and the password). Select Administration > System > Database.
3 Enter the information for the new database, then click Connect.
You can create a database on the locally installed MSDE (Microsoft SQL Server Desktop Engine), a locally installed MS SQL Server / Oracle installation, or on a network server that has MS SQL Server / Oracle installed
To create a local MSDE database, enter:
DBMS-hostname
or IPaddress: <computer name>\borland
DBMS type: MSSQL Server
Port: 1433
Database / SID: <enter a name for the new database>
User: sa
Password: sa
Read-only User (optional): <name of your choice>
Read-only Password (optional): <password of your choice>
The read-only user is an optional database user with read-only rights on all tables and views in the specified database (defining a read-only user enhances database security). SilkCentral automatically creates this user if you specify a name and password.
Note If you installed Issue Manager using the evaluation setup package, or if you installed the MSDE included in the setup package, the MSDE (SQL Server) instance is localhost\borland and the default user is "sa" and the password is "sa".
To create a database on a local or network MS SQL Server, enter:
DBMS-hostname
or IPaddress: <computer name>
DBMS type: MSSQL Server
Port: 1433
Database / SID: <enter a name for the new database>
User: sa
Password:
Read-only User (optional): <name of your choice>
Read-only Password (optional): <password of your choice>
The read-only user is an optional database user with read-only rights on all tables and views in the specified database (defining a read-only user enhances database security). SilkCentral automatically creates this user if you specify a name and password.
Note If you installed the Evaluation version of Issue Manager, you should login as user ‘sa’ (with no password) when creating a local MSDE database.
Note Username “sa” with no password is the default administrator login for MSSQL Server databases. In most environments, the Database Administrator changes this login after installation for security purposes. If you can not log in, ask your database administrator for the current administrator login.
To create a database on a local or network Oracle Server, enter:
DBMS-hostname
or IP address: <computer name>
DBMS type: Oracle
Port: 1521
Database / SID: <Oracle SID given by your Oracle administrator>
User: <Database user given by your Oracle administrator>
Password: <User password given by your Oracle administrator>
Read-only User (optional): <Database user given by your Oracle
administrator>
Read-only Password (optional): <User password given by your Oracle
administrator>
The read-only user is an optional database user with read-only rights on all tables and views in the specified database (defining a read-only user enhances database security).
Note For Oracle database administrators: It is important that the Oracle SID is configured to use the UTF8 character set.
4 The Create database dialog appears. To create a new database, you must log in as a system administrator:
If you are creating a local MSDE database, type ‘sa’ in both the Username and Password text boxes, then click OK.
If you are creating a local or network MS-SQL Server/Oracle database, enter the login information provided to you by your database administrator, then click OK.
Note This process can take up to a few minutes.
5 A Messages dialog may appear, informing you of servers that were found on the local computer and have automatically been added to the system configuration. Confirm this dialog by clicking OK.
Note If you receive a warning message stating “Couldn't define localhost as Execution Server“, you need to configure your execution servers manually. See the “Setting Up Execution Servers” section of Chapter 2, Application Configuration in the SilkCentral Administration Guide. for detailed information about configuring locations and execution servers.
6 You will be notified that the repository has been created successfully. Confirm the message by clicking OK.
7 The login page appears. Log in using your standard username and password (the default is admin/admin). Do not log in as a database administrator.
Note Information about the currently connected database is displayed on the Database Administration page, but other available databases are not displayed anywhere in the Issue Manager user interface. You must make a note of the database name for future reference.
8 Your system is now ready for use. Proceed with “Logging in for the First Time”.