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 will connect to the repository through a SQL Server login account, make sure the server authentication property is set to SQL Server and Windows Authentication mode, as described below.
The following instructions assume you are using the SQL Server Management Studio tool for SQL Server 2008. The procedure for the SQL Server Management Studio Express tool for SQL Server 2005 is similar.
You can configure Enterprise Analyzer to build a workspace on one machine for a single user. You can use Microsoft SQL Server Express - 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 SQL Server Express, bear in mind that the Windows user who creates the workspace must have been configured with appropriate permissions in SQL Server Express. The user who installed SQL Server Express will always have the appropriate permissions. See the SQL Server Express documentation for configuration instructions.