2.2. Microsoft SQL Server 2005/2008
There are many different editions of the Microsoft SQL Server 2005
and 2008 database servers including their Express editions which are free
to use. The following are instructions for Microsoft SQL Server 2008
Express Edition. Settings for other editions will be similar. Please
contact your database administrator in case you have any questions. But in
essense, we have to create a database and a database user who has all
rights on that database.
To create a database user and database, open SQL Server
Management Studio and login as sa (the
database administrator user).
To create a database user :
Right click on the Security node and click
→
Enter login name as celoxis
Choose SQL server authentication
Enter a password. Note the username and password down
as you will be asked for this later during
installation.
Uncheck the Enforce password policy
Click OK
To create a database :
Right click on the Database node and click
New Database...
Enter the same database name as specified in your license
request
Select celoxis as the owner
Choose SQL_Latin1_General_CP1_CI_AS as the
Collation (available from the Options page on the
left)
Click OK