Layton ServiceDesk - Installation - Test Installation
m (Clarified procedure) |
(Major revision, added section "Virtual Server") |
||
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> | <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> | ||
__FORCETOC__ | __FORCETOC__ | ||
− | = | + | =Overview= |
− | + | This procedure is to test the application with your existing database without affecting the live system. You will be installing the application on a different server to your live installation. You can use a new database, or, if you are testing changes to your live system, you can test on a copy of your live database. | |
− | + | ||
− | + | =Procedure= | |
+ | ==Virtual Server== | ||
+ | 1. If you will be testing email, create a new email account on your mail server for testing. | ||
+ | |||
+ | 2. Back up your SQL database. | ||
+ | |||
+ | 3. Restore the backup with a different name, on the same SQL server or a different one. | ||
+ | |||
+ | 4. Take a snapshot of the server. | ||
+ | |||
+ | 5. Create a duplicate of the server. Change the server name. | ||
+ | |||
+ | 6. To prevent this test installation from hijacking your live system's mail, we will delete the email server name in both Incoming and Outgoing sections. Just the server name will suffice, accounting for all the potential methods that can be used. Run this query in Management Studio: | ||
+ | |||
+ | UPDATE setting | ||
+ | |||
+ | SET sys_setting_value = NULL | ||
+ | |||
+ | WHERE sys_setting_name IN | ||
+ | |||
+ | ('inemailpopserver' | ||
+ | ,'inemailimapserver' | ||
+ | ,'outemailsmtpserver' | ||
+ | ,'inemailcdodropfolder' | ||
+ | ,'inemailwebdavexchangeurl' | ||
+ | ,'emailexchangeserver' | ||
+ | ,'inemailexchangeserver') | ||
+ | |||
+ | 7. If you will be testing email, on first login, change the '''[[Layton ServiceDesk™ - Settings - System Settings - Email Server Settings|Email Server Settings]]''' to your test email server. | ||
+ | |||
+ | 8. If you are testing an upgrade to the latest version, download it from the '''[http://client.laytontechnology.com/ Customer Portal]''' and install it per the instructions in the latest '''[[LSD Current Version|Release Notes]]'''. | ||
+ | |||
+ | ==Standalone Server== | ||
1. If you will be testing email, create a new email account on your mail server for testing. | 1. If you will be testing email, create a new email account on your mail server for testing. | ||
Line 30: | Line 61: | ||
5. Determine the '''[[Layton ServiceDesk™ - Procedures - General - How to Find the Version Number|application version]]''' installed on your live system. | 5. Determine the '''[[Layton ServiceDesk™ - Procedures - General - How to Find the Version Number|application version]]''' installed on your live system. | ||
− | 6. Contact '''[mailto:[email protected] Support]''' to obtain the version installed on your live system. | + | 6. Contact '''[mailto:[email protected] Support]''' to obtain a full installer and any required updates for the version installed on your live system. |
7. Install as per '''[[Layton ServiceDesk™ - Installation - New Installation|New Installation]]'''. When the Database Tool opens, connect to the database copy, not the live one. | 7. Install as per '''[[Layton ServiceDesk™ - Installation - New Installation|New Installation]]'''. When the Database Tool opens, connect to the database copy, not the live one. |
Revision as of 05:06, 13 April 2016
Contents |
Overview
This procedure is to test the application with your existing database without affecting the live system. You will be installing the application on a different server to your live installation. You can use a new database, or, if you are testing changes to your live system, you can test on a copy of your live database.
Procedure
Virtual Server
1. If you will be testing email, create a new email account on your mail server for testing.
2. Back up your SQL database.
3. Restore the backup with a different name, on the same SQL server or a different one.
4. Take a snapshot of the server.
5. Create a duplicate of the server. Change the server name.
6. To prevent this test installation from hijacking your live system's mail, we will delete the email server name in both Incoming and Outgoing sections. Just the server name will suffice, accounting for all the potential methods that can be used. Run this query in Management Studio:
UPDATE setting SET sys_setting_value = NULL WHERE sys_setting_name IN ('inemailpopserver' ,'inemailimapserver' ,'outemailsmtpserver' ,'inemailcdodropfolder' ,'inemailwebdavexchangeurl' ,'emailexchangeserver' ,'inemailexchangeserver')
7. If you will be testing email, on first login, change the Email Server Settings to your test email server.
8. If you are testing an upgrade to the latest version, download it from the Customer Portal and install it per the instructions in the latest Release Notes.
Standalone Server
1. If you will be testing email, create a new email account on your mail server for testing.
2. Back up your SQL database.
3. Restore the backup with a different name, on the same SQL server or a different one.
4. To prevent this test installation from hijacking your live system's mail, we will delete the email server name in both Incoming and Outgoing sections. Just the server name will suffice, accounting for all the potential methods that can be used. Run this query in Management Studio:
UPDATE setting SET sys_setting_value = NULL WHERE sys_setting_name IN ('inemailpopserver' ,'inemailimapserver' ,'outemailsmtpserver' ,'inemailcdodropfolder' ,'inemailwebdavexchangeurl' ,'emailexchangeserver' ,'inemailexchangeserver')
5. Determine the application version installed on your live system.
6. Contact Support to obtain a full installer and any required updates for the version installed on your live system.
7. Install as per New Installation. When the Database Tool opens, connect to the database copy, not the live one.
8. If you will be testing email, on first login, change the Email Server Settings to your test email server.
9. If you are testing an upgrade to the latest version, download it from the Customer Portal and install it per the instructions in the latest Release Notes.