Troubleshooting: Access is denied message appears on ApexSqlServerHelper calling

LINKS

General

Apex SQL Audit
Apex SQL Clean
Apex SQL Code
Apex SQL Diff
Apex SQL Diff Data
Apex SQL Doc
Apex SQL Edit
Apex SQL Enforce
Apex SQL Log
Apex SQL Recover
Apex SQL Report
Apex SQL Script

Troubleshooting Home

SITE FEED

Site Feed

Support Forum

The fastest and most effective to get answers to your questions quickly. Click Here for more info.

FAQs

Quick answers to common questions. Click Here for more info.

Troubleshooting

Known issues and basic troubleshooting techniques for problems or unexpected behaviors. Click Here for more info.

Knowledgebase

Technical tips, How-to articles, and other tutorials about ApexSQL Tools. Click Here for more info.

Online Documentation

All of our help files for download or convenient viewing online. Click Here for more info.

Videos

Watch product demos, training videos, or tutorials of our products' main features. We frequently upload new videos so check often for updates. Click Here for more info.

Troubleshooting

Troubleshooting and Known issues with Apex SQL Tools

Access is denied message appears on ApexSqlServerHelper calling

Got the "Call to xproc xp_ApexSQLLog(1) Failed..." error message before audit of the transaction log is started

CAUSE
It’s caused by lack of permissions on the part of the account that is running SQL Server process/service.

RESOLUTION
To fix the problem, please do the following:

Login to server as administrator.
Go to command prompt.
Change directory to SQL Server’s Binn directory (this is where sqlservr.exe is installed as well as all ApexSQL Log’s server-side components)
Affected version is ApexSQL Log 2005
Run "ApexSqlServerHelper /load" which should create and load ApexSQL’s Server Helper service.

Affected version is ApexSQL Log 2008
Run "ApexSqlServerHelper2008 /load" which should create and load ApexSQL’s Server Helper service.

LAST REVIEW
05 December 2008

Labels: ApexSQL Log

posted by David Dawson on Monday, August 20, 2007

0 Comments: