Applies to
ApexSQL add-ins
Symptoms
SSMS 18 is no longer in preview mode and is the first General Availability (GA) version of SSMS 18 is out aka
ApexSQL add-ins do not show in Visual Studio 2019
Applies to
ApexSQL add-ins
Symptoms
With the release of Visual Studio 2019, Microsoft added tags in the Extensions and Updates dialog to help quickly understand whether an extension is in Preview, is a Paid extension, or is in a Trial period. This article explains how to find the installation of ApexSQL add-ins in the latest version of Visual Studio when ApexSQL item is not available among the main menu in the host application.
Number of servers exceeds number of available server licenses. Remaining licenses: -1
Applies to
ApexSQL Monitor
Symptoms
The “Number of servers exceeds the number of available server licenses. Remaining licenses -1” error warning message appears in the Add instance page when trying to add a new SQL Server instance to monitor.
“Unable to open SQL Server connection” when installing application with repository database on a remote server
Applies to
ApexSQL Monitor, ApexSQL BI Monitor, ApexSQL VM Monitor
Symptoms
The “Unable to open SQL Server connection” error appears in the Configuration step of the ApexSQL Monitor installation when the remote SQL Server instance is specified in the Server name field of the Central repository database section
Server-side components installation is repeatedly prompted in loop, even when already installed
Applies to
Brief description
Server-side components installation is forced indefinitely even when server-side components are already installed on the machine hosting a SQL Server instance the tool is connecting to
“Internal server error”, missing performance data, page cannot load or corrupted pages issues occur after application update
Applies to
ApexSQL Monitor, ApexSQL BI Monitor, ApexSQL VM Monitor
Symptoms
The “Internal server error” warning message appears in the various application pages, pages without performance data or corrupted pages are displayed, or page cannot be loaded issues might be encountered after the application is updated to a newer version.
ApexSQL Model 2018 R2 isn’t backward compatible with R1
Applies to
ApexSQL Model
Symptoms
When trying to load ApexSQL Model project file with from ApexSQL Model R1 version in ApexSQL Model R2 version you will get empty diagram with no objects loaded.
Internal server error
Applies to
ApexSQL Monitor
Symptoms
The Internal server error warning message appears in the Dashboard page when in the instance tree view a particular SQL Server is selected.
This file cannot be generated because it exceeds the maximum file-size
Applies to
ApexSQL Complete
Symptoms
When exporting data to XLSX Excel file format from the Results grid context menu using ApexSQL Complete feature Export to Excel, you might get the following informative message:
The “You need to be a member of the sysadmin role to complete the installation” error is encountered when installing server-side components in ApexSQL Recover 2014”
Applies to
ApexSQL Recover 2014
Summary
This article shows how to install ApexSQL Recover server-side components to a remote server.
