Layton ServiceDesk - FAQ - Manual SQL Connection

From Layton Support
Jump to: navigation, search

Btn back up.png Back to Contents

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.

Btn back up.png Back to Contents

Personal tools
Namespaces

Variants
Actions
Main Page
Online User Guides
General Support
Release Notes
Toolbox