To run the script on the local computer for Microsoft SQL Server, complete these steps:
- Verify that your user name has appropriate Windows and Microsoft SQL Server database permissions.
To
create the SOA Domain Management Server database
with Microsoft SQL Server,
the Authentication mode for the SQL server must be configured for
Mixed Mode (Windows Authentication
and SQL Server Authentication). When using Microsoft SQL Server Authentication, a
user that logs in to Microsoft SQL
Server must supply a user name and a password that Microsoft SQL Server validates against
a system table. With this security model, log in as a user that is
a member of the SQL Server sysadmin role group to
create the SOA Domain Management Server database.
- Open a command prompt window.
- Navigate to the ITM_Home\CNPS\Products\KD4\latest\bin directory.
For
information about resolving directory path variables, see Resolving directory path variables.
Verify that your user has read,
write, and execute permissions for this directory.
- Run the kd4MakeMSSQLdb.bat script by following
this syntax:
kd4MakeMSSQLdb dbname dbuser
dbpassword dbtype [dbInstance]
Where:
- dbname
- Specifies the SOA Domain Management Server database
name, for example, KD4SDMS. The name can have
a maximum of 128 characters.
Tip: If this database exists
on the local system, it is dropped and re-created. If you do not want
to drop an existing database, specify a different name.
- dbuser
- Specifies the Microsoft SQL
Server database server login name, for example, sdms. This
name can be any existing or non-existing user, except for the reserved
user name, sa. If the name that you specify does not exist,
it is created in the Microsoft SQL
Server registry. The user is granted the db_owner role for
the database.
- dbpassword
- Specifies the database password for the specified user dbuser.
- dbtype
- Specifies the version of your Microsoft SQL
Server installation. The only valid value is MSSQL2005.
Important: To specify a Microsoft SQL
Server 2008 installation, use MSSQL2005.
- dbInstance
- (Optional) Specifies a named instance of Microsoft SQL Server, in the form of database_hostname\instance_name.
The value database_hostname is the name of the
computer where the database server is installed. The value instance_name is
the instance name, for example, localhost\MyInstance.
If no value is specified, the default instance is assumed.
- Wait for the database creation process to complete.
The script
verifies the database version and displays a message if the version
is unsupported.
The output that is generated by this script
is written to a file called createMSSQLDBResults.txt in
the same directory where the script is run.
- Close the command prompt window.
For information about database and user permissions when creating
and configuring topology databases, see Database and User Permissions.