You need to create database user for seed data creation.
Note: If you select
Use an Existing MDM Database User option while setting up the SQL Server database in Configurator, the database user should be available.
Procedure
Login to the SQL Server Management Studio as a Super User.
Run the createUser.bat script from
$MQ_HOME/db/sqlserver/configure.
Where,
USERNAME is the database user name and
PASSWORD is password for the specified user name.
The database user is created.
To provide permission to the user for creating database, do the following:
Open the SQL Server Management Studio, select
super usernameSecurity > Logins.
Right-click
username and select
Properties. The Login Properties -
username window is displayed.
In the left panel, select
Server Roles. The server roles are displayed in the right panel.
In the Server Roles section, select the
sysadmin check box.
Click
OK.
The system administration server role is created. This server role can grant server-wide security privileges to a user.
Result
Also, specify the following parameters that are needed while installing TIBCO MDM:
