Owner's Manual

86 Installing, Uninstalling, and Upgrading Dell OpenManage IT Assistant
Deploying IT Assistant Database to ITA_STATION
To deploy the IT Assistant Database to the 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.