cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to modify database - SQL Server MDM Console

Former Member
0 Kudos

Hello:

I have a problem while creating a new MDM repository in my SQL Server instalation. The error is "unable to modify database". I tried writting the default DBMS Settings and without selecting this choice and the problem still.

Can anyone help me?

Thanks

Regards

Mario G

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Mario, are you able to mount repositories using the database username and password?

Former Member
0 Kudos

Mario,

This may be a authorization issue.

Does the user connecting to the Database in DBMS Settings have proper permissions.

Did you use the <b>sa</b> user and the right password?

Former Member
0 Kudos

Hello Adhappan:

Yes Im using sa user. All the authorizations are right. Ive already donde this before, this is the first time it fail.

Thanks

Regards

Mario G

Former Member
0 Kudos

Hi Mario,

Did you get any solution to your problem? I am also facing the same problem. Please let me know if you find some solution.

I am using the java code as below:

CreateRepositoryCommand createRepCmd =

new CreateRepositoryCommand(tutServices.pool);

createRepCmd.setDBMSUserName(dbmsUser);

createRepCmd.setDBMSUserPassword(dbmsPasswd);

createRepCmd.setPort(portNumber);

createRepCmd.setPartition(3);

createRepCmd.setSession(tutServices.serverSessionId);

createRepCmd.setRepositoryIdentifier(targetRepId);

try {

createRepCmd.execute();

System.out.println("Execution of CreateRepositoryCommand successful.");

} catch (CommandException e) {

System.out.println("Failed to execute the CreateRepositoryCommand");

e.printStackTrace();

}

Former Member
0 Kudos

Set Partitions to 1, 2, or 4.

-cleopatra