Layton ServiceDesk - FAQ - Manual SQL Connection
Contents |
Overview
Although the DBTool application is the preferred method of configuring a SQL connection, it can be configured manually. This is useful in the event where a change in the Application Database Connection settings has caused Layton ServiceDesk to lose its connection.
There are two options: NT or SQL authentication.
Location of SQL Configuration File
The SQL configuration file is
config.xml
It is located in
C:\Program Files (x86)\Layton Technology\Layton ServiceDesk\HB_Data\ConfigXML\
The file can be edited with any text editor such as Notepad.
Restarting the World Wide Web Publishing Service
After manually reconfiguring the SQL connection, it is not registered unless the World Wide Web Publishing Service is restarted. This step is important.
Connecting Using NT Authentication (Trusted Connection)
The sample below shows the four lines that need to be configured to allow connection to SQL server using NT Authentication.
<appodbc label="Connection">(local)</appodbc> <appdb label="Database">LaytonServiceDesk</appdb> <appdbuid label="User ID (Blank = NT Trusted)"></appdbuid> <appdbpwd label="Password"></appdbpwd>
appodbc
The server name of the SQL Server you are connecting to. This can be a server name or an IP address. If an instance is used, it should be specified, e.g. SERVER\SQLEXPRESS. The value of (local) is a default value that tells LaytonServiceDesk to connect to the same server as it is installed on.
appdb
The database within the SQL Server that LaytonServiceDesk is to connect to. The default name as installed is LaytonServiceDesk, unless you have installed the LaytonServiceDesk database using a different name.
appdbuid and appdbpwd
Should be null as shown, or LaytonServiceDesk will try to connect using SQL Server Authentication.
Connecting Using SQL Authentication
These are the four lines that need to be configured to allow connection to SQL server using SQL Authentication. Note that the SQL user LaytonUser1 was created on installation and can be used.
<appodbc label="Connection">(local)</appodbc> <appdb label="Database">LaytonServiceDesk</appdb> <appdbuid label="User ID (Blank = NT Trusted)">SQLACCOUNTNAME</appdbuid> <appdbpwd label="Password">PASSWORD</appdbpwd>
appodbc
The server name of the SQL Server you are connecting to. This can be a server name or an IP address. If an instance is used, it should be specified, e.g. SERVER\SQLEXPRESS. The value of (local) is a default value that tells LaytonServiceDesk to connect to the same server as it is installed on.
appdb
The database within the SQL Server that LaytonServiceDesk is to connect to. The default name as installed is LaytonServiceDesk, unless you have installed the LaytonServiceDesk database using a different name.
appdbuid
The SQL account name to be used. By default, LaytonUser1 is configured on database creation. You can use this, or another account.
appdbpwd
The SQL account's password. This is entered in plain text.