By product  
  Other  

Troubleshooting

Troubleshooting and known issues with ApexSQL Tools


Installing server-side components only to a remote server

Applies to
ApexSQL Log
ApexSQL Recover

Summary

This article shows how to install server-side components of ApexSQL Log/Recover to a remote server

Symptoms
When installing server-side components from a client machine, the following error occurs "You need to be a member of the sysadmin role to complete the installation. Please, attempt to connect to the database using a SQL Server sysadmin account after closing this dialog"

Cause
One of the causes for this is that the user attempting to install the server-side components doesn't have sufficient permissions to install them on the remote server

Resolution
The server-side components must be installed directly on the server. This can be accomplished by running application individual installer on the server itself. To do this

1) Download ApexSQL Log or ApexSQL Recover individual installers

Download ApexSQL Log installer
Download ApexSQL Recover installer

2) Run the installer on the server

3) When prompted to select components to install, select Server-side components on a local server






4) Complete the installation

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

About ApexSQL Recover
ApexSQL Recover is a tool that recovers data lost due to delete, truncate and drop operations. Recover BLOB data as files and extract data from corrupted databases, detached MDFs or a recent SQL database backup without restoring it.

Last update
November 30, 2011

Labels: ,

...