How can I change path to SQL Server (from local to remote) in installed Windchill?

[atemnikov]

Hello,

Is there any tools to set another path to SQL Server (remote server) in already installed Windchill?

Thanks.

[BineshKumar1 · Accepted solution]

If you have already ported the database to a different SQL Server machine using database administration tools then it is all about updating the database related properties in WT_HOME/db/db.properties

Look for the below properties in there and update it using xconfmanager commands and restart your Windchill Instance. If you are using cognos, then you should export and import cognos db and update the content manager configuration as well.

• wt.pom.jdbc.database=
• wt.pom.jdbc.host=
• wt.pom.jdbc.port=
• wt.pom.jdbc.service=
• wt.pom.dbPassword=
• wt.pom.dbUser

Thank you,

Binesh

[atemnikov]

THank you!