| 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: General ...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: General ...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: General ...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 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: General ...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: General ...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
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: General ...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: General ...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: General ...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: General ...How can I increase a timeout for connecting to my SQL Server Applies to All ApexSQL products SummaryThis 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: General ...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: General ...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
Method II
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: General ...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: General ...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: General ...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: General ...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: General ...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: General ... |
