Connecting to the local SQL Server - Metasys - LIT-1201645 - MS-ADSxxx-x - MS-ADXxxx-x - Server - ADS Server - ADX Server - 13.0
ADS/ADX Commissioning Guide
Product
Building Automation Systems > Databases and Data Servers > ADS Server
Building Automation Systems > Application Servers > ADX Server
Document type
Commissioning Guide
Document number
LIT-1201645
Version
13.0
Revision date
2023-10-12
Product status
Active
Introduction
Summary of changes
Commissioning the ADS overview
Application and Data Server (ADS) and Extended Application and Data Server (ADX)
ADS device object
Site Director
Repositories
Trend repository database
Trend repository overview
Trend repository optimization
Audit repository database
Audit repository database overview
Audit repository optimization
Event repository database
Event repository overview
Event repository optimization
Annotation repository database
Reporting repository database
Spaces authorization repository database
Spaces authorization repository database overview
Potential problem areas repository overview
Fault detection repository overview
Fault triage repository overview
RabbitMQ technology
Introduction
Message queue size considerations and troubleshooting
System security for the ADS/ADX
Remote notifications
Antivirus software
Printing information displayed on the user interface
Additional configuration notes
An ADS and ADX on the same site
Uninterruptible power supply
Detailed procedures
Configuring an ADS/ADX as Site Director
Configuring an ADS/ADX as Site Director if you delete the current Site Director
Configuring ADS/ADX repositories
Setting the time zone, date, and time on an ADS/ADX
Setting power options for the ADS/ADX
Setting power options for the ADS/ADX network card
Setting power failure options for the ADS/ADX
Setting up a local or network printer on an ADS/ADX
Setting up a local or network printer for scheduled reports output
Removing user accounts from a demoted Site Director
Changing the Site Director
Moving the security database and clearing it from the demoted Site Director
Configuring Metasys system settings
Changing Metasys login window background in SMP
Changing the action queue timeout
Creating audit entries for discard events
Configuring Metasys Advanced Reporting System settings
Refreshing the Metasys Advanced Reporting System data manually
Changing Metasys Advanced Reporting System settings for IIS
Changing the archive database used by the Metasys Advanced Reporting System (Windows Server platform only)
Implementing SSL security for the Metasys Advanced Reporting System
Troubleshooting
Split ADX troubleshooting
ADS/ADX slow performance
Backup, restoration, and renaming of the SQL Server databases
Using Communication Log Files
Windows log file cleanup
ADS/ADX and SCT temporary file cleanup
ADS/ADX startup failures
ADS/ADX stops responding after Windows updates
Folders in the Windows Event Viewer on the ADS/ADX
Anti-spyware software on the ADS/ADX computer
Metasys Advanced Reporting cache refresh or report execution may fail with 'Out of memory' or 'Memory pressure' messages in the SQL Server log
Sync engine command scenarios
Metasys UI login failure after an out-of-place installation or upgrade to Release 13.0
Metasys services utilities introduction
Metasys Services Utilities detailed procedures
Stopping the Metasys Server services
Starting the Metasys Server services
Restarting the Metasys Server services
Technical specifications
Application and Data Server (ADS) system requirements
Application and Data Server Lite system requirements
Extended Application and Data Server system requirements (Unified 10 or 25 User ADX)
Extended Application and Data Server system requirements (Unified 50 or 100 User ADX)
Extended Application and Data Server system requirements (Split 10 or 25 User ADX)
Extended Application and Data Server system requirements (Split 50 or 100 User ADX)
Appendix: Time zone, date, and time management
Time zone, date, and time management introduction
Overview of time synchronization
ADS/ADX Site Director with network engines
Time synchronization methods
Windows time synchronization
Multicast time synchronization
BACnet time synchronization
Example network
Multiple time zones
Site time server
Time in device object and user interface status bar
Steps for successful time management
Verifying the Site Director defined for an engine/server
Setting the time synchronization method
ADS/ADX as Site Director
Setting the time zone in the Site Director ADS/ADX
Setting the date and time in the Site Director ADS/ADX
Selecting a site time server for the Site Director ADS/ADX (Windows method only)
Selecting a site time server for the Site Director ADS/ADX (multicast method only)
Configuring additional multicast time synchronization settings
Appendix: Changing the ADS or ADX name and the computer name on an ADS and unified ADX
Overview of changing the ADS or ADX name and the computer name
Starting the Metasys Rename Assistant
Connecting to the local SQL Server
Preparing the computer
Preparing the archive database
Uninstalling the Metasys software
Renaming the computer
Verifying the SQL server software
Reinstalling the Metasys software
Downloading the Metasys archive database
Applying the ADS/ADX settings
Updating Launcher shortcuts and profiles
Uploading the Metasys archive database
Appendix: Configuring and maintaining preferences
Configuring and maintaining preferences introduction
Preferences concepts
System and user preferences
System preferences
User preferences
Managing preferences
Detailed procedures
Configuring preferences
Restoring default system preferences
Copying preferences between devices
Restoring default user preferences
Removing user preference files
Copying user preferences to another user
Preserving preferences in an upgrade
Appendix: Microsoft Windows operating system and SQL Server software license requirements
Licensing requirements overview for operating systems
Purchasing and designating operating system CALs
OS licensing modes and CAL examples
ADS, ADS-Lite, and non-server based OAS requirements
Microsoft SQL Server licensing requirements
Appendix: Windows firewall
Configuring the Windows Defender firewall
Closing ports
Appendix: Installing antivirus software
Installing and configuring Symantec® Endpoint Protection software
Related documentation
Product warranty
Software terms
Patents
Contact information
In the Metasys Rename
Assistant window, read the warning statement, and then, if
you agree, select the checkbox to confirm that you assume
responsibility.
Select the Enable SQL Server
Authentication checkbox.
Enter your SQL Server user name and
password.
Click Test
Connection .
After you connect to the SQL Server,
click Get Started .