MACROMEDIA BREEZE Installation Manual - page 15
Setting Up the Breeze Database
Macromedia Breeze requires a database in order to store information about users, content, courses,
meetings, and reports. The database is created through either the Breeze database engine or Microsoft
SQL Server 2000. The Breeze database engine comes with Macromedia Breeze. You can install it at the
same time you install the Breeze Presentation platform.
Note: If you are using the Breeze Live stand-alone configuration, all references to the Breeze Presentation platform in
this chapter also apply to the Breeze application server.
The first time the Breeze Presentation platform runs, it creates the Breeze database. To create the database,
the Breeze Presentation platform uses information in the configuration file, custom.ini, and executes a
SQL script. The script creates the database and all the tables, indexes, and stored procedures that
Macromedia Breeze requires.
If you use the Breeze database engine, the Breeze Presentation platform can use the default values in the
custom.ini configuration file to create and set up the Breeze database. If you use Microsoft SQL Server
2000, you must set configuration properties in the custom.ini file, as described in the next section. To use
a database with Breeze, the database must be set to case insensitive.
Note: Generally, there is no need to change configuration settings for the Breeze database engine. However, if you
want to change any of the default settings for it, visit the following website for more information:
www.macromedia.com/go/breeze_licensed_support
.
Setting configuration properties for Microsoft SQL Server
2000
If you use Microsoft SQL Server 2000 for the Breeze database, you must set configuration properties in
the Breeze Presentation platform configuration file, custom.ini.
To set configuration properties for the Breeze database when you use Microsoft SQL Server 2000:
1
Before you start the Breeze Presentation platform, you must edit the Breeze configuration file. Select
Start > All Programs > Macromedia > Macromedia Breeze 4 > Configure Breeze.
2
Set properties in the Breeze configuration file, as listed in the following table:
To change the default password, which you should do to maintain security, and to see a complete list of
the configuration properties that must be set before you can use Macromedia Breeze, see
“Configuring the
Breeze Presentation Platform” on page 17
.
Changing the Breeze password
The password for the Breeze Presentation platform allows access to the Breeze database. For the integrity
of your system security, change the default password if you’re using the Breeze database.
Note: Microsoft SQL Server 2000 users usually already have a password that the database administrator has set.
To change the database password:
1
Open the command prompt window on the computer that is hosting the database and type
osql -U sa -P breeze -d breeze to log in to the Breeze database.
2
Enter the command for the new password, as shown in the following example:
sp_password @old=breeze, @new='NewPassword', @loginame = 'sa' go
For additional information about changing the password, see the Microsoft article, “How to Verify and
Change the MSDE System Administrator Password” at:
http://support.microsoft.com/
default.aspx?scid=kb;EN-US;322336#3
Property
Default value
Description
DB_HOST
localhost
The name of the Microsoft SQL Server 2000 host computer
DB_NAME
breeze
The name of the Breeze database
DB_USER
sa
The user name for the Breeze Presentation platform to use in creating
and accessing the database
DB_PASSWORD
breeze
The password for the Breeze Presentation platform to use in creating
and accessing the database. To change the password, see
“Changing
the Breeze password” on page 15
.