Layton ServiceDesk - FAQ - LaytonUser1 Configuration
m (Minor formatting changes) |
m (Minor text changes) |
||
| (6 intermediate revisions by one user not shown) | |||
| Line 11: | Line 11: | ||
If the database is moved to another server, the account will not be recreated in ''SQLSERVERNAME > Security > Logins''. | If the database is moved to another server, the account will not be recreated in ''SQLSERVERNAME > Security > Logins''. | ||
| − | It is not necessary to connect to SQL Server using the LaytonUser1 account. A different account can be used. | + | It is not necessary to connect to SQL Server using the ''LaytonUser1'' account. It is provided so that Layton ServiceDesk can connect using a known SQL Server user account. A different account can be used. |
=Password= | =Password= | ||
| Line 21: | Line 21: | ||
=Properties= | =Properties= | ||
| + | ==SQL Server 2008== | ||
[[File:Lsd acct laytonuser1 config01.png|center|link=]] | [[File:Lsd acct laytonuser1 config01.png|center|link=]] | ||
| Line 34: | Line 35: | ||
[[File:Lsd acct laytonuser1 config05.png|center|link=]] | [[File:Lsd acct laytonuser1 config05.png|center|link=]] | ||
| + | ==SQL Server 2016== | ||
| + | [[File:Lsd acct laytonuser1 sql2016 config01.png|center|link=]] | ||
| + | |||
| + | |||
| + | LaytonUser1 is given the ''sysadmin'' Server Role because it needs to be able to '''[[Layton ServiceDesk - Configuring the System - Data Design|create user-defined fields on forms]]''', which are implemented as new columns in various tables: | ||
| + | [[File:Lsd acct laytonuser1 sql2016 config02.png|center|link=]] | ||
| + | |||
| + | |||
| + | [[File:Lsd acct laytonuser1 sql2016 config03.png|center|link=]] | ||
| + | |||
| + | |||
| + | Only ''Connect SQL'' is checked in the ''Grant'' column: | ||
| + | [[File:Lsd acct laytonuser1 sql2016 config04.png|center|link=]] | ||
| + | |||
| + | |||
| + | [[File:Lsd acct laytonuser1 sql2016 config05a.png|center|link=]] | ||
<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> | <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> | ||
Latest revision as of 05:36, 9 November 2020
Contents |
[edit] Overview
On database creation, the SQL user LaytonUser1 is created as an account that can be used with Layton ServiceDesk. This article lists the configuration of the account.
The LaytonUser1 account will appear in:
- SQLSERVERNAME > Databases > LaytonServiceDesk > Security > Users
- SQLSERVERNAME > Security > Logins.
If the database is moved to another server, the account will not be recreated in SQLSERVERNAME > Security > Logins.
It is not necessary to connect to SQL Server using the LaytonUser1 account. It is provided so that Layton ServiceDesk can connect using a known SQL Server user account. A different account can be used.
[edit] Password
On creation, the password is
LaytonSDUser1
We recommend that this be changed.
[edit] Properties
[edit] SQL Server 2008
[edit] SQL Server 2016
LaytonUser1 is given the sysadmin Server Role because it needs to be able to create user-defined fields on forms, which are implemented as new columns in various tables:
Only Connect SQL is checked in the Grant column:
