Layton ServiceDesk - Pre-Installation - SQL & Windows Authentication
From Layton Support
(Difference between revisions)
(Added section "Overview") |
m (Added link) |
||
(One intermediate revision by one user not shown) | |||
Line 2: | Line 2: | ||
__FORCETOC__ | __FORCETOC__ | ||
=Overview= | =Overview= | ||
− | Layton ServiceDesk does not use Windows authentication to the SQL Server, only SQL authentication through the ''LaytonUser1'' SQL account, created during installation. This account has sufficient permissions to do every operation required by the various Layton ServiceDesk features. SQL Server and Windows Authentication mode must be enabled on the SQL Server. | + | Layton ServiceDesk does not use Windows authentication to the SQL Server, only SQL authentication through the '''[[Layton ServiceDesk - FAQ - LaytonUser1 Configuration|LaytonUser1]]''' SQL account, created during installation. This account has sufficient permissions to do every operation required by the various Layton ServiceDesk features. SQL Server and Windows Authentication mode must be enabled on the SQL Server. |
=Procedure= | =Procedure= | ||
Line 13: | Line 13: | ||
=Video= | =Video= | ||
'''[https://client.laytontechnology.com/wp-content/themes/layton-admin/includes/pages/user/help/videos/lsd/installWindowsAuthentication/?iframe=true&width=100%&height=100% Video of procedure on Windows Server 2012]'''. | '''[https://client.laytontechnology.com/wp-content/themes/layton-admin/includes/pages/user/help/videos/lsd/installWindowsAuthentication/?iframe=true&width=100%&height=100% Video of procedure on Windows Server 2012]'''. | ||
− | <p align="right">[[File:btn_back_up.png|link=Layton ServiceDesk - Installation - Special Notes]] [[Layton ServiceDesk - Installation - Special Notes|<u>Back to Special Notes</u>]]</p | + | <p align="right">[[File:btn_back_up.png|link=Layton ServiceDesk - Installation - Special Notes]] [[Layton ServiceDesk - Installation - Special Notes|<u>Back to Special Notes</u>]]</p> |
Latest revision as of 05:33, 9 November 2020
Contents |
[edit] Overview
Layton ServiceDesk does not use Windows authentication to the SQL Server, only SQL authentication through the LaytonUser1 SQL account, created during installation. This account has sufficient permissions to do every operation required by the various Layton ServiceDesk features. SQL Server and Windows Authentication mode must be enabled on the SQL Server.
[edit] Procedure
- Launch Management Studio.
- Connect to your SQL Server.
- Right-click the SQL Server and select Properties:
- Click the Security link and click the SQL Server and Windows Authentication mode radio button:
- Click OK.