Hi.
I get this error on certain results in the compliance report. It only seems
to happen when i use SQL Server authentication
Error while executing the Best Practice Group. See the log file
test_JRSJF0J_0001_(local)_sqlbpa.log. Error message: Access is denied.
Anyone?
Hi Michael
Is the user account used to scan a valid login into SQL Server? Can you
connect from Query Analyzer? Does it have access to all databases specified
in the scan?
If you still have problems, you can use SQL Profiler and log exceptions to
see server side activity and identify the statement/operation that is
failing the access check.
- Christian
___________________________
Christian Kleinerman
Program Manager, SQL Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michael_Sergel" <MichaelSergel@.discussions.microsoft.com> wrote in message
news:AD22C6B6-CCA9-49A6-B188-18EB8CEAB8BE@.microsoft.com...
> Hi.
> I get this error on certain results in the compliance report. It only
seems
> to happen when i use SQL Server authentication
> Error while executing the Best Practice Group. See the log file
> test_JRSJF0J_0001_(local)_sqlbpa.log. Error message: Access is denied.
> Anyone?
>
No comments:
Post a Comment