Using basic capabilities > Overview of using basic capabilities > Creating and opening encyclopedias > SQL Server Express > Creating an SQL Express encyclopedia
  
Creating an SQL Express encyclopedia
System Architect enables you to create encyclopedias on SQL Express.
A connection must be established to create an encyclopedia. If there are no connections are available, see Creating a connection to create a connection.
For information on accessing the SQL Server Database Servers, see SQL Server and SQL Express encyclopedia access.
To create an encyclopedia on SQL express
1 In System Architect, click File > Open Encyclopedia (or click the Open Encyclopedia toolbar button).
2 In the Open Encyclopedia widow, click the New icon.
Optionally, you can check the Enterprise encyclopedia checkbox to subject the encyclopedia to access control as implemented through System Architect Catalog Manager utility. Checking on the Allow others to access this enterprise encyclopedia checkbox makes it accessible to other users.
3 Select an Connection and click OK.
4 In the New encyclopedia name field, type in the name of the encyclopedia that you want to create.
5 Click OK to create the encyclopedia. The System Architect Property Configuration displays. See Setting a project’s property configuration for additional information.
6 Select the methods and property sets that you will be initially modeling with in the encyclopedia. Click OK to close the dialog and create the encyclopedia.
SQL Server and SQL Express encyclopedia access
When you open an encyclopedia, you must first log onto the SQL Server or SQL Express servers which contains the encyclopedia you need to access. This is done through the Open Encyclopedia dialog (select File, Open Encyclopedia). For servers on a network, the Network Administrator might require that you use SQL Server authentication method or accept your Windows login credentials to grant you access to the server. Both the SQL Server and SQL Express servers use Microsoft SQL Server Service Manager, which is a Windows service that runs on your computer and works as the bridge between System Architect and the database server.
If you install and run SQL Express locally on your computer, the access options available to you are determined by the Windows version on your computer. For Windows 2000 Service Pack 4 and Windows XP computers, you can use their built-in Integrated Security methods.
System Architect enables you to create encyclopedias on SQL Server 2005 or SQL Server 2000.
Each user will require the following minimum set of rights to access an encyclopedia.
Execute on the following stored procedures:
CREATESNAPSHOT
GETHISTORYLOGGINGSTATUS
ENTITYEXISTSBYID
LOGENTITYHISTORYUPDATE
LOCKENTITYBYID
LOGFILESHISTORYUPDATE
GETNEXTID
PURGEHISTORY
GETFILESIZE
SAVEAUDITSETTING
DELETEBYID
SAVECHANGECONFIG
DELETEBYIDS
For SQL Server 2000: if you have not installed SQL Server 2000 SP4, you also need Execute on the extended stored procedure XP_UserLock. For more information on XP_UserLock, see:
http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B819829
This is granted to the user by the System Administrator through SQL Server 2000 Enterprise Manager.
Note A connection needs to be established in order to create an encyclopedia. If no connections are available, see Creating a connection.
Minimum access rights for SQL server 2005 and SQL express
There is a minimum set of rights needed to open a SQL Server 2005 encyclopedia. The security model for SQL Server 2005 limits access to the metadata stored in system tables. The encyclopedia schema checker needs access to this metadata in order for it to work properly.
Additional permission needed to view this data is called VIEW DEFINITION. The permission can be granted as follows:
GRANT VIEW DEFINITION TO <principal>
Where <principal> is one of the following entities:
User role or application role
User mapped to a Windows login, group, or certificate
User mapped to an asymmetric key
User not mapped to a server principal
SAEM has been updated to include this permission in the SAUser database role, any users added to this role will be able to open encyclopedias.
See also
SQL Server Express