Layton ServiceDesk - Errors - Cannot open database "LaytonServiceDesk" requested by the login
From Layton Support
(Difference between revisions)
(New Page) |
m (Minor text changes) |
||
Line 11: | Line 11: | ||
#On the Layton ServiceDesk server, navigate to ''C:\Program Files (x86)\Layton Technology\Layton ServiceDesk\HB_Data\ConfigXML''. | #On the Layton ServiceDesk server, navigate to ''C:\Program Files (x86)\Layton Technology\Layton ServiceDesk\HB_Data\ConfigXML''. | ||
#Open ''config.xml'' in Notepad. | #Open ''config.xml'' in Notepad. | ||
− | #Look for the string ''<appdbuid label="User ID (Blank = NT Trusted)">''. The string in the <appbuid> tag is the name of the account that is configured to access the Layton ServiceDesk database ("database user"). By default, this is '''[[Layton ServiceDesk - FAQ - LaytonUser1 Configuration|LaytonUser1]]'''. | + | #Look for the string ''<appdbuid label="User ID (Blank = NT Trusted)">''. The string in the ''<appbuid>'' tag is the name of the account that is configured to access the Layton ServiceDesk database ("THE database user"). By default, this is '''[[Layton ServiceDesk - FAQ - LaytonUser1 Configuration|LaytonUser1]]'''. |
#Launch Management Studio and log in as the database user. Can you log in? | #Launch Management Studio and log in as the database user. Can you log in? | ||
#If you can't log in to Management Studio, log in as the admin user ''sa''. | #If you can't log in to Management Studio, log in as the admin user ''sa''. | ||
#Check '''[[Layton ServiceDesk - FAQ - LaytonUser1 Configuration#Properties| Properties]]''' of the database user. | #Check '''[[Layton ServiceDesk - FAQ - LaytonUser1 Configuration#Properties| Properties]]''' of the database user. | ||
<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 22:16, 17 January 2019
[edit] SQL Server Settings
[edit] Error
On launch, the following error is observed:
Cannot open database "LaytonServiceDesk" requested by the login. The login failed. Login failed for user 'LaytonUser1'.
[edit] Procedure
- Open Windows Services Console and ensure that the SQL Server service is running.
- On the Layton ServiceDesk server, navigate to C:\Program Files (x86)\Layton Technology\Layton ServiceDesk\HB_Data\ConfigXML.
- Open config.xml in Notepad.
- Look for the string <appdbuid label="User ID (Blank = NT Trusted)">. The string in the <appbuid> tag is the name of the account that is configured to access the Layton ServiceDesk database ("THE database user"). By default, this is LaytonUser1.
- Launch Management Studio and log in as the database user. Can you log in?
- If you can't log in to Management Studio, log in as the admin user sa.
- Check Properties of the database user.