If you use Microsoft SQL Server, you must set up a SQL Server database for each workspace repository you plan to create. If EA users connect to the repository through an SQL Server login account, ensure the server authentication property is set to SQL Server and Windows Authentication mode, as described below.
You can configure Enterprise Analyzer to build a workspace on one machine for a single user. You can use Microsoft PostgreSQL - installed by default - to create a workspace on your local machine. EA creates a database for the workspace "on the fly," with no intervention on your part. If you do use PostgreSQL, bear in mind that the Windows user who creates the workspace must have been configured with appropriate permissions in PostgreSQL. The user who installed PostgreSQL will always have the appropriate permissions. See the PostgreSQL documentation for configuration instructions.
collation