Layton ServiceDesk - FAQ - Manual SQL Connection
From Layton Support
(Difference between revisions)
Laytonadmin (Talk | contribs) (→APPENDIX A – MS SQL Server Database Connection) |
(New section: "Restarting the World Wide Web Publishing Service") |
||
| (19 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | == | + | <p align="right">[[File:btn_back_up.png|link=User Guide for Layton ServiceDesk]] [[User Guide for Layton ServiceDesk|<u>Back to Contents</u>]]</p> |
| − | + | =Overview= | |
| + | Although the '''[[Layton ServiceDesk - Installation - Connect to Existing Database|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 '''[[Layton ServiceDesk - Settings - System Settings - Application Database Connection|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> | ||
| − | The | + | ==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. | ||
| − | The | + | ==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 '''[[Layton ServiceDesk - FAQ - LaytonUser1 Configuration|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 Configuration|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. | |
| − | === | + | <p align="right">[[File:btn_back_up.png|link=User Guide for Layton ServiceDesk]] [[User Guide for Layton ServiceDesk|<u>Back to Contents</u>]]</p> |
| − | + | ||
| − | The SQL | + | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | < | + | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
Latest revision as of 06:02, 11 July 2017
Contents |
[edit] 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.
[edit] 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.
[edit] 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.
[edit] 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>
[edit] 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.
[edit] 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.
[edit] appdbuid and appdbpwd
Should be null as shown, or LaytonServiceDesk will try to connect using SQL Server Authentication.
[edit] 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>
[edit] 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.
[edit] 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.
[edit] appdbuid
The SQL account name to be used. By default, LaytonUser1 is configured on database creation. You can use this, or another account.
[edit] appdbpwd
The SQL account's password. This is entered in plain text.
