Changing External DB user, password, dbhost (MSSQL machine) or authentication method (domain)

QUESTION
How can external DB information be modified while connected to the Safend Server.

ANSWER
In order to change the account or only some of the credentials:
1. Stop the Safend services – Local, Domain (and Broadcast if version 3.2 is used).
2. In cmd, run the following:

[Path to SPAdmin]\SPAdmin.exe -dbinfoview [Path to dbinfo]\dbinfo.xml =

* SPAdmin.exe and dbinfo.xml can be found by default under Program Files\Safend\Safend Protector\Management Server\bin
** See specific list of parameters below

3. Restart the Safend services and run “IISRESET”

NOTES:

1. SPAdmin utility cannot change more than one parameter simultaneously, which means that it should be executed a few times – once for each parameter.

2. The password must always be the last parameter to be changed, since when specifying the new password SPadmin tries to connect to the DB using the existing user name and domain (specified in dbinfo.xml) and the new password.

3. Backup the dbinfo.xml before going to the next steps

4. Changing the Domain:
SPAdmin.exe /dbinfoview dbinfo.xml domain=Mydomain

5. Changing the user:
SPAdmin.exe -dbinfoview dbinfo.xml user=MyUser

6. Changing the password:
SPAdmin.exe -dbinfoview dbinfo.xml password=MyPassword

*There is no problem changing from a domain user to an SQL user (or vice-versa).
In order to specify an SQL user, keep the domain name blank, otherwise insert the relevant domain name.

7. Changing the dbhost:
This should be perfromed when migrating the MSSQL server to another machine. In this case, the SafendProtector schema should be duplicated as is (including users and their authorizations), and the dbinfo should be modified accordingly:
SPAdmin.exe -dbinfoview dbinfo.xml dbhost=NewMachine

(Quelle: Safend KB00000253 – Changing External DB user, password, dbhost (MSSQL machine) or authentication method (domain))

• Delicious