Member Avatar for danika21

Anybody have manage to install PeopleSoft HCM9.1 or other 9.1 module using SQL Server 2008 or R2 on Windows 7 OS on their laptop? If yes, please provide the steps and details specially input param for each steps. Also include installation of SQLServer and details including configuring Data Sourse/SYS DNS.

Thanks,

Danika

  • 2 Contributors
  • 2 Replies
  • 477 Views
  • 6 Days Discussion Span
  • Latest Post Latest Post by danika21

Dani AI

Generated

A concise, practical roadmap for (and thanks to for the pointer to PeopleSoft docs). Running PeopleSoft 9.1 against SQL Server 2008 on a laptop is possible for a sandbox, but it’s not lightweight — expect significant CPU/RAM/disk use and several server-level settings that must match PeopleTools expectations. If possible run the full stack in a VM so you can match supported server OSes and isolate configs. (docs.oracle.com)

Quick checklist (order matters)

  • Install SQL Server 2008/R2 (Developer or Express for a sandbox). Enable SQL Server + Windows (mixed) authentication and make sure TCP/IP is enabled (restart SQL service after changes). Create the PeopleSoft ACCESSID login and map appropriate DB roles. (flylib.com)
  • Prepare the PeopleSoft database using the delivered scripts or Database Configuration Wizard; set required DB options (ANSI nulls, Quoted Identifier, ARITHABORT) and choose the PeopleSoft-recommended collation. These options are required for the app and for computed/functional indexes. (docs.oracle.com)

PeopleTools / application tier essentials

  • Download the Microsoft SQL Server JDBC driver and place the required jars into PS_HOME\class (PeopleTools expects these files). Then configure the appserver/process-scheduler CLASSPATH entries (PSAPPSRV.CFG / PSPRCS.CFG) so the JVM can load them. (docs.oracle.com)

Example (PSAPPSRV.CFG edits)

; Microsoft SQL Server JDBC driver
Add to CLASSPATH=%PS_HOME%\class\mssbase.jar
Add to CLASSPATH=%PS_HOME%\class\mssqlserver.jar
Add to CLASSPATH=%PS_HOME%\class\msutil.jar

Developer-workstation notes and DSN gotcha

  • Application Designer/Data Mover (two‑tier) use client ODBC. On 64‑bit Windows you must create a 32‑bit System DSN with the 32‑bit ODBC admin (C:\Windows\SysWOW64\odbcad32.exe) if the PeopleTools client is 32‑bit. Missing this is a common source of “DSN not found / architecture mismatch” errors. (docs.oracle.com)

Troubleshooting tips

  • Check collation and ARITHABORT if DDL or index creation fails. Use SQL traces (PeopleTools TRACESQL options) to capture problematic SQL. Make sure SQL Browser/TCP ports and Windows Firewall rules permit connections when using named instances. If performance or resource limits appear, move to a VM with more RAM/disk. (docs.oracle.com)

This summary pulls the key PeopleTools/SQL Server gotchas together so a laptop install can be reproducible. For step-by-step PeopleTools installers, the PeopleTools installation and the “Administering PeopleSoft Databases on Microsoft SQL Server” appendix are the canonical references. (docs.oracle.com)

Recommended Answers

All 2 Replies

Member Avatar for JorgeM

That's a pretty specific request for help...in the meantimewhile others come across this thread..have you checked Peoplesoft's website for their install guide(s)?

Member Avatar for danika21

Yes but most of them are VM installations on Linux :)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.