We are unable to connect our application server and database servers for a new install

[ptc-3006345]

Our installation worked on astand-alone server (SQL and application housed on one machine). That installation worked as designed and without error. The program worked, the database, application, everything went fine.

We then took that server and snapshot it to the point in time, we went back to the original configuration and installed the application on one server, the database on another server and then tried to operate the application. That installation failed and the method server would not start. The server would not connect to the database server which caused the method server to fail startup. We went through the entire “application rights” process and allowed the account the appropriate rights level, the SQL database side as well was checked for any roadblocks in security and we found none.

Any thoughts??

Thanks,

[RajeshBalasunda]

Have you edited the db properties file using xconfmanager to point to
the new database server or is it still pointing to the old location?



Best Regards

Rajesh Balasundaram

[patrick.chin1]

Your snap shot better include the following:

• backup of the Windchill LDAP directory root (Aphelion or Directory Server)
• vaults
• Windchill/tmp
• oracle dump/tablespaces of pdmlink schema and cognos schema

You may have issues if you don't have these in sync. You should really look at the latest rehost guide. But, always be becareful not to leave anything point to the original sources including your:

• site.xconf
• cognos applcation - cognos database user name and password
• mirrored database tables:
  • site
  • fvhost
  • fvmount
  • repository
• ownership of the files you copied:
  • Windchill/tmp
  • Windchill/vaults
• changing the host names in the root export LDAP and reinporting to the target

Good luck,

Patrick

[ptc-3006345]

We are connecting to a MSSQL server.

Thanks,
Jeremy