Owner's Manual

Installing, Uninstalling, and Upgrading Dell OpenManage ITAssistant 83
8 On the management station, open the IT Assistant user interface.
The IT Assistant services on management station are now ready to use the
IT Assistant database residing on the remote database system.
Configuring IT Assistant to Upgrade the Remote Database
IT Assistant does not upgrade the database which is configured on a remote
system. This section discusses the steps required to upgrade the IT Assistant
(version 7.0 and later) database.
Deploying IT Assistant Database to ITA_STATION
1 On the ITA_STATION, stop IT Assistant Connection Service and
IT Assistant Network Monitoring Service from the Service Control
Manager. This stops IT Assistant services from accessing the remote
IT Assistant database. Also, make sure that no other program is accessing
the IT Assistant database, ITAssist, of REMOTE_DB_SERVER. If a
database program such as SQL Server’s Enterprise Manager and/or Query
Analyzer is running, close the program or ensure that the program is not
accessing the IT Assistant database named ITAssist.
2 On the REMOTE_DB_SERVER, detach the IT Assistant database from
the local SQL Server by executing the following SQL statement against
local master database:
exec sp_detach_db @dbname=’ITAssist’
3
To ensure that the database is detached, go to ITA_STATION system,
start ODBC Data Source Administrator from
Start  Settings  Control
Panel
 Administrative Tools  Data Sources (ODBC) . Click the System
DSN
tab. Ensure that there is no system data source with the name
ITAssist. If there is, remove that data source by clicking on the
Remove
tab.
4 On the REMOTE_DB_SERVER, navigate to the Data folder under
MSDE or SQL Server installed location. By default this is
C:\Program
Files\Microsoft SQL Server\MSSQL
. Copy the IT Assistant database file,
ITAssist_Data.mdf to the desired path on the ITA_STATION. For this
example, let us consider the desired path to be DB_PATH.
5 On ITA_STATION, attach the database file, ITAssist_Data.mdf located in
DB_PATH to the local SQL Server. This can be done by executing the
following SQL statement against the local master database: