User's Manual

52 Install PC - Step 1f - Database Engine

• Microsoft SQL Server 2005 Express and Microsoft Access 2000 typically

reside on the Messenger PC, and are likely to be always available. The

availability of the database engine is a concern because Messenger requires

24/24 7/7 uptime of its embedded database.

• The Access model is not recommended because it is not scalable. The

Access model can only handle low or moderate workload.

•

Microsoft SQL Server 2005 Express is a good option for most environments.

Although a Microsoft restricted the engine, the Microsoft SQL Server 2005

Express is suitable to handle typical workload conditions, and does not

require a license fee.

• The SQL Server flavours that are unrestricted require a license. An

SQL server is an option if the customer environment already has such

infrastructure and can guarantee the uptime.

Microsoft Access 2000

The Microsoft Access 2000 database (Messenger_DATA.mdb) is installed

automatically, so you can skip this chapter.

Microsoft SQL Server 2000 and Microsoft SQL Server 2005

Before you start

Before you proceed with the installation of Microsoft SQL Server 2000 or

Microsoft SQL Server 2005, restore the SQL Server 2000 engine or SQL

Server 2005 engine. Install the Enterprise Manager utility as part of the

SQL Server 2000 engine or the SQL Server 2005 engine.

Nortel recommends that you install the latest SQL Server service

pack prior to continuing. Refer to the Microsoft web site at

ww.microsoft.com for more information on the SQL Server service pack

Before you continue, acquire the following information:

•

User ID, for example, sa.

• Password associated with that user ID, for example, sa.

•

Service instance name, for example (local), GNTN1SFMI, and so on.

Note: In many cases, there is one service instance only for SQL

Server, such as (local) – and you can address this default instance by

means of the 127.0.0.1; reference.

Setting up Microsoft SQL Server 2000 or Microsoft SQL Server 2005

Verify that SQL Server Enterprise Manager is available on either the SQL

Server, or on a networked administration PC.

Nortel Communication Server 1000

DECT Messenger Installation and Commissioning — Book 1

NN43120-301 02.01 4 June 2010