Skip to main content
Delphix

Changing a dSource User Type from 'Domain User with Password Credential' (KBA8362)

 

KBA

KBA# 8362

Applicable Delphix Versions

Click here to view the versions of the Delphix engine to which this article applies
Major Release All Sub Releases
6.0

6.0.0.0, 6.0.1.0, 6.0.1.1, 6.0.2.0, 6.0.2.1, 6.0.3.0, 6.0.3.1, 6.0.4.0, 6.0.4.1, 6.0.4.2, 6.0.5.0, 6.0.6.0, 6.0.6.1, 6.0.7.0, 6.0.8.0, 6.0.8.1, 6.0.9.0, 6.0.10.0, 6.0.10.1

5.3

5.3.0.0, 5.3.0.1, 5.3.0.2, 5.3.0.3, 5.3.1.0, 5.3.1.1, 5.3.1.2, 5.3.2.0, 5.3.3.0, 5.3.3.1, 5.3.4.0, 5.3.5.0, 5.3.6.0, 5.3.7.0, 5.3.7.1, 5.3.8.0, 5.3.8.1, 5.3.9.0

5.2

5.2.2.0, 5.2.2.1, 5.2.3.0, 5.2.4.0, 5.2.5.0, 5.2.5.1, 5.2.6.0, 5.2.6.1

5.1

5.1.0.0, 5.1.1.0, 5.1.2.0, 5.1.3.0, 5.1.4.0, 5.1.5.0, 5.1.5.1, 5.1.6.0, 5.1.7.0, 5.1.8.0, 5.1.8.1, 5.1.9.0, 5.1.10.0

5.0

5.0.1.0, 5.0.1.1, 5.0.2.0, 5.0.2.1, 5.0.2.2, 5.0.2.3, 5.0.3.0, 5.0.3.1, 5.0.4.0, 5.0.4.1, 5.0.5.0, 5.0.5.1, 5.0.5.2, 5.0.5.3, 5.0.5.4

How to Change dSource User Type from a 'Domain User with Password Credential'

If an MSSQL dSource is currently set with a "Domain User with Password Credential" user type, it is not possible to set the user type to an Environment User through the graphical user interface (GUI).

This can be checked through the GUI, by clicking the pencil icon of the Database section of the source configuration of a dSource.

clipboard_efcc93515403829fee583dd44c9143fe1.png

After clicking the pencil icon, you will see that the credential type is not supported by the GUI.                                                                                                                                                                                                                 

clipboard_eeab2b66bea5314e99cd0322f7378305c.png

To Change dSource User Type from 'Domain User with Password Credential' to Environment User

  1. Connect to the engine via ssh.
ssh <admin-user>@<engine-hostname>
  1. Switch to the sourceconfig section.
engine-hostname> sourceconfig
  1. Select the sourceconfig for the dSource. 
engine-hostname sourceconfig> select test_ag/testSource
  1. Start an update.
engine-hostname sourceconfig 'test_ag/testSource'> update
  1. Set the user type to environment user.
engine-hostname sourceconfig 'test_ag/testSource' update *> set mssqlUser.type=MSSqlEnvironmentUser
  1. Set the correct environment user.
engine-hostname sourceconfig 'test_ag/testSource' update *> set mssqlUser.user=live.test-environment.example.com/test_domain\test_user
  1. Commit the change.
engine-hostname sourceconfig 'test_ag/testSource' update *> commit

Related Articles

The following articles may provide more information or related information to this article: