View source for Changing the SwSQL Account Password

{{Template:Basic Cover
|title=Changing the SwSQL Account Password
|type=FAQ
|htl=Y
}}

{{Template:Basic Status
|status=Draft
|version=1.1
|authors=HTL QA
|applicableto=Supportworks ESP Version 6.0 (Server Build 2215) and higher
}}

== Changing the SwSQL Account Password ==

A backup of the Supportworks installation is recommended before making the changes listed below.

The SwSQL database account, whose  user ID is "root" by default, is the one used by the Supportworks server  to connect to the database. It is also the account used by third-party applications or scripts (if any), as well as by some Custom HTML reports, for their own database connections.

This  document first takes you through the steps required to change the SwSQL  account password itself (which is blank by default). You are then given instructions on how to correspondingly change the password settings as configured in Supportworks and in the DSNs  that each of the connecting entities uses. These latter instructions differ according to whether or not the version of Supportworks ESP is 7.5.0 or above. Finally, you are given instructions on how to make the Hornbill Interactive SQL utility issue a prompt for credentials if there is currently no password set.

For the purposes of this document, it is assumed that both the application database and the system databases are accessed using the one account (whether directly or via ODBC), and that its user ID  remains as "root".

=== Stage 1: Changing the Password of the Account ===

To change the account password on the database itself, the procedure is as follows:

# Ensure that all users are logged out of Supportworks.
#  Run the Supportworks Server Configuration utility by selecting Start  > Programs > Supportworks Server > Supportworks Server  Configuration.
# On the Server tab, under Installed Services and starting at the top, stop all services.
# On the Database tab, check to confirm that the User ID is "root".
# Run the Interactive SQL utility by selecting Start > Programs > Hornbill Core Services > Interactive SQL.
# Enter the following SQL statements:
#:: <tt>use mysql;</tt>
#:: <tt>update user set password=password(<nowiki>'</nowiki>''new-password''<nowiki>'</nowiki>) where User = 'root';</tt>
#:: <tt>flush privileges;</tt>
#:: <tt>exit;</tt>

=== Stage 2: Changing the Password Settings Elsewhere ===

To allow entities such as Supportworks to now connect to the database using the new password, follow the instructions given in either of the two sections below, depending on your version of Supportworks.

==== For Supportworks ESP Version 7.4.1 and Below ====

# On the Database tab of the Supportworks Server Configuration utility, enter the new password in the Password field. This setting is for fallback ODBC access to the application database.
# In the administrative section of Windows Control Panel, run the Data Sources (ODBC) tool and select the System DSN tab.
#  For each relevant DSN shown on the list (for example, Supportworks Data  and Supportworks Cache), click Configure, enter the new password in the  Password field and click OK. These settings are for ODBC access to the application and system databases.
#  In Windows Explorer, view the root contents of the folder whose default  location is C:\Program Files\Hornbill\Supportworks Server\conf. You  will see a number of XML files.
# Open each of the XML files in turn using a text editor and search for a line containing the tag <tt>SwSqlGlobalRootPasswordMsl</tt>. If it exists in a given file, add the new password as the specified value, so that you end up with the following:
#::<tt><SwSqlGlobalRootPasswordMsl type="string" value="''new-password''"/></tt>
#:These settings are for direct access to the system databases.
# On the Server tab of the Supportworks Server Configuration utility, start all services, beginning at the bottom.
# Using the Services tool in Windows Control Panel, restart the SwHTTPServer, SwAdminServices and SwSqlServer services as well.

==== For Supportworks ESP Version 7.5.0 and Above ====

#  On the Application Database sub-tab of the Database tab in the Supportworks Server Configuration utility,  enter the new password in the Password field. This setting is for  fallback ODBC access to the application database.
# In the administrative section of Windows Control Panel, run the Data Sources (ODBC) tool and select the System DSN tab.
# For each relevant DSN shown on the list (for example, Supportworks  Data  and Supportworks Cache), click Configure, enter the new password  in the  Password field and click OK. These settings are for ODBC access  to the application and system databases.
# Back on the Database tab of the Supportworks Server Configuration utility, select the System Databases sub-tab and enter the new password in the Password field. This setting is for direct access to the system databases.
# On the Server tab of the Supportworks Server Configuration utility, start all services, beginning at the bottom.
# Using the Services tool in Windows Control Panel, restart the SwHTTPServer, SwAdminServices and SwSqlServer services as well.

=== Stage 3: Forcing a Prompt for Interactive SQL ===

Once SwSqlServer has been restarted, all access to the SwSQL server via the root account will be protected by the new password. As Interactive SQL itself will require a login using the new password (if previously blank), you now have to make it issue a prompt,  as follows:

# Select Start > Programs > Hornbill Core Services > Interactive SQL, and right-click the item to display its properties.
# In the Target field on the Shortcut tab, add the switch <tt>-p</tt>.

If you require any further  information or assistance in relation to the procedures above, please  feel free to contact the Support Team.