Configuring the Microsoft SQL Server 2005 Database when Installed on a Localized Operating System

Contents

The following instructions apply when using a Microsoft SQL Server 2005 database. If the Microsoft SQL Server database is localized or installed on a localized operating system, you must use the SET DATEFORMAT setting in the P6 Administrator application; otherwise, the user will encounter SQL errors when navigating in Resource Planning and Capacity Analysis. Odd behavior might also occur in the Activities view. To avoid these issues:

Note: Locate the Database folder and instance for the Microsoft SQL Server database used by P6.

1. Open the P6 Administrator application.
2. In the Configurations tab, expand your configuration.
3. Expand Database/Instance[n]/Session Settings.
4. Use the following syntax to add a Session Setting: set DATEFORMAT ymd
5. Click Save Changes.
6. Restart the application server. The change will take effect immediately.