Owner's Manual

74 Installing, Uninstalling, and Upgrading Dell OpenManage IT Assistant
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.
Deploying the IT Assistant Database to the Remote Database
On the management station, stop the IT Assistant Connection Service and
the IT Assistant Network Monitoring Service from the Service Control
Manager. This stops the IT Assistant services from accessing the local
IT Assistant database. Ensure that no other program is accessing the local
IT Assistant database. If a database program such as the SQL Server’s
Enterprise Manager and/or Query Analyzer is running, close the program or
ensure that the program is not accessing local IT Assistant database.
On the
management station , detach the IT Assistant database from the local
SQL Server by running the IT Assistant database management utility on the
command line.
Run the following command from the IT Assistant bin directory:
dcdbmng /r
When the IT Assistant database has been successfully detached, the
Detach database dialog box is displayed.