Honeywell Rapid Eye, Administrator'S Manual

Page: 183 / 294

Rapid Eye Multi-Media DVR System Administrator Guide
Document 800-02953V4 Rev A 183
03/10
Password Security
Passwords are encrypted in Multi db files (*.mdb and *.mdf).
Protecting the Database from Copying
It is important to protect your Multi db from copying, if only to avoid its use by unauthorized
users, who may also be licensed Multi software users.
SQL-Server Option
To add security to a Multi database, your SQL database administrator can setup a SQL
login just for Multi users. By default, Multi software connects to a SQL-Server by using sa
as a logon account, with no password.
SQL-Server Logon Reserved for Multi Operators
1. Run SQL Server Enterprise Manager.
2. Add a new log on.
3. The public and db_owner database roles need to be assigned to the log on, so that a
user can connect to the Multi db, update it and—if Multi SAs are to use Admin to
create a Multi db—create a new SQL-based Multi db.
TIP! Creating a SQL-server type of logon is a procedure for a SQL-Server administrator,
not for Admin users or View operators.
Result
When these changes are made to SQL-Server security, a
SQL Connection
login window
appears, as in Figure 10-1 . The Login and Password for SQL can differ from the User ID and
Password of a Multi account.
Figure 10-1 SQL-Server Login