Hello,
I am trying to plan an installation of PAM 4.1 in a SQL 2008 R2 Windows environment.
Referecing the section "CA Process Automation Installation Database Configuration" of this article, the Database Team at my organisation have asked me if the Database Collation setting of SQL_Latin1_General_CP1_CI_AS has to be set at the instance level, or can just be set on the database.
Anyone know the answer to this?
Thanks
Stuart
I am trying to plan an installation of PAM 4.1 in a SQL 2008 R2 Windows environment.
Referecing the section "CA Process Automation Installation Database Configuration" of this article, the Database Team at my organisation have asked me if the Database Collation setting of SQL_Latin1_General_CP1_CI_AS has to be set at the instance level, or can just be set on the database.
Anyone know the answer to this?
Thanks
Stuart
Stuart_ Apr 2, 2013 4:14 AM
Correct Answer
It is recommended to set the database collation setting at the instance level.
See the reply in context