By product  
  Other  

Troubleshooting

Troubleshooting and known issues with ApexSQL Tools


What to do when ApexSQL product fails on startup silently

Summary
This article describes what to do when ApexSQL product fails at startup silently


Symptoms
When attempting to start ApexSQL product it fails silently

Resolution

1. If your application was activated previously please perform the following steps: a. Start the Windows Registry editor: Start | Run | regedit b. Locate a key that corresponds to your application under HKEY_CURRENT_USER | Software| ApexSQL c. Delete the entire key d. Start the application and reactivate it
2. If you installed your program over an older version, at start up new version tries to load the old profiles and, depending on the product and version, it may cause this type of behavior. To work around this problem, please uninstall the application. Delete the installation folder to clean out of all profiles and xml files then re-install.

About ApexSQL
ApexSQL is a leading provider of SQL Server tools for database recovery, database auditing, database comparison, documentation as well as SQL Server Management Studio and Visual Studio add-ins for SQL code refactoring, code completion and database source control. We strive to ensure that every one of our tools is standard-defining product in its class, from feature set, to performance, interface and quality.

Last updated
December 26, 2011

Labels:

...


What to do when ApexSQL installer fails at start up with message "The setup file is corrupted" or "The setup files are corrupted"

Summary
This article describes what to do when ApexSQL installer fails at start up with message "The setup file is corrupted" or "The setup files are corrupted" and .Net is installed

Symptoms
While attempting to open ApexSQL installer the next message appears:



Cause
The most common reason for this is that the downloadable installation file wasn't completely downloaded

Resolution
To solve this issue please try re-downloading the installer. If problem persist please contact support@apexsql.com for a workaround

About ApexSQL
ApexSQL is a leading provider of SQL Server tools for database recovery, database auditing, database comparison, documentation as well as SQL Server Management Studio and Visual Studio add-ins for SQL code refactoring, code completion and database source control. We strive to ensure that every one of our tools is standard-defining product in its class, from feature set, to performance, interface and quality.

Last updated
December 26, 2011

Labels:

...


What to do when ApexSQL product starts with .Net exception and .Net is installed

Summary
This article describes what to do when encountering .Net exception on product startup and .Net is installed

Symptoms
Product starts with .Net exception:




Cause
This message appears when .Net framework 1.1 is installed, but a newer version is required to run the product

Resolution
To solve this issue please check system requirements for your product and install a newer version of .Net framework (do not uninstall .Net framework 1.1)

About ApexSQL
ApexSQL is a leading provider of SQL Server tools for database recovery, database auditing, database comparison, documentation as well as SQL Server Management Studio and Visual Studio add-ins for SQL code refactoring, code completion and database source control. We strive to ensure that every one of our tools is standard-defining product in its class, from feature set, to performance, interface and quality.

Last update
December 26, 2011

Labels:

...


What to do when ApexSQL product starts with general Windows GPF exception

Summary
This article describes what to do when encountering general Windows GPF exception on product startup


Symptoms
Product starts with Windows GPF exception:



Cause
The message shows up when there is no .Net run-time library installed


Resolution
Please check the particular system requirements for your application here

About ApexSQL
ApexSQL is a leading provider of SQL Server tools for database recovery, database auditing, database comparison, documentation as well as SQL Server Management Studio and Visual Studio add-ins for SQL code refactoring, code completion and database source control. We strive to ensure that every one of our tools is standard-defining product in its class, from feature set, to performance, interface and quality.

Last update
December 26, 2011

Labels:

...


What to do when ApexSQL product starts with Visual Studio JIT debugger exception

Summary
This article describes what to do when encountering Visual Studio JIT debugger exception on product startup


Symptoms
Product starts with Visual Studio JIT debugger exception:




Cause
This exception occurs when product application files are damaged or the installation process failed


Resolution
Uninstall the product, delete the installation folder and its contents, then re-install the product

About ApexSQL
ApexSQL is a leading provider of SQL Server tools for database recovery, database auditing, database comparison, documentation as well as SQL Server Management Studio and Visual Studio add-ins for SQL code refactoring, code completion and database source control. We strive to ensure that every one of our tools is standard-defining product in its class, from feature set, to performance, interface and quality.

Last update
December 26, 2011

Labels:

...


Connection to SQL server failed

Applies to
All ApexSQL products

Summary
This article explains what should be done when application fails to log in showing the "SQL Server does not exists" message

Resolution

The possible workarounds for this case are as follows:

1) For SQL Developer and SQL Enteprise servers named as MACHINE_NAME\MSSQLSERVER
  • Remove "\MSSQLSERVER suffix from the instance name
  • If previous isn't possible: Create aliases for the desired severs and content through them  

2) For SQL Express servers please put "\SQLEXPRESS" at the end of server name

About ApexSQL
ApexSQL is a leading provider of SQL Server tools for database recovery, database auditing, database comparison, documentation as well as SQL Server Management Studio and Visual Studio add-ins for SQL code refactoring, code completion and database source control. We strive to ensure that every one of our tools is standard-defining product in its class, from feature set, to performance, interface and quality.

Last updated
05 December, 2011  

Labels:

...


What happens if the account used to start or install a product doesn't have enough privileges?

Applies to
All ApexSQL products; Windows 7 x32/x64 and below; Windows Server 2008 R2 x32/x64 and below

Summary

This article shows what happens if the account used to start ApexSQL product installation doesn't have the minimum permissions required to successfully install and use ApexSQL products

Symptoms

- Installing
In order to install ApexSQL products, the account used to start the installation has to have administrative privileges
If User Account Control (UAC) doesn’t exist or is disabled, and the installation is started from a non-administrative account the following error is shown:



On the other hand, if UAC is enabled and the installation is started from a non-administrative account you are prompted to enter credentials for an administrative account, as shown:



NOTE: You have to start the installation from an administrative account/supply administrative credentials. The installation will fail, even if started from a power user account/power user credentials are supplied. There is an exception to this behavior, when Group Policy is used to deploy the application to target computers in an Active Directory domain; however that scenario is beyond the scope of this article

- Usage
Most of the ApexSQL installation files are copied to the location specified during the installation process. By default, that location is
%ProgramFiles%\ApexSQL\ on 32 bit, or %ProgramFiles(x86)%\ApexSQL\ on 64 bit systems.
In the remainder of the text we will use ApexSQL Edit as a sample product; however the text applies to all ApexSQL products
ApexSQL products store application specific settings in the installation folder. Let us consider the following scenarios:
• ApexSQL Edit is installed in %ProgramFiles%\ApexSQL\ or %ProgramFiles(x86)%\ApexSQL\
and UAC is nonexistent or disabled. The minimum required permissions are:



• ApexSQL Edit is installed in %ProgramFiles%\ApexSQL\ApexSQL2008 or %ProgramFiles(x86)%\ApexSQL\ApexSQLEdit2008 and UAC is enabled
In this case the output is automatically redirected to the VirtualStore\Program Files\ApexSQL folder, located in %AppDataLocal%. The minimum required permissions are:



• ApexSQL Edit is installed in a custom location. The minimum required permissions are:



If the user account doesn’t have the Write permission on that folder, the following error is displayed



and the application will fail to start

Besides the folder the ApexSQL product is installed to, additional files and folders are necessary for the product to run properly. %AppDataLocal%\ApexSQL\Common stores information on the used SQL servers (DisplayedServers.xml and LocatedServers.xml) and information relevant to the updating process. Product specific settings are stored in the %AppDataLocal%\ApexSQL\%ProductName% folders. ApexSQL Log and ApexSQL Recover store their logs in %AppDataLocal%\ApexSQL\%ProductName%\Logs. Therefore, the minimum permissions required over the %AppDataLocal%\ApexSQL folder are:



In case the user account has less permissions than shown, or can’t access the files in %AppDataLocal%\ApexSQL for any other reason, some of the ApexSQL products won’t work under that account and will throw the appropriate exception. Normally, the user has Full Control on his %AppData% folder, however, in scenarios when the company policy is to redirect the %AppData% folder to a server, instead of keeping it on the local machine, and when the network server or the domain controller is unavailable or when certain restrictive Group or Security Policies are applied, knowing the permissions sets listed above can be beneficial

About ApexSQL
ApexSQL is a leading provider of SQL Server tools for database recovery, database auditing, database comparison, documentation as well as SQL Server Management Studio and Visual Studio add-ins for SQL code refactoring, code completion and database source control. We strive to ensure that every one of our tools is standard-defining product in its class, from feature set, to performance, interface and quality.

Last updated
November 24, 2011

Labels:

...


The specified path is too long error

Applies to
All ApexSQL products

Summary

This article shows how to solve the issue when "The specified path is too long" error is encountered during product update

Description
In case when the ApexSQL product used is not in the current version, Automatically check for updates on Application Start-up option is checked, all the files necessary for upgrade are downloaded, upon starting product update the following error message will occur:

The fully qualified file name must be shorter than 260 characters and the path name shorter than 248 characters.

Cause
This is a known Windows limitation.
The installation folder path length and the length of the file name should not exceed the given number of characters.

Resolution
During the product installation, the installation folder must be chosen. If a folder with a short path is chosen, this error won't appear. It is not possible to change the installation folder during the automatic update.

To work around this problem, please download ApexSQL Installer
Just install the ApexSQL product into a new folder.

In Vista and Windows 7, this can be worked around by using mklink.exe for directory junctions and symbolic links.

About ApexSQL
ApexSQL is a leading provider of SQL Server tools for database recovery, database auditing, database comparison, documentation as well as SQL Server Management Studio and Visual Studio add-ins for SQL code refactoring, code completion and database source control. We strive to ensure that every one of our tools is standard-defining product in its class, from feature set, to performance, interface and quality.

Last updated
December 26, 2011

Labels:

...


A scheduled batch file is not executed

Applies to
ApexSQL Diff, ApexSQL Log

Summary

You have created a batch file to execute ApexSQL application tasks. It works when you run it manually, but when you schedule it using Windows Scheduler nothing happens and there’s no message.

Symptoms
You have created a batch file to execute an ApexSQL application task that creates an output file.

SET OutputHTML=Differences.html

"C:\Program Files\ApexSQL\ApexSQLDiff2010\ApexSQLDiff.com" /pf:D:\ApexSQL\forum\customers\1634\DevToQA.axds /ot:Html /of:%OutputHTML% /f

When you run it manually from the Windows Explorer, logged with an account that is Windows Administrator, the Differences.html file was created.
But when you create a Windows Task, nothing happens and the Differences.html is not created.

Cause
The reason for this issue is that the default Windows (Vista, Windows 7) user when UAC is turned on, doesn't have write access to the C:\Windows\System32 folder, and as the location of the file created is not specified, it is created in the Windows\System32 folder.

To see the messages that are suppressed by default, add /v switch to the batch file command.

Resolution
There are two possible solutions for this issue:

1. Run the scheduled task as Administrator

a. Open the Task Properties Dialog
b. Check 'Run with highest privileges' option

2. Locate the Differences.html file in a folder where the user has enough privileges

In the batch file, instead of
SET OutputHTML=Differences.html
Use the following code:
SET OutputHTML="D:\Differences.html"
or provide any other local path where you have full privileges.

About ApexSQL
ApexSQL is a leading provider of SQL Server tools for database recovery, database auditing, database comparison, documentation as well as SQL Server Management Studio and Visual Studio add-ins for SQL code refactoring, code completion and database source control. We strive to ensure that every one of our tools is standard-defining product in its class, from feature set, to performance, interface and quality.

Last updated
February 03, 2012

Labels:

...


How can I increase a timeout for connecting to my SQL Server

Applies to
All ApexSQL products

Summary
This article explains how to increase the timeout period for any SQL Server connection to prevent "Timeout expired" message.

Symptoms
Trying to connect to SQL Server using ApexSQL application causes "Timeout expired" message:

"Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (Microsoft SQL Server, Error: -2)"

Cause
The default 15 seconds timeout is not enough to successfully connect due to the:

1) Connecting to the remote SQL Server over a slow network
2) Connecting to the remote SQL Server in the heavy network traffic time
3) Various other reasons

Resolution
Open the Connection options dialog and set desired time period for any SQL Server instance.

Connection options dialog can be accessed via "Options" link which is present in "New project" or "Connect to Server" forms.



About ApexSQL
ApexSQL is a leading provider of SQL Server tools for database recovery, database auditing, database comparison, documentation as well as SQL Server Management Studio and Visual Studio add-ins for SQL code refactoring, code completion and database source control. We strive to ensure that every one of our tools is standard-defining product in its class, from feature set, to performance, interface and quality.

Last updated
December 01, 2011

Labels:

...


Shotgun weddings and Auto-updaters


Applies to
All ApexSQL products

Summary

ApexSQL tools have Auto-updater that will notify users of updates and allow them to automatically update their software to the new version. However, auto-updater might not warn customers who still have an older version of the software that the update is a new major version.In newer ApexSQL application versions, the customers get the notice that it is a major update, but the application is updated anyway, without checking their maintenance status at our upgrade center (or contacting sales).



We understand that the notice in the Auto-updater dialog might not be highlighted effectively enough, and there were not sufficient warnings/validation to discourage an inadvertent upgrade. We apologize to the customers affected by this.

The newer updater dialog (shown below) will give even more explicit warnings as well as present a validation message when the customer presses "Next". This should guarantee that customers will be presented with crystal clear upgrade options and there will be no confusion.



Resolution
There are two ways to solve the problem.

Revert to old version
You can simply uninstall the new version and download and install the old version.

After downgrading make sure to turn off the Auto-updater:


Upgrade to new version
You can upgrade to the new major version. As an existing customer you will always get a 30% discount on new versions of the software, no matter how long ago you purchased an older version or have been out of maintenance. Contact our sales for help in purchasing the new version. You can also visit our upgrade center to check maintenance status and upgrade costs.

If you need additional assistance, have other questions etc please contact our sales

About ApexSQL
ApexSQL is a leading provider of SQL Server tools for database recovery, database auditing, database comparison, documentation as well as SQL Server Management Studio and Visual Studio add-ins for SQL code refactoring, code completion and database source control. We strive to ensure that every one of our tools is standard-defining product in its class, from feature set, to performance, interface and quality.

Last updated
December 06, 2011

Labels:

...


When I download a help file from the website, the following is shown: "The page cannot be displayed", "Action canceled" or I'm unable to view the TOC

Applies to
All ApexSQL products

Summary

This article explains how to solve the problem when:

1) CHM file downloaded from the Internet or CHM file created by ApexSQL Doc on a remote server can't be opened
2) It is unable to view or navigate through the Table of content, Index and Search

Symptoms
The following messages are shown when viewing a Compiled Help (.CHM) file, downloaded from the Internet or opened from the Network place:

1) Action canceled



2) The page cannot be displayed



3) The Table of content, Index and Search is not shown


Cause
'Action canceled' or 'The page cannot be displayed' error will be displayed with computers using Windows XP Service Pack 2, Windows Server 2003 Service Pack 1, Windows Vista, Windows 7, Windows Server 2008 or Windows Server 2008 R2. The problem is caused by security features introduced in the MS Windows security update MS05-026, designed to reduce HTML help vulnerability. On the other hand, if it is possible to open the file but Table of content, Index and Search are not shown, this means that you are using a browser other than Internet Explorer to view the Help file.

Resolution
There are two methods to fix the problem:

Method I

  1. Double click the downloaded Compiled Help (.CHM) file
  2. Set Always ask before opening this file checkbox OFF in the Open File - Security Warning dialog

  3. Open the file

Method II
  1. Right click the downloaded Compiled Help (.CHM) file and select Properties item from the context menu
  2. Press Unblock in the Propertiesand apply changes

  3. Double click the CHM file


To be able to view and use the Table of content, Search and Index, use Internet Explorer

About ApexSQL
ApexSQL is a leading provider of SQL Server tools for database recovery, database auditing, database comparison, documentation as well as SQL Server Management Studio and Visual Studio add-ins for SQL code refactoring, code completion and database source control. We strive to ensure that every one of our tools is standard-defining product in its class, from feature set, to performance, interface and quality.

Last updated
December 02, 2011

Labels:

...


I ran the downloaded installer but it failed at start up

Applies to
All ApexSQL products

Summary

This article shows what you should do when you encounter the "The setup files are corrupted. Please obtain a new copy of the program" error.

Symptoms
Downloaded installer fails to run with the following message:
"The setup files are corrupted. Please obtain a new copy of the program"

Cause
The most common reason for this problem is that the downloaded installation file isn’t completely downloaded.

Resolution
Please try re-downloading the installer. Make sure that the installer size given on our downloads page matches the size of the downloaded file. Then try installing the application again. If the problems persist, please contact support@apexsql.com for a workaround.

About ApexSQL
ApexSQL is a leading provider of SQL Server tools for database recovery, database auditing, database comparison, documentation as well as SQL Server Management Studio and Visual Studio add-ins for SQL code refactoring, code completion and database source control. We strive to ensure that every one of our tools is standard-defining product in its class, from feature set, to performance, interface and quality.

Last updated
November 25, 2011

Labels:

...


My ApexSQL application fails on startup silently

Applies to
All ApexSQL products

Summary

This article explains what to do when the application does not start at all.

Symptoms
Upon opening an ApexSQL application nothing happens. I do not get any sort of error message or indication in the event logs. Rebooting didn’t help.

Cause
If you installed your program over an older version, new version tries to load the old profiles at start up and, depending on the product and the version, it may cause this kind of behavior.

Resolution
If your application was activated previously, please perform the following steps:

1. Start the Windows Registry editor: Start | Run | regedit
2. Locate a key that corresponds to your application in HKEY_CURRENT_USER | Software | ApexSQL
3. Delete the entire key
4. Start the application and reactivate it

If you installed your program over an older version, please uninstall the application.
Delete the installation directory to clean all the profiles and .xml files and then re-install.

About ApexSQL
ApexSQL is a leading provider of SQL Server tools for database recovery, database auditing, database comparison, documentation as well as SQL Server Management Studio and Visual Studio add-ins for SQL code refactoring, code completion and database source control. We strive to ensure that every one of our tools is standard-defining product in its class, from feature set, to performance, interface and quality.

Last updated
November 25, 2011

Labels:

...


My ApexSQL application fails on startup displaying a .Net exception, although I've got .Net framework installed already


Applies to
All ApexSQL products

Summary

This article explains how to solve the issue when .NET Framework initialization error is thrown

Symptoms
I receive .Net exception on ApexSQL application start:

"To run this application, you first must install one of the following versions of the .Net Framework:
v2.0.50727
Contact your application publisher for instructions about obtaining the appropriate version of the .Net Framework."

Cause
Almost all of our applications require .Net 2.0 run-time library. The above message shows up when you have .Net 1.1 run-time library installed.

Resolution
Please install .Net 2.0 run-time library first (you should not uninstall your .Net 1.1 library, so this installation won't affect the existing applications) Also, check your application's system requirements
 


About ApexSQL
ApexSQL is a leading provider of SQL Server tools for database recovery, database auditing, database comparison, documentation as well as SQL Server Management Studio and Visual Studio add-ins for SQL code refactoring, code completion and database source control. We strive to ensure that every one of our tools is standard-defining product in its class, from feature set, to performance, interface and quality.

Last updated 
December 06, 2011

Labels:

...


My ApexSQL application fails on startup displaying a general Windows GPF exception


Applies to
All ApexSQL products

Summary

This article explains how to solve the issue when a Windows General Protection Fault exception is thrown

Symptoms
ApexSQL application fails to start and a general Windows General Protection Fault exception appears:

"The application failed to initialize properly (0xc0000135).
Click on OK to terminate the application."

Cause
You are receiving this error message due to the unavailability of the installed pre-requisites. Almost all of our applications require .Net 2.0 run-time library, and this message shows up when you have no .Net run-time library installed.

Resolution
Please, check the
system requirements for your application and install all the components
required.

About ApexSQL
ApexSQL is a leading provider of SQL Server tools for database recovery, database auditing, database comparison, documentation as well as SQL Server Management Studio and Visual Studio add-ins for SQL code refactoring, code completion and database source control. We strive to ensure that every one of our tools is standard-defining product in its class, from feature set, to performance, interface and quality.

Last updated,
November 25, 2011

Labels:

...


My ApexSQL application fails on startup displaying a Just-In-Time debugger window with an unhandled exception


Applies to
All ApexSQL products

Summary

This article explains how to solve the issue when a Just-In-Time debugger window with an unhandled exception is shown.

Symptoms
My ApexSQL application fails on start-up displaying a Just-In-Time debugger window with an unhandled exception.

Cause
The reason for this behavior are damaged application files or failed installation process

Resolution
Please uninstall the application, delete the installation folder and re-install the product

About ApexSQL
ApexSQL is a leading provider of SQL Server tools for database recovery, database auditing, database comparison, documentation as well as SQL Server Management Studio and Visual Studio add-ins for SQL code refactoring, code completion and database source control. We strive to ensure that every one of our tools is standard-defining product in its class, from feature set, to performance, interface and quality.

Last updated
December 01, 2011

Labels:

...