Move SQL Server host

[Former Member]

Hello,

we would like to migrate the database from one machine (the web as box) to another for the WebAS 6.4.

Everything points to modifying the DEFAULT.PFL file. The question is how do I apply a SQL password ? These are currently the properties available in this context and I cannot find any hint on a password that needs to be provided when logging on to a remote SQL server:

dbms/type = mss

dbs/mss/server = currenthostname

dbs/mss/schema = eb5

dbs/mss/dbname = EB5

Any help is welcome.... Thx, Jochen

[Former Member]

Hi,

Please refer the notes 683447 and 151603

regards

Anand.M

[Former Member]

Hi,

I am not totally sure about the way to do this.

If you are running a Java-only system you'll surely need to change the SecureStore parameters since they contain JDBC Url string, user and password (use configtool) and probably SDM configuration (Find some information in <central instance dir>\SDM\program\doc).

Best regards, Dido