Owner's Manual

80 Installing, Uninstalling, and Upgrading Dell OpenManage IT Assistant

NOTE: The first argument @dbname specifies the name of the database and should

always be ITAssist. The second argument @physname specifies where the

database file is located and you should always use the correct location of file,

ITAssist_Data.mdf.

If there are several instances of the SQL Server on the remote database

system, then you can execute the above SQL statement and attach ITAssist

to any one instance of your SQL Server. However, it is recommended that

ITAssist be attached to the default instance of the local master database.

This can be viewed in the SQL Server group of the SQL Enterprise Manager.

All non-default instances of the SQL Server will have the instance name

attached to it. For this example, consider MYINST1 and MYINST2 as the

two non-default instances of the SQL Server. These SQL Server instances

will be: REMOTE_DB_SERVER\MYINST1 and

REMOTE_DB_SERVER\MYINST2. This can also be viewed in the

SQL Server group of the SQL Enterprise Manager. If the remote database

system’s SQL Enterprise Manager does not have a complete list of all the

SQL Server instances on the system, register these non-default instances so

that they are displayed in the SQL Server group.

Connecting IT Assistant to the Remote Database

On the management station, navigate to the IT Assistant installation

directory and edit the configuration file,

dconfig.ini

, by replacing each

(local)

string with the name of the SQL Server that resides on the

remote database system. You can find the string under the sections

[ITAssist_Odbc_Attributes] and [Master_Odbc_Attributes].

If the IT Assistant database resides in the default instance of the SQL

Server, IT Assistant database will be

. If the

IT Assistant database resides in a non-default instance of the SQL Server,

for example

MYINST1

, then the IT Assistant database will be

<name of

the database server>

\MYINST1. In other words,

Attribute3=Server,

-- in case of

default instance

Attribute3=Server,

\MYINST1 -- in case of

named instance