Owner's Manual

78 Installing, Uninstalling, and Upgrading Dell OpenManage IT Assistant
Remote Microsoft SQL Server and IT Assistant
This section describes how to configure IT Assistant version 8.4 and later,
to use Microsoft SQL Server 2005 SP2 running on a remote server as the
IT Assistant database.
Configuring IT Assistant to Use a Remote Database
IT Assistant ships with the SQL Server-compliant default database—SQL
Server 2005 Express Edition SP2. The IT Assistant Network Monitoring Service
and the IT Assistant Connection Service access the SQL Server-compliant
default database—SQL Server 2005 Express Edition SP2 that ships with
IT Assistant.
When the database resides outside the IT Assistant management station,
as in the case of a remote database, it is necessary to make the IT Assistant
Network Monitoring Service and the IT Assistant Connection Service on the
management station to access the remote database.
To do this, ensure that:
• The SQL Server service (MSSQLServer) is running through the service
control panel on the management station as well as the remote database.
You can start the SQL Server 2005 SP2 services either through the SQL
Server Service Manager on the system tray or through the SQL Server
Enterprise Manager’s SQL Server group.
• The SQL Server-compliant database versions on management station and
the remote database are the same.
• SQL Server 2005 SP2 uses the same authentication that is used on the
SQL Server 2005 Express
Edition SP2 on the management station.
• The management station and the remote database use the same
authentication with Administrator rights, are logged in with the same
account, and that the SQL Server databases on both systems are
configured to use this account. This is because IT Assistant services
accesses SQL Server 2005 Express
Edition SP2 using the Windows NT
Authentication.
In this example, let us assume that the user name is administrator on both
servers with identical passwords and that both systems reside in the same
NT domain.