Articles
Base Server Migration / Test Server Steps Outline
Outline of steps to complete a server migration or Test Server Environment
(This walkthrough assumes you have access and understand how to create/restore SQL backups + SQL users in SQL Server Management Studio. This walkthrough does not inclu...
Cloud - Cloud Endure
Cloud Endure gives us the ability to replicate machines from our data center to AWS ensuring that the VM's are up-to-date with one another before the live cut-over. Follow the Below steps to start replicating a VM: 1.) Log into CloudEndure 2.) ...
2022 SedonaASP User Security Audit
We are auditing the Hosted users [not dedicated] for accounts that do not meet security standards.
Test accounts will be disabled
Users with pw set to never expire will now need to change every 90 days
Exceptions are only able t...
Creating VMs for New Customer
Purpose: When the sale purchase is completed, the customer will start to receive their equipment and software. During this time, the Cloud VMs must be created and prepared for the customer to be tested and configured before going live. This guid...
Enterprise Server/All Down Procedure
Focus on what is occurring when opening the Sedona Office Client and Confirm Scope - Request/Capture screenshots of the exact error messages
Ensure you are getting contact info/connected with someone that can get access to the Sedona SQL...
Daily BackUp SQL Script
DECLARE @name VARCHAR(50) -- database name
DECLARE @path VARCHAR(256) -- path for backup files
DECLARE @fileName VARCHAR(256) -- filename for backup
-- specify database backup directory must end with backslash
SET @path = 'C:\Se...
Important Backups
Backups for Critical Systems
Aeonix
Using Internet Explorer, Log in to the aeonix management center with proper credentials
http://172.16.142.92:8080/aeonix/mainForm.jsf
On the left hand pane, select System > Crea...
Drop & Recreate Users
-- Run this script against each DB that is associated in SedonaMaster to repair sedonauser and sedonareports
EXEC sp_change_users_login 'Auto_Fix', 'sedonauser'
GO
EXEC sp_change_users_login 'Auto_Fix', 'sedonareports'
...
Incoming User Process
New Employee Access Request
Make sure you get a filled out, New User Form from new users manager
This has information of what department user will be in, software they will need and groups they will have to be associated with.
...
Fix SedonaReports Login and User
-- Script that fixes Sedonareports and issues printing after data/server migration
IF SUSER_ID('SedonaReports') IS NULL
BEGIN
CREATE LOGIN [SedonaReports] WITH Password = '', CHECK_EXPIRATION = OFF, CHECK_POLICY = OFF;
PRINT 'Database L...
Leaving User Process
Recover Bold Property
Recover any property belonging to Bold Group
Vertx badge
Data center badge
Cell phone
Laptop
IP Phone
Return badge to Data Center if applicable. If badge not recovered, call Data...
General FAQ & System Requirements
Q. Are any issues with implementing Transparent Data Encryption on the MS-SQL databases with SedonaOffice?
A. TDE is supported for Sedona Office as it works on the underlying SQL service. TDE may add up to 15% perf...
Manual New Company Wizard
--- BACKUP the Original SedonaOffice Database used for the new Company ---
--- RESTORE the New Company Database FROM the BACKUP and name it as a the *new desired company name* ---
--- Backup sedonamaster before making any changes ---
...
Hosted Wizard Auto Scripts
The following are scripts that are created by the Sedona Office Wizard. The wizards do not function in Clustered/Witness/ or AWS Hosted Communal Servers because the SedonaMaster/Wizards are located on the application server and not with the compan...
Port 25 Requests Regarding SMTP & AWS
From: Sedona Office Support / Case 00078422 Example
Sent: Thursday, April 27, 2023 1:11 PM
To: pweber@thenetxperts.com
Cc: brads@optbusinessservices.com; michelle@optbusinessservices.com; Brenden Beaver ; james@optbusinessservices.c...
iBackUp - DEPRECATED
-- Script Specific for iBackup Maintenance Plans
DECLARE @name VARCHAR(50) -- database name DECLARE @path VARCHAR(256) -- path for backup files DECLARE @fileName VARCHAR(256) -- filename for backup DECLARE @fileDate VARCHAR(20...
SedonaCloud Licensing for Sedona-X Mobile - 2022
Deploy 1.25.1+ of SedonaCloud
We should have IT deploy version 1.25.1 or higher of SedonaCloud to either the customer's on-premise environment or cloud-hosted environment via Octopus. You will also have to ensure that IT has set the AppPoolIdle...
Internal Resource Listing [WIP] - LINKS BROKEN
Message sent to La Marr to get updated links if possible - SW 1/4
THESE LINKS DON'T WORK. CANNOT FIND THE ORIGINAL SOURCE - JK
Please do not make edits unless you are authorized to do so
Excel Spread Tracking TSP URL and...
TSPlus Procurement and Activation Key Generation
Steps in this document should only be started once Amy Nuss has contacted you via teams with a virtual card # or if you are sure there is a positive credit balance
License Procurement
Login to the TSPlus Licensing Portal https://licen...
Update Phone After Hours Support
Updating After Hours Support Script
Purpose: This document outlines how to update the After Hours Support call script. The script will determine where to send a call depending on certain parameters, such as call day and time.
Require...
NOC - Sedona Notification Process [WIP]
Email to sedonacloudsupport@boldgroup.com - notify only
Email to sedona office_support@boldgroup.com case creation
TBD on call number
SQLAWS /Internal Servers
Minor/Notify Only via email only
RAM/CPU...
Updating Cloud After Hours Queue
Within your browser of choice, enter the following IP in the address bar:
http://172.16.142.92/
Enter the credentials that have been shared
In the top left, click Mailboxes > Properties
In the top left, you will see...
Update SSL Certificate Across IIS Server [2023]
*Complete these steps after you have successfully imported the SSL Certificate into IIS.*
Run Powershell ISE as Administrator
Update the two variables in the script where OLD is the thumbprint of the SSL expiring this year and NEW i...
PSKill.EXE File Security Alert Response
Good Day {{{Case.ContactName__c}}},
The pskill.exe file is safe. Much like several of the base installation files of the SedonaOffice platform, some have not had any changes since their original build creation and may flag in some antivirus s...
SedonaWeb 2.0/API - Different Endpoints vs. Different URLs
SedonaWeb Legacy
You have to set up more than one instance if you want a different site because it is built strictly in IIS and does not offer separate sites with web.config. Set up redirects are free but the URL in the address bar will be the ...
Sedona API/X/Web2.0 Site Error 503
Issue:
When you navigate to your SedonaAPI/Sedona-X/SedonaWeb2.0 url the site will not load and returns an error Service Unavailable / HTTP Error 503 message.
This also will prevent your Technicians from logging into Sedona-X Mobile...
SedonaAPI/Sedona-X/SedonaWeb2.0 Site Error
Issue :
When you navigate to your SedonaAPI, Sedona-X, SedonaWeb2.0 URL, the site will not load and returns an error starting the application.
This also will prevent your technicians from logging into Sedona-X.
...
Network Provisions for SedonaOffice & Primary Integrations
SedonaOffice Client
https://sedonaoffice.perennialsoftware.com/resources/reference-documents/system-requirements/
SedonaOffice uses a ‘Client /Server’ architecture (also called Fat, Thick or Heavy Client). Due to the network requirem...
Weekly SQL DB Reporting by Instance [BG ONLY]
The purpose of this document is to provide the steps to generate a weekly report of the databases to monitor growth and confirm if any are left in Full mode which can cause log file growth and negatively impact SedonaOffice use. **This is only ne...
Updating the Certificate on the Location Server Machine (Internal Only)
Location server machine details are in LastPass. Current server information based on the time of these notes.
IP: ec2-44-226-4-85.us-west-2.compute.amazonaws.com
Login:
Password:
The certificate must be provided by West/...
Unblocking a Large Number of Files
From time to time, we have all seen a situation where files were blocked in Windows. Example below: Typically, we have been told to unblock the zip file before unzipping, which should unblock the files within. If the files have already been un...
How to access AWS backup location [Communal Hosted] in SSMS
Author : Craig Floyd How to access AWS backup location within SQL Server Management Studio Issue: Unable to access AWS network backup location . Resolution: Remote into the desired AWS SQL Server Launch...
Hosted Customer Request for SQL Access - WIPOCT15
1st communication Good Afternoon Customer , Company elected for a communal hosted environment vs an isolated Dedicated. For security purposes, direct access to SQL is not available in this setup structure. What can be provided in the c...
Microsoft Office / Office 365 Maintenance Issues
If the Quick and/or Full Online repairs of Microsoft Office do not resolve the issue you must uninstall O365/Office > Reboot > previous version before the broken update using the correct file and try again. You be prompted to reboot again after...