This is from a document I have on performing this procedure. I've nowhere to host the document, so I'm putting the guts of it here for you.
I HAVE NOT TRIED THIS AND DON'T KNOW IF IT WORKS - SO BE CAREFUL
DB_Server refers to the remote SQL database server.
ITA_STATION refers to the system ITA is installed on.
Prior to making the changes that allow for the use of a remote database as the ITA database, the following must be in place:
On the ITA_STATION Start SQL Server service. Ensure that the SQL Server service is running by starting the MSSQLServer service in the Service Control Manager. SQL Server Service Manager on the system tray or in the SQL Server’s program group can also be used to start the service.
On the DB_SERVER Ensure that SQL Server on the DB_Server uses same authentication as that used on SQL Server on ITA_STATION. Since ITA services log onto SQL Server using NT Authentication, make sure that both the ITA_STATION and the DB_SERVER use the same authentication with Administrator rights, are logged in with the same account, and that the SQL Server databases on both servers are configured to use this account. In this example, assume the username is “administrator” on both servers with identical passwords, and that both systems reside in the same NT domain.
Start SQL Server service. Ensure that SQL Server service is running by starting the MSSQLServer service in the Service Control Manager. SQL Server Service Manager on the system tray or started from SQL Server’s program group from the start menu can also be used to start the service.
Deploy the ITA Database to DB_SERVER On the ITA_STATION, stop IT Assistant Connection Service and IT Assistant Network Monitoring Service in the Service Control Manager. This stops ITA services from accessing local ITA database. Also, make sure that no other program is accessing the local ITA database named ITAssist. If a database program such as SQL Server’s Enterprise Manager and/or Query Analyzer is running, stop the program or ensure that the program is not accessing local ITA database called ITAssist.
On the ITA_STATION, detach the ITA database from local SQL Server by running command line “dcdbmng /r” from the ITA bin directory
To ensure that the database is detached, start ODBC Data Source Administrator from the Control Panel and go to the System DSN tab. There should not be a system data source with name ITAssist. If there is, remove that data source.
On the ITA_STATION, navigate to the ITA database directory, copy the ITA database file ITAssist.mdf to the desired location on DB_SERVER (called DB_PATH in this example).
On DB_SERVER, attach the database file ITAssist.mdf to the local SQL Server. This can be done by executing the following SQL statement against the master database:
First argument @dbname specifies name of the database and should be kept as ITAssist. Second argument @physname specifies where the database file is located and user should customize it to reflect the correct location of file ITAssist.mdf.
At this point, the SQL Server on DB_SERVER has a copy of the ITA database that resides on ITA_STATION. ITA, however, is not yet aware of that SQL Server database. The next steps establish the ITA connection to the remote SQL Server database
On the ITA_STATION, navigate to the configuration directory under where ITA is installed. Edit the configuration file dconfig.ini, replacing each string that says “(local)” with name of the SQL Server that sits on DB_SERVER
• On the ITA_STATION, change the ITA services logon credentials from using the Local System account to the account used to log onto local SQL Server. In this case, it is the local Administrator account
• This operation needs to be done for both the Connection Service and Network Monitoring Service. To bring up the dialogue box, right-click on the service from the Service Control Manager (Windows services) and select Properties.
*** This next step is optional. It releases ITA services from requiring SQL Server service running locally, which makes SQL Server not required on the ITA_STATION. During ITA installation, ITA’s Network Monitoring Service is created to depend on SNMP Service and SQL Server’s MSSQLServer Service; Connection Service is created to depend on Network Monitoring Service and, in turn, depends on MSSQLServer Service. Such dependencies can be removed by editing the registry on ITA_STATION. Note: before editing the registry, make sure you save a copy of the registry and understand how to restore it if a problem occurs.
• On ITA_STATION, using Windows’ Registry Editor, navigate to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\DcNetMon. Double click on value DependOnService to edit its data. Since this registry value is a UNICODE multiple string, its initial value data is “SNMP MSSQLServer” . Remove “MSSQLServer” to make the value data: 0000 53 00 4E 00 4D 00 50 00 S.N.M.P. 0008 00 00 00 00
Save the change and close Registry Editor.
Check the dependencies of the Network Monitoring Service on ITA_STATION by right-clicking on the service and select Properties to bring up the dialogue box shown in Figure 14. The service should now only depend on the SNMP Service. Restart ITA_STATION to let this change take effect
After this is completed, SQL Server’s MSSQLServer Service is no longer required on ITA_STATION. The SQL Server service can be stopped, or the SQL Server program (MSDE 1.0, SQL Server 7.0 or 2000) can even be removed from ITA_STATION if there are no other programs depending on it.
• On ITA_STATION, start IT Assistant Connection Service and IT Assistant Network Monitoring Service in the Service Control Manager. ITA should now begin to access the ITA SQL Server database deployed on DB_SERVER. Note: if the ITA services dependency on the local SQL Server service has not been removed as described in previous step, SQL Server service on ITA_STATION needs to be running for ITA services to be started, even though that SQL Server database is not actually used by ITA. To verify that the ITA database is successfully connected, start ODBC Data Source Administrator from the Control Panel on the ITA_STATION and go to the System DSN tab. There should be a system data source named ITAssist
• Open the ITAuser interface that is installed locally, or from a different system [1] and connect to ITA’s Connection Service on ITA_STATION.
This completes the steps necessary to have ITA services on ITA_STATION use the ITA database residing on DB_SERVER
MikePalmer
1 Rookie
•
31 Posts
0
December 4th, 2003 14:00
Can anyone from Dell answer my question about dconfig.ini?
Mike
Nervion
20 Posts
0
December 5th, 2003 11:00
And then, don't you know it, I found the whole document, including pictures on the Dell website mentioned in another thread...
<ADMIN NOTE: Broken link has been removed / replaced from this post by Dell>
DOH!
Nervion
20 Posts
0
December 5th, 2003 11:00
PART 1 OF 2
This is from a document I have on performing this procedure. I've nowhere to host the document, so I'm putting the guts of it here for you.
I HAVE NOT TRIED THIS AND DON'T KNOW IF IT WORKS - SO BE CAREFUL
DB_Server refers to the remote SQL database server.
ITA_STATION refers to the system ITA is installed on.
Prior to making the changes that allow for the use of a remote database as the ITA database, the following must be in place:
On the ITA_STATION
Start SQL Server service.
Ensure that the SQL Server service is running by starting the MSSQLServer service in the Service Control Manager. SQL Server Service Manager on the system tray or in the SQL Server’s program group can also be used to start the service.
On the DB_SERVER
Ensure that SQL Server on the DB_Server uses same authentication as that used on SQL Server on ITA_STATION.
Since ITA services log onto SQL Server using NT Authentication, make sure that both the ITA_STATION and the DB_SERVER use the same authentication with Administrator rights, are logged in with the same account, and that the SQL Server databases on both servers are configured to use this account. In this example, assume the username is “administrator” on both servers with identical passwords, and that both systems reside in the same NT domain.
Start SQL Server service.
Ensure that SQL Server service is running by starting the MSSQLServer service in the Service Control Manager. SQL Server Service Manager on the system tray or started from SQL Server’s program group from the start menu can also be used to start the service.
On the ITA_STATION, stop IT Assistant Connection Service and IT Assistant Network Monitoring Service in the Service Control Manager. This stops ITA services from accessing local ITA database. Also, make sure that no other program is accessing the local ITA database named ITAssist. If a database program such as SQL Server’s Enterprise Manager and/or Query Analyzer is running, stop the program or ensure that the program is not accessing local ITA database called ITAssist.
On the ITA_STATION, detach the ITA database from local SQL Server by running command line “dcdbmng /r” from the ITA bin directory
exec sp_attach_single_file_db @dbname='ITAssist',@physname='DB_PATH\ITAssist.mdf'
First argument @dbname specifies name of the database and should be kept as ITAssist. Second argument @physname specifies where the database file is located and user should customize it to reflect the correct location of file ITAssist.mdf.
At this point, the SQL Server on DB_SERVER has a copy of the ITA database that resides on ITA_STATION. ITA, however, is not yet aware of that SQL Server database. The next steps establish the ITA connection to the remote SQL Server database
Nervion
20 Posts
0
December 5th, 2003 11:00
PART 2 OF 2
Connecting ITA to Database on DB_SERVER
On the ITA_STATION, navigate to the configuration directory under where ITA is installed. Edit the configuration file dconfig.ini, replacing each string that says “(local)” with name of the SQL Server that sits on DB_SERVER
• On the ITA_STATION, change the ITA services logon credentials from using the Local System account to the account used to log onto local SQL Server. In this case, it is the local Administrator account
• This operation needs to be done for both the Connection Service and Network Monitoring Service. To bring up the dialogue box, right-click on the service from the Service Control Manager (Windows services) and select Properties.
*** This next step is optional. It releases ITA services from requiring SQL Server service running locally, which makes SQL Server not required on the ITA_STATION.
During ITA installation, ITA’s Network Monitoring Service is created to depend on SNMP Service and SQL Server’s MSSQLServer Service; Connection Service is created to depend on Network Monitoring Service and, in turn, depends on MSSQLServer Service. Such dependencies can be removed by editing the registry on ITA_STATION.
Note: before editing the registry, make sure you save a copy of the registry and understand how to restore it if a problem occurs.
• On ITA_STATION, using Windows’ Registry Editor, navigate to
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\DcNetMon.
Double click on value DependOnService to edit its data. Since this registry value is a UNICODE multiple string, its initial value data is “SNMP MSSQLServer” . Remove “MSSQLServer” to make the value data:
0000 53 00 4E 00 4D 00 50 00 S.N.M.P.
0008 00 00 00 00
Save the change and close Registry Editor.
Check the dependencies of the Network Monitoring Service on ITA_STATION by right-clicking on the service and select Properties to bring up the dialogue box shown in Figure 14. The service should now only depend on the SNMP Service. Restart ITA_STATION to let this change take effect
After this is completed, SQL Server’s MSSQLServer Service is no longer required on ITA_STATION. The SQL Server service can be stopped, or the SQL Server program (MSDE 1.0, SQL Server 7.0 or 2000) can even be removed from ITA_STATION if there are no other programs depending on it.
• On ITA_STATION, start IT Assistant Connection Service and IT Assistant Network Monitoring Service in the Service Control Manager. ITA should now begin to access the ITA SQL Server database deployed on DB_SERVER.
Note: if the ITA services dependency on the local SQL Server service has not been removed as described in previous step, SQL Server service on ITA_STATION needs to be running for ITA services to be started, even though that SQL Server database is not actually used by ITA.
To verify that the ITA database is successfully connected, start ODBC Data Source Administrator from the Control Panel on the ITA_STATION and go to the System DSN tab. There should be a system data source named ITAssist
• Open the ITAuser interface that is installed locally, or from a different system [1] and connect to ITA’s Connection Service on ITA_STATION.
This completes the steps necessary to have ITA services on ITA_STATION use the ITA database residing on DB_SERVER
GOOD LUCK