| By product |
| Other |
|
Troubleshooting Troubleshooting and known issues with ApexSQL Tools Profiling local SQL Server stored procedures and user defined functions results in blank reports Applies to ApexSQL Profile Symptoms Profiling a stored procedure/user defined function on a local SQL Server can result in a blank report if the accounts used are not configured correctly Resolution 1. Stored procedures and functions cannot be profiled if the SQL Server runs under a built-in account 2. The account under which the SQL Server runs has to be a member of the Local Administrators group About ApexSQL Profile ApexSQL Profile is a SQL Server Management Studio add-in which allows performance profiling of stored procedures and user defined functions. It tracks SQL code performance at the line level and generates comprehensive reports containing statement execution times, variable and parameter changes and more. For more information visit the ApexSQL Profile product page Last updated April 4, 2012 Labels: ApexSQL Profile ...What should I do when I encounter freezing in ApexSQL Version? Applies to ApexSQL Version Summary This article explains what to do when ApexSQL Version fails to respond Symptoms ApexSQL Version fails to respond and does not recover Resolution Please contact support@apexsql.com, describe the problem and provide as many information as you can. If possible, send us a screenshot depicting the problem. Last updated April 05, 2012 Labels: ApexSQL Version ...Profiling remote SQL Server stored procedures and user defined functions results in blank reports Applies to ApexSQL Profile Symptoms Profiling a stored procedure/user defined function on a remote SQL Server can result in a blank report if the accounts used are not configured correctly Resolution To set up remote profiling: 1. Verify that both the local and the remote machines are in the same workgroup/domain 2. Configure the firewall of the remote SQL Server machine: • Make sure that TCP/IP port 135, UDP port 4500 and UDP port 500 are open. If this requirement is not met, you may receive a CoUnmarshal exception • Make sure the sqlserver.exe is added to the firewall’s exception list 3. Configure the local security settings on the remote machine: • Log on using and administrator account • In Control Panel, click Administrative Tools • Go to Local Security Policy • Open Network Access: Sharing and Security model for local accounts • Set it to Classic – local users authenticate as themselves  If the remote machine is also a domain controller: • Log on using an administrator account • Open the Group Policy Management in Microsoft Management Console • Expand the Group Policy Objects node • Right click Default Domain Policy and select Edit  • In the Group Policy Management Editor, expand the Computer Configuration node and navigate to Windows Settings | Security Settings | Local Policies • Select Security Options  • Navigate to Network access: Sharing and security model for local accounts. Double click the policy or right click and select Properties  • Check Define this policy setting check box and click OK  4. To configure the account that runs the remote SQL Server service: • Open SQL Server Configuration Manager • Navigate to SQL Server Services • Double-click the SQL Server instance service • In the SQL Server Properties dialog that will open, select This account and provide the credentials for a user account which is member of the Local Administrators group on both the local and the remote machine and click OK   Once this configuration takes effect, you will be able to profile stored procedures and functions on the remote SQL Server    Please note: 1. Stored procedures or functions residing on a remote SQL Server cannot be profiled if the SQL Server runs under a built-in account 2. The account under which the remote SQL Server runs has to be: a. A member of the Local Administrators group on the computer running the SQL Server b. A member of the Local Administrators group on the computer used to initiate the profiling 3. The security configuration listed above must be applied to each remote SQL Server instance where the stored procedures/functions which should be profiled reside About ApexSQL Profile ApexSQL Profile is a SQL Server Management Studio add-in which allows performance profiling of stored procedures and user defined functions. It tracks SQL code performance at the line level and generates comprehensive reports containing statement execution times, variable and parameter changes and more. For more information visit the ApexSQL Profile product page Last updated March 28, 2012 Labels: ApexSQL Profile ..."Invalid activation code" message appears during Automatic and Manual activation Applies to All ApexSQL Products Summary This article explains what to do when "Invalid activation code" message appears during both Automatic and Manual activation Resolution 1) Go to Manual activation (Website login is required) 2) Select ApexSQL product in the Product list 3) Enter the Activation Key and Hardware ID an click Submit 4) The Activation code will be displayed. Click Get Reg key file 5) Save the file on the machine where ApexSQL product that should be activated is installed 6) Double click the saved reg file and, when prompted, allow the file to be added to the registry 7) A message notifying you about successful key adding to the registry will be displayed 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: Activation ..."Activation key invalid for this product" message occurs Applies to All ApexSQL Products Summary This article explains what to do when "Activation key invalid for this product" message occurs. Cause The Activation key is valid but it is being used to activate the wrong product. Resolution Make sure you are using the correct key for the specific product you are trying to activate. If the product is correct, contact support@apexsql.com and explain the problem 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: Activation ..."Activation limit exceeded" message occurs Applies to All ApexSQL Products Summary This article explains what to do when "Activation limit exceeded" message occurs. Cause The number of successful activations has exceeded the limit allowed for this activation key. Resolution Contact sales@apexsql.com, provide your full name, email, HardwareID and Activation Key in question. If possible, provide the number of activations with this Activation Key and the reasons behind each of them (installing on the test machine, machine replacement, etc.) 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: Activation ..."Activation key doesn't exist" message occurs Applies to All ApexSQL products Summary This article explains what to do when "Activation key doesn't exist" message occurs. Cause This occurs when the activation key isn’t valid or may be missing from our server. Resolution Contact sales@apexsql.com, provide your full name, email, HardwareID and any other order-related information and explain the situation 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: Activation ...Despite successful activation, activation form keeps showing up like the product is not activated Applies to All ApexSQL products Summary This article explains what to do when the product is successfully activated but the application activation form keeps showing up indicating the product is not activated. Resolution 1) Go to Manual activation (Website login is required) 2) Select ApexSQL product in the Product list 3) Enter the Activation key and Hardware Id an click Submit 4) The Activation code will be displayed. Click Get Reg key file 5) Save the file on the machine where ApexSQL product that should be activated is installed 6) Double click the saved reg file and, when prompted, allow the file to be added to the registry 7) A message notifying you about successful key adding to the registry will be displayed 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: Activation ..."Invalid regkey" message appears when trying to activate Applies to All ApexSQL Products Summary This article explains what to do when "Invalid regkey" message occurs. Cause This occurs with the older versions of the products that do not point to the new activation server where the Activation key is stored. Resolution Download a new version of the software or use Manual activation 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: Activation ...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 ...Insufficient execute permissions dialog shown when working with the Connection monitor Applies to ApexSQL Log Summary This article explains what to do when the following message appears "Insufficient permissions to execute server-side components. Please make sure SQL login used has EXECUTE permission on ApexSQL Log extended procedures (xp_ApexSQLLog)" Symptoms Insufficient permissions to execute server-side components message shows up when user is connecting to the Connection monitor manager  Cause Besides the client application, ApexSQL Log installs several extended stored procedures to SQL Server master database. Only a user with enough privileges granted on the master database and these procedures can access Connection monitor manager and view and change its settings Resolution SQL login used to access the Connection monitor manager must have at least db_datareader and db_securityadmin database roles and be granted EXECUTE permission on both xp_ApexSqlLogConnectionMonitor_State and xp_ApexSQLLog extended stored procedures. It also needs to have VIEW ANY DEFINITION set upon the master database About ApexSQL Log ApexSQL Log is a SQL Server Transaction Log reader that allows viewing transaction log data in read-friendly format. Audit and undo SQL database changes of your choosing. Determine who changed the data and when the change occurred. Read the transaction log to find out who created, changed or dropped a database object Last updated November 28, 2011 Labels: ApexSQL Log ...How to solve missing schema issue in scripts for databases with SQL Server 2000 compatibility Applies to ApexSQL Script Summary This article describes how to create correct scripts with ApexSQL Script for objects that contain schemas other than dbo Symptoms As schemas are first introduced in SQL Server 2005, they are not scripted nor shown in Object filter for databases with SQL Server 2000 compatibility  Schemas also don’t show up as dependent objects in the Script wizard  Resolution To fix this problem, change the database compatibility level from SQL Server 2000 to SQL Server 2005 and up See also ALTER DATABASE Compatibility Level (Transact-SQL) About ApexSQL Script ApexSQL Script generates scripts for SQL Server database objects and data. Script SQL databases to source control, generate .NET executable and C# projects for deployment, and automate script generation using CLI. Last updated November 30, 2011 Labels: ApexSQL Script ...System.OutOfMemory exception is thrown Applies to ApexSQL Diff, ApexSQL Log, ApexSQL Doc Summary This article explains what to do when the System.OutOfMemory exception is thrown Symptoms System.OutOfMemory exception is thrown. It usually happens when working with large databases, backups or script folders containing large number of objects, generating huge scripts or putting application under strain in general. Cause The exception is caused by the .NET framework architecture and the way it allocates memory. Due to the nature of the .NET framework, this cannot be completely removed, however it can be worked around. Resolution Use Command Line Interface that these ApexSQL products contain. Using CLI puts less strain on the machine resources. You can either save your project using GUI and then execute it via CLI, or you can specify all the parameters using CLI entirely. To make your project using GUI and execute it via CLI: 1) Make your project using GUI and save it 2) Open Command Prompt 3) Navigate to the ApexSQL product installation path (e.g. cd C:\Program Files\ApexSQL\ApexSQLDiff\ or cd C:\Program Files\ApexSQL\ApexSQLLog\) 4) Type: a) for ApexSQL Diff ApexSQLDiff.com /project:<project path>\<project name> (e.g. ApexSQLDiff.com /project:C:\Users\ApexUser\Documents\ApexSQL\ApexSQLDiff \project.axds) The script file named “sync.sql” will be created in the ApexSQL Diff installation folder. b) for ApexSQL Log ApexSQLLog.com /project:<project path>\<project name> /undo:<filename> (e.g. ApexSQLLog.com /project:C:\Users\ApexUser\Documents\ApexSQL\ApexSQLDiff \project.axlp /undo:undoscript.sql) The script file named “undoscript.sql” will be created in the ApexSQL Log installation folder. Instead of using CLI in ApexSQL Log, you can output the results into a file and thus avoid showing them in the Main grid. About ApexSQL Log ApexSQL Log is a SQL Server Transaction Log reader that allows viewing transaction log data in read-friendly format. Audit and undo SQL database changes of your choosing. Determine who changed the data and when the change occurred. Read the transaction log to find out who created, changed or dropped a database object Last updated December 01, 2011 Labels: ApexSQL Diff, ApexSQL Doc, ApexSQL Log ...How to determine if ApexSQL Log CLI has stopped working Applies to ApexSQL Log Summary This article explains how to determine if ApexSQL Log CLI has stopped working Symptoms The application running is undetermined. There are no new output lines in the console Cause Analyzing huge transaction logs can cause ApexSQL Log to become non-responsive Resolution To check if the ApexSQL Log is still running, do the following: 1. Open Windows Task Manager 2. Select Processes tab and open Select Columns dialog 3. Select I/O Read Bytes 4. Click OK and check this value for ApexSQLLog.exe value  If the value of I/O Read Bytes keeps changing - ApexSQL Log is still analyzing transaction log sources Also check the size of the output file created by ApexSQL Log. If its size is increasing - ApexSQL Log is still running About ApexSQL Log ApexSQL Log is a SQL Server auditing and recovery solution. Use ApexSQL Log to recover data, undo INSERT, UPDATE and DELETE commands and audit schema changes. Read the transaction log to find out who created, changed or dropped a database object. Last updated November 25, 2011 Labels: ApexSQL Log ... |
