Best practise to provide non-DBAs querying capabilities in SQL200

When we used SQLServer 2000, we installed just query analyzer on desktops of
several of our IT folks so they could query data easily. Some of these folks
have admin priv for non-DBA reasons. Now that querying data is integrated
into the SQL 2005 management studio I am not sure the best way to provide
this function to these users. I don't want to give the full management
studio, especially to those with Admin but no appreciation for DBA tasks.
Any thoughts would be appreciated.
Thanks
--
FloraPerhaps QALite work against 2005?
http://rac4sql.net/qalite_main.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Flora Seymour" <FloraSeymour@.discussions.microsoft.com> wrote in message
news:66C0EC4F-ACDB-47DB-9417-5258409A9584@.microsoft.com...
> When we used SQLServer 2000, we installed just query analyzer on desktops of
> several of our IT folks so they could query data easily. Some of these folks
> have admin priv for non-DBA reasons. Now that querying data is integrated
> into the SQL 2005 management studio I am not sure the best way to provide
> this function to these users. I don't want to give the full management
> studio, especially to those with Admin but no appreciation for DBA tasks.
> Any thoughts would be appreciated.
> Thanks
> --
> Flora|||Thanks - I'd rather stay within the MS SQL Server2005 product if possible,
but QALite may do the trick if I that does not work out. The info I found
on it does not mention SQL2005 , just SQL2000, SQL Server7. Any experience
with QALite on SQL2005?
--
Flora
"Flora Seymour" wrote:
> When we used SQLServer 2000, we installed just query analyzer on desktops of
> several of our IT folks so they could query data easily. Some of these folks
> have admin priv for non-DBA reasons. Now that querying data is integrated
> into the SQL 2005 management studio I am not sure the best way to provide
> this function to these users. I don't want to give the full management
> studio, especially to those with Admin but no appreciation for DBA tasks.
> Any thoughts would be appreciated.
> Thanks
> --
> Flora|||I haven't used QALite myself, but since the Query Analyzer (2000 version) work against 2005 (almost
all things), I think there's a good chance that QALite does as well.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Flora Seymour" <FloraSeymour@.discussions.microsoft.com> wrote in message
news:7E6DFEA1-4E1A-407C-938A-07EDB894F066@.microsoft.com...
> Thanks - I'd rather stay within the MS SQL Server2005 product if possible,
> but QALite may do the trick if I that does not work out. The info I found
> on it does not mention SQL2005 , just SQL2000, SQL Server7. Any experience
> with QALite on SQL2005?
> --
> Flora
>
> "Flora Seymour" wrote:
>> When we used SQLServer 2000, we installed just query analyzer on desktops of
>> several of our IT folks so they could query data easily. Some of these folks
>> have admin priv for non-DBA reasons. Now that querying data is integrated
>> into the SQL 2005 management studio I am not sure the best way to provide
>> this function to these users. I don't want to give the full management
>> studio, especially to those with Admin but no appreciation for DBA tasks.
>> Any thoughts would be appreciated.
>> Thanks
>> --
>> Flora

Best practise to provide non-DBAs querying capabilities in SQL200

When we used SQLServer 2000, we installed just query analyzer on desktops of
several of our IT folks so they could query data easily. Some of these folks
have admin priv for non-DBA reasons. Now that querying data is integrated
into the SQL 2005 management studio I am not sure the best way to provide
this function to these users. I don't want to give the full management
studio, especially to those with Admin but no appreciation for DBA tasks.
Any thoughts would be appreciated.
Thanks
--
FloraPerhaps QALite work against 2005?
http://rac4sql.net/qalite_main.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Flora Seymour" <FloraSeymour@.discussions.microsoft.com> wrote in message
news:66C0EC4F-ACDB-47DB-9417-5258409A9584@.microsoft.com...
> When we used SQLServer 2000, we installed just query analyzer on desktops
of
> several of our IT folks so they could query data easily. Some of these fol
ks
> have admin priv for non-DBA reasons. Now that querying data is integrated
> into the SQL 2005 management studio I am not sure the best way to provide
> this function to these users. I don't want to give the full management
> studio, especially to those with Admin but no appreciation for DBA tasks.
> Any thoughts would be appreciated.
> Thanks
> --
> Flora|||Thanks - I'd rather stay within the MS SQL Server2005 product if possible,
but QALite may do the trick if I that does not work out. The info I found
on it does not mention SQL2005 , just SQL2000, SQL Server7. Any experience
with QALite on SQL2005?
Flora
"Flora Seymour" wrote:

> When we used SQLServer 2000, we installed just query analyzer on desktops
of
> several of our IT folks so they could query data easily. Some of these fol
ks
> have admin priv for non-DBA reasons. Now that querying data is integrated
> into the SQL 2005 management studio I am not sure the best way to provide
> this function to these users. I don't want to give the full management
> studio, especially to those with Admin but no appreciation for DBA tasks.
> Any thoughts would be appreciated.
> Thanks
> --
> Flora|||I haven't used QALite myself, but since the Query Analyzer (2000 version) wo
rk against 2005 (almost
all things), I think there's a good chance that QALite does as well.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Flora Seymour" <FloraSeymour@.discussions.microsoft.com> wrote in message
news:7E6DFEA1-4E1A-407C-938A-07EDB894F066@.microsoft.com...[vbcol=seagreen]
> Thanks - I'd rather stay within the MS SQL Server2005 product if possible
,
> but QALite may do the trick if I that does not work out. The info I fou
nd
> on it does not mention SQL2005 , just SQL2000, SQL Server7. Any experience
> with QALite on SQL2005?
> --
> Flora
>
> "Flora Seymour" wrote:
>

Best Practices Analyzer Tool for MSSQL 2000

Hi!
The tool is ver useful, but I need the document in which are explained the
Best Practices for developing in SQL Server and how you coul implementate
them in data bases...
Thanks,
Sandra
http://www.extremeexperts.com/SQL/Ar...Practices.aspx
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
"Sandra" <special_sand@.hotmail.com-do not spam-> wrote in message
news:1069B09E-B4BE-4E80-B083-D0E0199E28AA@.microsoft.com...
> Hi!
> The tool is ver useful, but I need the document in which are explained the
> Best Practices for developing in SQL Server and how you coul implementate
> them in data bases...
> --
> Thanks,
> Sandra

Best Practices Analyzer Modification

I work for a software development company and was wondering if it would be possible to create custom "Best Practices" for the Analyzer. For example if we were developing a database and wanted to check to make sure all new development followed the same pr
actices we could use our own custom "Best Practice" modules to check.
Is there anything like that that can be created for use with the Analyzer? An SDK or anything? Is that something that is planned for the future?
Thanks
The ability to create custom rules and extend BPA has certainly been talked
about and may be something that you can look forward to in a future version.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Earl G Elliott III" <Earl G Elliott III@.discussions.microsoft.com> wrote in
message news:19D1D94E-A1BA-42BE-ABAE-3ED0758F7544@.microsoft.com...
> I work for a software development company and was wondering if it would be
possible to create custom "Best Practices" for the Analyzer. For example if
we were developing a database and wanted to check to make sure all new
development followed the same practices we could use our own custom "Best
Practice" modules to check.
> Is there anything like that that can be created for use with the Analyzer?
An SDK or anything? Is that something that is planned for the future?
> Thanks
sql

Best Practices Analyzer Installation Problem

For my classes, I build a machine with all the necessary tools, including the current version of the Best Practices Analyzer. We then create a Norton Ghost image of this machine. The ghost image is restored to each classroom machine. I run a program to change the machine name, its IP address and randomize the machine's SID. Then I join the machine to the domain. All the installed software is available to the logged in user (Office, SQL Server 2000, SQL Server 2005, etc.) except BPA. Note that when I built the machine that was the source of the Ghost image, I logged in as each user and set up Outlook Express profiles and Office Profiles. When any user other than the user who installed BPA tries to run it, it issues a message that BPA must be installed. If I change the executable to run as the user who installed it, it works. But I can't find any way to make this change "generic". For example, as a local administrator, I install BPA. Then I log in to Windows as User15. I change BPA to run as administrator. It works for User15. But if I subsequently log in on that machine as User16, BPA still gives the "must be installed" message.

All of the student logins are local administrators, and the Administrators group has full control access to the BPA executable.

How do I fix this?

Thanks,
Sharon

Put the shortcut for BPA in the everyone document folder?

It sounds like a chain of custody control issue, if you log in as user16, you can not use a program installed by user15? If the program requires admin priv, then all users of the program must be admin?

This of course assumes that you really are the admin on the machine and not a "virtual admin" associated with some sys protection programs out there (and viruses of course)?

Have fun :)

Best Practices Analyzer Installation Problem

For my classes, I build a machine with all the necessary tools, including the current version of the Best Practices Analyzer. We then create a Norton Ghost image of this machine. The ghost image is restored to each classroom machine. I run a program to change the machine name, its IP address and randomize the machine's SID. Then I join the machine to the domain. All the installed software is available to the logged in user (Office, SQL Server 2000, SQL Server 2005, etc.) except BPA. Note that when I built the machine that was the source of the Ghost image, I logged in as each user and set up Outlook Express profiles and Office Profiles. When any user other than the user who installed BPA tries to run it, it issues a message that BPA must be installed. If I change the executable to run as the user who installed it, it works. But I can't find any way to make this change "generic". For example, as a local administrator, I install BPA. Then I log in to Windows as User15. I change BPA to run as administrator. It works for User15. But if I subsequently log in on that machine as User16, BPA still gives the "must be installed" message.

All of the student logins are local administrators, and the Administrators group has full control access to the BPA executable.

How do I fix this?

Thanks,
Sharon

Put the shortcut for BPA in the everyone document folder?

It sounds like a chain of custody control issue, if you log in as user16, you can not use a program installed by user15? If the program requires admin priv, then all users of the program must be admin?

This of course assumes that you really are the admin on the machine and not a "virtual admin" associated with some sys protection programs out there (and viruses of course)?

Have fun :)

Best Practices Analyzer for Sql Server 2005

Hi, Is there a version for this tool available for 2005? or do you know if new release is comming soon ?

Regards.

There is no version available yet. I haven't heard of any coming releases yet.|||

I'm a program manager at Microsoft in SQL Server. We've decided to make a new Best Practices Analyzer tool which will support SQL Server 2005. For more information or to provide some feedback go to: http://blogs.msdn.com/sqlrem/archive/2006/04/06/570292.aspx.

Thanks,

Paul A. Mestemaker II
Program Manager
Microsoft Corporation
SQL Server Relational Engine Manageability Team

Best Practices Analyzer for Sql Server 2005

Hi, Is there a version for this tool available for 2005? or do you know if new release is comming soon ?

Regards.

There is no version available yet. I haven't heard of any coming releases yet.|||

I'm a program manager at Microsoft in SQL Server. We've decided to make a new Best Practices Analyzer tool which will support SQL Server 2005. For more information or to provide some feedback go to: http://blogs.msdn.com/sqlrem/archive/2006/04/06/570292.aspx.

Thanks,

Paul A. Mestemaker II
Program Manager
Microsoft Corporation
SQL Server Relational Engine Manageability Team

Best Practices Analyzer contradicts BOL for SQLSERVERAGENT

The 2005 Best Practices Analyzer (July 2007) contradicts Books Online about what account to run SQLSERVERAGENT under.

BPA says use Network Service Account, BOL explicitly says not to use Network Service Account:

BPA gives a warning saying "SQL Server Service [MY-PC\SQLSERVERAGENT] In Unrecommended Account On Host [MY-PC]. We recommend that the service [SQLSERVERAGENT] on host [MY-PC] be run under Network Service Account. Currently it is designated to run under the account [SOMEDOMAIN\someaccount]."

BooksOnline says "Security Note: Because multiple services can use the Network Service account, it is difficult to control which services have access to network resources, including SQL Server databases. We do not recommend using the Network Service account for the SQL Server Agent service."

So who's right ? BPA or BOL ?

Books online is correct - a non-system account provides more control over access, security.

Just curious...which version of BPA are you running?

-Sue

sql

Best Practices Analyzer Access Denied Message

I am receiving an Access is Denied messsage when trying to run the Best
Practices Analyzer against a Named Instance of SQL using the AV and Severe
Errors,Unexpected Shutdowns,Datbase File Compression, NO_LOG backups,Error
Log File Size, and Failed Backups rules. I am receiving expected results for
all other rule sets. Any direction or help is appreciated.
If you can post the BPA logs from %PROGRAMFILES%\Microsoft SQL Server Best
Practices Analyzer\log, we could analyze why you are getting this message
Thanks
Sethu
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
"sskeen" <sskeen@.discussions.microsoft.com> wrote in message
news:D5ED9CBC-67AE-487B-840A-16DFAF3F8131@.microsoft.com...
>I am receiving an Access is Denied messsage when trying to run the Best
> Practices Analyzer against a Named Instance of SQL using the AV and
> Severe
> Errors,Unexpected Shutdowns,Datbase File Compression, NO_LOG backups,Error
> Log File Size, and Failed Backups rules. I am receiving expected results
> for
> all other rule sets. Any direction or help is appreciated.
|||Here is the log file information for analysis:
//--
Best Practice log file created at 3/25/2005 10:16:12 AM
Job name: test
Log file: c:\program files\microsoft sql server best practices
analyzer\log\test_clmi-vm-sqltools_0001_(local)_sqlbpa.log
//--
Preparing rule... Microsoft.SqlBpa.Rules.BpAffinityMask.BPAffinityMa sk
Getting affinity mask setting... BPAffinityMask.Execute()
Preparing rule... Microsoft.SqlBpa.Rules.BpDbFileCompression.BpFileC ompression
Getting machine name and list of databases ... BpFileCompression.Execute()
System.UnauthorizedAccessException: Access is denied.
at System.Runtime.InteropServices.Marshal.ThrowExcept ionForHR(Int32
errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(O bject o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementScope.Connect()
at Microsoft.SqlBpa.Rules.BpDbFileCompression.BpFileC ompression.Execute()
Microsoft.BPA.BestPractice.BPException: Access is denied. -->
System.UnauthorizedAccessException: Access is denied.
at System.Runtime.InteropServices.Marshal.ThrowExcept ionForHR(Int32
errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(O bject o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementScope.Connect()
at Microsoft.SqlBpa.Rules.BpDbFileCompression.BpFileC ompression.Execute()
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpDbFileCompression.BpFileC ompression.Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext,
Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpDbFileCompression.Bp FileCompression
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Access is
denied.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpNoLogBackup.BPNoLogBkup
Getting current date ... BPNoLogBackup.Execute()
Getting machine name and server instance ... BPNoLogBackup.Execute()
Getting info from NT Event Log ... BPNoLogBackup.Execute()
System.UnauthorizedAccessException: Access is denied.
at System.Runtime.InteropServices.Marshal.ThrowExcept ionForHR(Int32
errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(O bject o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementScope.Connect()
at Microsoft.SqlBpa.Rules.BpNoLogBackup.BPNoLogBkup.E xecute()
Microsoft.BPA.BestPractice.BPException: Access is denied. -->
System.UnauthorizedAccessException: Access is denied.
at System.Runtime.InteropServices.Marshal.ThrowExcept ionForHR(Int32
errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(O bject o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementScope.Connect()
at Microsoft.SqlBpa.Rules.BpNoLogBackup.BPNoLogBkup.E xecute()
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpNoLogBackup.BPNoLogBkup.E xecute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext,
Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpNoLogBackup.BPNoLogB kup
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Access is
denied.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpCycleErrorLog.BPCycleErrL og
Getting machine and instance name... BPNoLogBackup.Execute()
Getting error log path... BPNoLogBackup.Execute()
Getting log size ... BPNoLogBackup.Execute()
System.UnauthorizedAccessException: Access is denied.
at System.Runtime.InteropServices.Marshal.ThrowExcept ionForHR(Int32
errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(O bject o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementScope.Connect()
at Microsoft.SqlBpa.Rules.BpCycleErrorLog.BPCycleErrL og.Execute()
Microsoft.BPA.BestPractice.BPException: Access is denied. -->
System.UnauthorizedAccessException: Access is denied.
at System.Runtime.InteropServices.Marshal.ThrowExcept ionForHR(Int32
errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(O bject o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementScope.Connect()
at Microsoft.SqlBpa.Rules.BpCycleErrorLog.BPCycleErrL og.Execute()
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpCycleErrorLog.BPCycleErrL og.Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext,
Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpCycleErrorLog.BPCycl eErrLog
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Access is
denied.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule...
Microsoft.SqlBpa.Rules.BpFailedBackupEvents.BPFail edBackupEvt
Getting current date ... BPFailedBackupEvent.Execute()
Getting machine name and server instance ... BPFailedBackupEvent.Execute()
Getting info from NT Event Log ... BPFailedBackupEvent.Execute()
System.UnauthorizedAccessException: Access is denied.
at System.Runtime.InteropServices.Marshal.ThrowExcept ionForHR(Int32
errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(O bject o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementScope.Connect()
at Microsoft.SqlBpa.Rules.BpFailedBackupEvents.BPFail edBackupEvt.Execute()
Microsoft.BPA.BestPractice.BPException: Access is denied. -->
System.UnauthorizedAccessException: Access is denied.
at System.Runtime.InteropServices.Marshal.ThrowExcept ionForHR(Int32
errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(O bject o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementScope.Connect()
at Microsoft.SqlBpa.Rules.BpFailedBackupEvents.BPFail edBackupEvt.Execute()
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpFailedBackupEvents.BPFail edBackupEvt.Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext,
Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpFailedBackupEvents.B PFailedBackupEvt
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Access is
denied.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule...
Microsoft.SqlBpa.Rules.BpFTBackgroundServicesOptim ized.BPFTBgServicesOptimized
Getting machine name ... BPFTBackgroundServicesOptimized.Execute()
System.UnauthorizedAccessException: Access is denied.
at System.Runtime.InteropServices.Marshal.ThrowExcept ionForHR(Int32
errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(O bject o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementScope.Connect()
at
Microsoft.SqlBpa.Rules.BpFTBackgroundServicesOptim ized.BPFTBgServicesOptimized.Execute()
Microsoft.BPA.BestPractice.BPException: Access is denied. -->
System.UnauthorizedAccessException: Access is denied.
at System.Runtime.InteropServices.Marshal.ThrowExcept ionForHR(Int32
errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(O bject o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementScope.Connect()
at
Microsoft.SqlBpa.Rules.BpFTBackgroundServicesOptim ized.BPFTBgServicesOptimized.Execute()
-- End of inner exception stack trace --
Server stack trace:
at
Microsoft.SqlBpa.Rules.BpFTBackgroundServicesOptim ized.BPFTBgServicesOptimized.Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext,
Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpFTBackgroundServices Optimized.BPFTBgServicesOptimized
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Access is
denied.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule...
Microsoft.SqlBpa.Rules.BpFTMSSearchLocalSystem.BPM SSearchLocalSystem
Getting machine name ... BPFTMSSearchLocalSystem.Execute()
System.UnauthorizedAccessException: Access is denied.
at System.Runtime.InteropServices.Marshal.ThrowExcept ionForHR(Int32
errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(O bject o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementScope.Connect()
at
Microsoft.SqlBpa.Rules.BpFTMSSearchLocalSystem.BPM SSearchLocalSystem.Execute()
Microsoft.BPA.BestPractice.BPException: Access is denied. -->
System.UnauthorizedAccessException: Access is denied.
at System.Runtime.InteropServices.Marshal.ThrowExcept ionForHR(Int32
errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(O bject o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementScope.Connect()
at
Microsoft.SqlBpa.Rules.BpFTMSSearchLocalSystem.BPM SSearchLocalSystem.Execute()
-- End of inner exception stack trace --
Server stack trace:
at
Microsoft.SqlBpa.Rules.BpFTMSSearchLocalSystem.BPM SSearchLocalSystem.Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext,
Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpFTMSSearchLocalSyste m.BPMSSearchLocalSystem
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Access is
denied.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule...
Microsoft.SqlBpa.Rules.BpFTPropertyStoreSize.BPFTP ropertyStore
Getting machine name... BPFTPropertyStore.Execute()
System.UnauthorizedAccessException: Access is denied.
at System.Runtime.InteropServices.Marshal.ThrowExcept ionForHR(Int32
errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(O bject o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementScope.Connect()
at Microsoft.SqlBpa.Rules.BpFTPropertyStoreSize.BPFTP ropertyStore.Execute()
Microsoft.BPA.BestPractice.BPException: Access is denied. -->
System.UnauthorizedAccessException: Access is denied.
at System.Runtime.InteropServices.Marshal.ThrowExcept ionForHR(Int32
errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(O bject o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementScope.Connect()
at Microsoft.SqlBpa.Rules.BpFTPropertyStoreSize.BPFTP ropertyStore.Execute()
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpFTPropertyStoreSize.BPFTP ropertyStore.Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext,
Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpFTPropertyStoreSize. BPFTPropertyStore
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Access is
denied.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpSevereErrorEvents.BPSever eErrorEvt
Getting current date, machine name, and instance name ...
BPSevereErrorEvent.Execute()
Getting info from NT Event Log ... BPSevereErrorEvent.Execute()
System.UnauthorizedAccessException: Access is denied.
at System.Runtime.InteropServices.Marshal.ThrowExcept ionForHR(Int32
errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(O bject o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementScope.Connect()
at Microsoft.SqlBpa.Rules.BpSevereErrorEvents.BPSever eErrorEvt.Execute()
Microsoft.BPA.BestPractice.BPException: Access is denied. -->
System.UnauthorizedAccessException: Access is denied.
at System.Runtime.InteropServices.Marshal.ThrowExcept ionForHR(Int32
errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(O bject o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementScope.Connect()
at Microsoft.SqlBpa.Rules.BpSevereErrorEvents.BPSever eErrorEvt.Execute()
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpSevereErrorEvents.BPSever eErrorEvt.Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext,
Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpSevereErrorEvents.BP SevereErrorEvt
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Access is
denied.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule...
Microsoft.SqlBpa.Rules.BpUnexpectedShutdowns.BPUne xpectedShutdwn
Getting current date, machine name, and instance name ...
BPUnexpectedShutdown.Execute()
Getting startup and shutdown info from NT Event Log ...
BPUnexpectedShutdown.Execute()
System.UnauthorizedAccessException: Access is denied.
at System.Runtime.InteropServices.Marshal.ThrowExcept ionForHR(Int32
errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(O bject o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementScope.Connect()
at
Microsoft.SqlBpa.Rules.BpUnexpectedShutdowns.BPUne xpectedShutdwn.Execute()
Microsoft.BPA.BestPractice.BPException: Access is denied. -->
System.UnauthorizedAccessException: Access is denied.
at System.Runtime.InteropServices.Marshal.ThrowExcept ionForHR(Int32
errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(O bject o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementScope.Connect()
at
Microsoft.SqlBpa.Rules.BpUnexpectedShutdowns.BPUne xpectedShutdwn.Execute()
-- End of inner exception stack trace --
Server stack trace:
at
Microsoft.SqlBpa.Rules.BpUnexpectedShutdowns.BPUne xpectedShutdwn.Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext,
Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpUnexpectedShutdowns. BPUnexpectedShutdwn
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Access is
denied.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
"Sethu Srinivasan [MSFT]" wrote:

> If you can post the BPA logs from %PROGRAMFILES%\Microsoft SQL Server Best
> Practices Analyzer\log, we could analyze why you are getting this message
> Thanks
> Sethu
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm.
>
> "sskeen" <sskeen@.discussions.microsoft.com> wrote in message
> news:D5ED9CBC-67AE-487B-840A-16DFAF3F8131@.microsoft.com...
>
>
|||Preparing rule... Microsoft.SqlBpa.Rules.BpDbFileCompression.BpFileC ompression
Getting machine name and list of databases ... BpFileCompression.Execute()
System.UnauthorizedAccessException: Access is denied.
at System.Runtime.InteropServices.Marshal.ThrowExcept ionForHR(Int32
errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(O bject o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementScope.Connect()
at Microsoft.SqlBpa.Rules.BpDbFileCompression.BpFileC ompression.Execute()
Microsoft.BPA.BestPractice.BPException: Access is denied. -->
System.UnauthorizedAccessException: Access is denied.
at System.Runtime.InteropServices.Marshal.ThrowExcept ionForHR(Int32
errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(O bject o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementScope.Connect()
at Microsoft.SqlBpa.Rules.BpDbFileCompression.BpFileC ompression.Execute()
Preparing rule... Microsoft.SqlBpa.Rules.BpNoLogBackup.BPNoLogBkup
Getting current date ... BPNoLogBackup.Execute()
Getting machine name and server instance ... BPNoLogBackup.Execute()
Getting info from NT Event Log ... BPNoLogBackup.Execute()
System.UnauthorizedAccessException: Access is denied.
at System.Runtime.InteropServices.Marshal.ThrowExcept ionForHR(Int32
errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(O bject o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementScope.Connect()
at Microsoft.SqlBpa.Rules.BpNoLogBackup.BPNoLogBkup.E xecute()
Microsoft.BPA.BestPractice.BPException: Access is denied. -->
System.UnauthorizedAccessException: Access is denied.
at System.Runtime.InteropServices.Marshal.ThrowExcept ionForHR(Int32
errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(O bject o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementScope.Connect()
at Microsoft.SqlBpa.Rules.BpNoLogBackup.BPNoLogBkup.E xecute()
Preparing rule... Microsoft.SqlBpa.Rules.BpCycleErrorLog.BPCycleErrL og
Getting machine and instance name... BPNoLogBackup.Execute()
Getting error log path... BPNoLogBackup.Execute()
Getting log size ... BPNoLogBackup.Execute()
System.UnauthorizedAccessException: Access is denied.
at System.Runtime.InteropServices.Marshal.ThrowExcept ionForHR(Int32
errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(O bject o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementScope.Connect()
at Microsoft.SqlBpa.Rules.BpCycleErrorLog.BPCycleErrL og.Execute()
Microsoft.BPA.BestPractice.BPException: Access is denied. -->
System.UnauthorizedAccessException: Access is denied.
at System.Runtime.InteropServices.Marshal.ThrowExcept ionForHR(Int32
errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(O bject o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementScope.Connect()
at Microsoft.SqlBpa.Rules.BpCycleErrorLog.BPCycleErrL og.Execute()
Preparing rule...
Microsoft.SqlBpa.Rules.BpFailedBackupEvents.BPFail edBackupEvt
Getting current date ... BPFailedBackupEvent.Execute()
Getting machine name and server instance ... BPFailedBackupEvent.Execute()
Getting info from NT Event Log ... BPFailedBackupEvent.Execute()
System.UnauthorizedAccessException: Access is denied.
at System.Runtime.InteropServices.Marshal.ThrowExcept ionForHR(Int32
errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(O bject o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementScope.Connect()
at Microsoft.SqlBpa.Rules.BpFailedBackupEvents.BPFail edBackupEvt.Execute()
Microsoft.BPA.BestPractice.BPException: Access is denied. -->
System.UnauthorizedAccessException: Access is denied.
at System.Runtime.InteropServices.Marshal.ThrowExcept ionForHR(Int32
errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(O bject o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementScope.Connect()
at Microsoft.SqlBpa.Rules.BpFailedBackupEvents.BPFail edBackupEvt.Execute()
Preparing rule...
Microsoft.SqlBpa.Rules.BpFTBackgroundServicesOptim ized.BPFTBgServicesOptimized
Getting machine name ... BPFTBackgroundServicesOptimized.Execute()
System.UnauthorizedAccessException: Access is denied.
at System.Runtime.InteropServices.Marshal.ThrowExcept ionForHR(Int32
errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(O bject o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementScope.Connect()
at
Microsoft.SqlBpa.Rules.BpFTBackgroundServicesOptim ized.BPFTBgServicesOptimized.Execute()
Microsoft.BPA.BestPractice.BPException: Access is denied. -->
System.UnauthorizedAccessException: Access is denied.
at System.Runtime.InteropServices.Marshal.ThrowExcept ionForHR(Int32
errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(O bject o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementScope.Connect()
at
Microsoft.SqlBpa.Rules.BpFTBackgroundServicesOptim ized.BPFTBgServicesOptimized.Execute()
Preparing rule...
Microsoft.SqlBpa.Rules.BpFTMSSearchLocalSystem.BPM SSearchLocalSystem
Getting machine name ... BPFTMSSearchLocalSystem.Execute()
System.UnauthorizedAccessException: Access is denied.
at System.Runtime.InteropServices.Marshal.ThrowExcept ionForHR(Int32
errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(O bject o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementScope.Connect()
at
Microsoft.SqlBpa.Rules.BpFTMSSearchLocalSystem.BPM SSearchLocalSystem.Execute()
Microsoft.BPA.BestPractice.BPException: Access is denied. -->
System.UnauthorizedAccessException: Access is denied.
at System.Runtime.InteropServices.Marshal.ThrowExcept ionForHR(Int32
errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(O bject o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementScope.Connect()
at
Microsoft.SqlBpa.Rules.BpFTMSSearchLocalSystem.BPM SSearchLocalSystem.Execute()
Preparing rule...
Microsoft.SqlBpa.Rules.BpFTPropertyStoreSize.BPFTP ropertyStore
Getting machine name... BPFTPropertyStore.Execute()
System.UnauthorizedAccessException: Access is denied.
at System.Runtime.InteropServices.Marshal.ThrowExcept ionForHR(Int32
errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(O bject o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementScope.Connect()
at Microsoft.SqlBpa.Rules.BpFTPropertyStoreSize.BPFTP ropertyStore.Execute()
Microsoft.BPA.BestPractice.BPException: Access is denied. -->
System.UnauthorizedAccessException: Access is denied.
at System.Runtime.InteropServices.Marshal.ThrowExcept ionForHR(Int32
errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(O bject o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementScope.Connect()
at Microsoft.SqlBpa.Rules.BpFTPropertyStoreSize.BPFTP ropertyStore.Execute()
Preparing rule... Microsoft.SqlBpa.Rules.BpSevereErrorEvents.BPSever eErrorEvt
Getting current date, machine name, and instance name ...
BPSevereErrorEvent.Execute()
Getting info from NT Event Log ... BPSevereErrorEvent.Execute()
System.UnauthorizedAccessException: Access is denied.
at System.Runtime.InteropServices.Marshal.ThrowExcept ionForHR(Int32
errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(O bject o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementScope.Connect()
at Microsoft.SqlBpa.Rules.BpSevereErrorEvents.BPSever eErrorEvt.Execute()
Microsoft.BPA.BestPractice.BPException: Access is denied. -->
System.UnauthorizedAccessException: Access is denied.
at System.Runtime.InteropServices.Marshal.ThrowExcept ionForHR(Int32
errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(O bject o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementScope.Connect()
at Microsoft.SqlBpa.Rules.BpSevereErrorEvents.BPSever eErrorEvt.Execute()
Preparing rule...
Microsoft.SqlBpa.Rules.BpUnexpectedShutdowns.BPUne xpectedShutdwn
Getting current date, machine name, and instance name ...
BPUnexpectedShutdown.Execute()
Getting startup and shutdown info from NT Event Log ...
BPUnexpectedShutdown.Execute()
System.UnauthorizedAccessException: Access is denied.
at System.Runtime.InteropServices.Marshal.ThrowExcept ionForHR(Int32
errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(O bject o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementScope.Connect()
at
Microsoft.SqlBpa.Rules.BpUnexpectedShutdowns.BPUne xpectedShutdwn.Execute()
Microsoft.BPA.BestPractice.BPException: Access is denied. -->
System.UnauthorizedAccessException: Access is denied.
at System.Runtime.InteropServices.Marshal.ThrowExcept ionForHR(Int32
errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(O bject o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementScope.Connect()
at
Microsoft.SqlBpa.Rules.BpUnexpectedShutdowns.BPUne xpectedShutdwn.Execute()
"Sethu Srinivasan [MSFT]" wrote:

> If you can post the BPA logs from %PROGRAMFILES%\Microsoft SQL Server Best
> Practices Analyzer\log, we could analyze why you are getting this message
> Thanks
> Sethu
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm.
>
> "sskeen" <sskeen@.discussions.microsoft.com> wrote in message
> news:D5ED9CBC-67AE-487B-840A-16DFAF3F8131@.microsoft.com...
>
>

Best Practices Analyzer

Hello,

I found in marketing materials, than Best Practices Analyzer is included in installation of SQL 2005. Is it right ? I could not found it.

Any ideas ?

You could get it from link

http://www.microsoft.com/downloads/details.aspx?displayla%20ng=en&familyid=B352EB1F-D3CA-44EE-893E-9E07339C1F22&displaylang=en

|||But it is for SQL2000 server. I need analyzer for SQL2005 .|||

I'm a program manager heading up the next version of Best Practices Analyzer for SQL Server 2005. We are pretty early in the development cycle right now... we'll probably ship second half of this year. Check out this blog post for more information: http://blogs.msdn.com/sqlrem/archive/2006/04/06/570292.aspx.

Thanks,

Paul A. Mestemaker II
Program Manager
Microsoft Corporation
SQL Server Relational Engine Manageability Team

Best Practices Analyzer

Anyone know if there is a BPA coming for SQL 2005?
Thank you
Hey Clint,
I'm the Program Manager responsible for the next version of Best Practices
Analyzer which will support SQL Server 2005. We are very early in the
development process and would like to get some customer input. If you'd
like to put in your two cents, go to the SQL Relational Engine Manageability
Team's blog and leave a comment on this post:
http://blogs.msdn.com/sqlrem/archive...06/570292.aspx
Thanks,
Paul A. Mestemaker II
Program Manager
Microsoft Corporation
SQL Server Relational Engine Manageability Team
"Clint Colefax" <ClintColefax@.discussions.microsoft.com> wrote in message
news:A801888E-6B53-42E2-AF09-C9C9F0D17377@.microsoft.com...
> Anyone know if there is a BPA coming for SQL 2005?
> Thank you

Best Practices Analyzer

Why do I keep getting a login error box when I try to login to the BPA? I am
logging in with the same ID as I used to create the repository.
Hi Jim
BPA just tunnels through the connection information.
Can you connect from query analyzer?
Can you please provide more info on the error that you are getting?
Thanks,
- Christian
___________________________
Christian Kleinerman
Program Manager, SQL Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"JimW" <anonymous@.discussions.microsoft.com> wrote in message
news:E9D0888C-B01E-426A-9A74-E27E3C4113FE@.microsoft.com...
> Why do I keep getting a login error box when I try to login to the BPA? I
am
> logging in with the same ID as I used to create the repository.
|||Yes I can get in with Query Analyzer. All I get is a pop up window that says Login Error with a red x and a button to click ok.
-- Christian Kleinerman [MS] wrote: --
Hi Jim
BPA just tunnels through the connection information.
Can you connect from query analyzer?
Can you please provide more info on the error that you are getting?
Thanks,
- Christian
___________________________
Christian Kleinerman
Program Manager, SQL Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"JimW" <anonymous@.discussions.microsoft.com> wrote in message
news:E9D0888C-B01E-426A-9A74-E27E3C4113FE@.microsoft.com...
> Why do I keep getting a login error box when I try to login to the BPA? I
am
> logging in with the same ID as I used to create the repository.
|||From your post seems that repository database was created successfully
during setup. This would tell me that your managed stack is working well.
(i.e. SqlClient)
Can you try to login with profiler attached capturing logon and error
events, and verify 1) whether a connection is being established and 2)
whether any error is being reported?
Thanks,
- Christian
___________________________
Christian Kleinerman
Program Manager, SQL Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"JimW" <anonymous@.discussions.microsoft.com> wrote in message
news:DB5F277F-6FFC-4C3B-902B-E1885A884A4C@.microsoft.com...
> Yes I can get in with Query Analyzer. All I get is a pop up window that
says Login Error with a red x and a button to click ok.
> -- Christian Kleinerman [MS] wrote: --
> Hi Jim
> BPA just tunnels through the connection information.
> Can you connect from query analyzer?
> Can you please provide more info on the error that you are getting?
> Thanks,
> - Christian
>
> --
> ___________________________
> Christian Kleinerman
> Program Manager, SQL Engine
> This posting is provided "AS IS" with no warranties, and confers no
rights.[vbcol=seagreen]
> "JimW" <anonymous@.discussions.microsoft.com> wrote in message
> news:E9D0888C-B01E-426A-9A74-E27E3C4113FE@.microsoft.com...
BPA? I
> am
>
>
|||This is what I get from profiler with all error possibilities and other things.
10NULLNULLNULLNULLNULLNULLNULL2004-05-19 08:53:32.880NULLNULLNULL
211exec sp_reset_connectionjweber0SQL Best Practices AnalyzerWPSR\jweber51NULL2004-05-19 08:53:36.940NULLNULLNULL
310exec sp_reset_connectionjweber0SQL Best Practices AnalyzerWPSR\jweber5102004-05-19 08:53:36.940000
440select * from sysobjects where name = N'bpa_active_connections' or name =N'bpa_bestpractices' or name =N'bpa_files' or name =N'bpa_instance_results' or name =N'bpa_managed_types' or name =N'bpa_properties' or name =N'bpa_bestpractice_sqlservers' or
name jweber0SQL Best Practices AnalyzerWPSR\jweber51NULL2004-05-19 08:53:36.940NULLNULLNULL
5114select * from sysobjects where name = N'bpa_active_connections' or name =N'bpa_bestpractices' or name =N'bpa_files' or name =N'bpa_instance_results' or name =N'bpa_managed_types' or name =N'bpa_properties' or name =N'bpa_bestpractice_sqlservers' o
r name jweber0SQL Best Practices AnalyzerWPSR\jweber51NULL2004-05-19 08:53:36.957NULLNULLNULL
612select * from sysobjects where name = N'bpa_active_connections' or name =N'bpa_bestpractices' or name =N'bpa_files' or name =N'bpa_instance_results' or name =N'bpa_managed_types' or name =N'bpa_properties' or name =N'bpa_bestpractice_sqlservers' or
name jweber0SQL Best Practices AnalyzerWPSR\jweber51162004-05-19 08:53:36.940374016
715NULLjweber0SQL Best Practices AnalyzerWPSR\jweber511929232004-05-19 08:50:24.033413016
814-- network protocol: TCP/IP set quoted_identifier on set implicit_transactions off set cursor_close_on_commit off set ansi_warnings on set ansi_padding on set ansi_nulls on set concat_null_yields_null on set language us_english set dateformat mdy set
datefjweber0SQL Best Practices AnalyzerWPSR\jweber51NULL2004-05-19 08:53:37.003NULLNULLNULL
95NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL
-- Christian Kleinerman [MS] wrote: --
From your post seems that repository database was created successfully
during setup. This would tell me that your managed stack is working well.
(i.e. SqlClient)
Can you try to login with profiler attached capturing logon and error
events, and verify 1) whether a connection is being established and 2)
whether any error is being reported?
Thanks,
- Christian
___________________________
Christian Kleinerman
Program Manager, SQL Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"JimW" <anonymous@.discussions.microsoft.com> wrote in message
news:DB5F277F-6FFC-4C3B-902B-E1885A884A4C@.microsoft.com...
> Yes I can get in with Query Analyzer. All I get is a pop up window that
says Login Error with a red x and a button to click ok.[vbcol=seagreen]
> BPA just tunnels through the connection information.
> Can you connect from query analyzer?
> Can you please provide more info on the error that you are getting?
> ___________________________
> Christian Kleinerman
> Program Manager, SQL Engine
rights.[vbcol=seagreen]
> news:E9D0888C-B01E-426A-9A74-E27E3C4113FE@.microsoft.com...
BPA? I[vbcol=seagreen]
> am

Best Practices Analyzer

I'd like to add my own rules to be reported on by Best Practices analyzer.
When will we be able to create custom rules?
Also need to be able to isolate to specific databases.
Thanks for your feedback Bruce.
We've considered user-defined rules and we intend to do it, but not in the
short term (i.e. not in the next release of BPA). Be assured we do have
extensibility in mind.
To scan only a few specific databases, you can type the name of the
databases you want as part of the registration of a SQL Server instance.
(semicolon delimited)
- Christian
___________________________
Christian Kleinerman
Program Manager, SQL Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"bruce" <bruce@.discussions.microsoft.com> wrote in message
news:449614D3-F129-470B-A845-3CA4C21096F8@.microsoft.com...
> I'd like to add my own rules to be reported on by Best Practices analyzer.
> When will we be able to create custom rules?
> Also need to be able to isolate to specific databases.
|||Does the BPA tool check user accounts for pasword strength?
"Christian Kleinerman [MS]" wrote:

> Thanks for your feedback Bruce.
> We've considered user-defined rules and we intend to do it, but not in the
> short term (i.e. not in the next release of BPA). Be assured we do have
> extensibility in mind.
> To scan only a few specific databases, you can type the name of the
> databases you want as part of the registration of a SQL Server instance.
> (semicolon delimited)
> - Christian
> --
> ___________________________
> Christian Kleinerman
> Program Manager, SQL Engine
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "bruce" <bruce@.discussions.microsoft.com> wrote in message
> news:449614D3-F129-470B-A845-3CA4C21096F8@.microsoft.com...
>
>
sql

Best practices Analyzer

Hi,
I recently downloaded the Best Practices Analyzer from
http://www.microsoft.com/downloads/d...displaylang=en
I am not sure how to use it.
Is there any documentation for this..
you can install SQL Best Practices analyzer by following the instructions in
http://www.microsoft.com/downloads/d...displaylang=en
you can take a look at SQL BPA user guide in
<BPA_INSTALLATION_PATH>\docs\MSBPA_User_Guide.do c
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
"LazyDBA" <LazyDBA@.discussions.microsoft.com> wrote in message
news:734888E6-F0FA-4E3E-B85D-4E15AA8EF05D@.microsoft.com...
> Hi,
> I recently downloaded the Best Practices Analyzer from
> http://www.microsoft.com/downloads/d...displaylang=en
>
> I am not sure how to use it.
> Is there any documentation for this..

Best Practices Analyzer

Hi,
What is this and is it free? Can it track updates and deletes to tables?
thanks
Ellie
Have a look here:
http://www.microsoft.com/downloads/d...displaylang=en
Andrew J. Kelly SQL MVP
"E Sullivan" <ellie999nospam@.nospamptd.net> wrote in message
news:emdsHQVDFHA.520@.TK2MSFTNGP09.phx.gbl...
> Hi,
> What is this and is it free? Can it track updates and deletes to tables?
> thanks
> Ellie
>
|||It is very much free and available from MSDN Downloads.
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
"E Sullivan" <ellie999nospam@.nospamptd.net> wrote in message
news:emdsHQVDFHA.520@.TK2MSFTNGP09.phx.gbl...
> Hi,
> What is this and is it free? Can it track updates and deletes to tables?
> thanks
> Ellie
>

Best Practices Analyzer

Before hand, I Apologize if I am posting this on a wrong group.
I have downloaded and installed "SQL Server 2000 Best Practices Analyzer" from
http://www.microsoft.com/downloads/details.aspx?FamilyID=B352EB1F-D3CA-44EE-893E-9E07339C1F22&displaylang=en
on to my Windows XP machine where I have "SQL Server 2000 Personal addition"
is installed. The installation went fine. I created a report by connecting to
a server. Now, I want to print the report but I can't.
The document "MSBPA_User_Guide.doc" that comes with it says that I should be
able to print report by clicking on the "print report" icon on "Compliance
Reports" page but THERE IS NO "PRINT REPORT" icon.
Am I dreaming ? or what document says really doesn't match what the software
does ? or is this a limitation on Windows XP ?
Thanks for any help.Hi DXC:
you should have just four choices on the report form:
[Remove Report], [Copy Report], [Previous Report] and [Next Report].
To print a report you should use the [Copy] option and then paste it ona a
Word document or on any other editor you like.
This action let you generate a document containig the reèportsummary. to
Print the details you should copy any of them (or just the details you are
interested for) one at a time.
"DXC" wrote:
> Before hand, I Apologize if I am posting this on a wrong group.
> I have downloaded and installed "SQL Server 2000 Best Practices Analyzer" from
> http://www.microsoft.com/downloads/details.aspx?FamilyID=B352EB1F-D3CA-44EE-893E-9E07339C1F22&displaylang=en
> on to my Windows XP machine where I have "SQL Server 2000 Personal addition"
> is installed. The installation went fine. I created a report by connecting to
> a server. Now, I want to print the report but I can't.
> The document "MSBPA_User_Guide.doc" that comes with it says that I should be
> able to print report by clicking on the "print report" icon on "Compliance
> Reports" page but THERE IS NO "PRINT REPORT" icon.
> Am I dreaming ? or what document says really doesn't match what the software
> does ? or is this a limitation on Windows XP ?
> Thanks for any help.|||Thanks Gilberto.........I wanted to print details also but If I have to
print one by one then I will not print.........Is it any better if I use
the "SQL Server Reporting Services" ?
Thanks again.
"Gilberto Zampatti" wrote:
> Hi DXC:
> you should have just four choices on the report form:
> [Remove Report], [Copy Report], [Previous Report] and [Next Report].
> To print a report you should use the [Copy] option and then paste it ona a
> Word document or on any other editor you like.
> This action let you generate a document containig the reèportsummary. to
> Print the details you should copy any of them (or just the details you are
> interested for) one at a time.
> "DXC" wrote:
> > Before hand, I Apologize if I am posting this on a wrong group.
> >
> > I have downloaded and installed "SQL Server 2000 Best Practices Analyzer" from
> >
> > http://www.microsoft.com/downloads/details.aspx?FamilyID=B352EB1F-D3CA-44EE-893E-9E07339C1F22&displaylang=en
> >
> > on to my Windows XP machine where I have "SQL Server 2000 Personal addition"
> > is installed. The installation went fine. I created a report by connecting to
> > a server. Now, I want to print the report but I can't.
> >
> > The document "MSBPA_User_Guide.doc" that comes with it says that I should be
> > able to print report by clicking on the "print report" icon on "Compliance
> > Reports" page but THERE IS NO "PRINT REPORT" icon.
> >
> > Am I dreaming ? or what document says really doesn't match what the software
> > does ? or is this a limitation on Windows XP ?
> >
> > Thanks for any help.|||To use Reporting services you need to save the report details in a compliant
data source: anyway you have to peek each detail you are interested to.
Surely you can obtain a much better result in terms of presentation and
usability.
"DXC" wrote:
> Thanks Gilberto.........I wanted to print details also but If I have to
> print one by one then I will not print.........Is it any better if I use
> the "SQL Server Reporting Services" ?
> Thanks again.
> "Gilberto Zampatti" wrote:
> > Hi DXC:
> > you should have just four choices on the report form:
> > [Remove Report], [Copy Report], [Previous Report] and [Next Report].
> > To print a report you should use the [Copy] option and then paste it ona a
> > Word document or on any other editor you like.
> > This action let you generate a document containig the reèportsummary. to
> > Print the details you should copy any of them (or just the details you are
> > interested for) one at a time.
> >
> > "DXC" wrote:
> >
> > > Before hand, I Apologize if I am posting this on a wrong group.
> > >
> > > I have downloaded and installed "SQL Server 2000 Best Practices Analyzer" from
> > >
> > > http://www.microsoft.com/downloads/details.aspx?FamilyID=B352EB1F-D3CA-44EE-893E-9E07339C1F22&displaylang=en
> > >
> > > on to my Windows XP machine where I have "SQL Server 2000 Personal addition"
> > > is installed. The installation went fine. I created a report by connecting to
> > > a server. Now, I want to print the report but I can't.
> > >
> > > The document "MSBPA_User_Guide.doc" that comes with it says that I should be
> > > able to print report by clicking on the "print report" icon on "Compliance
> > > Reports" page but THERE IS NO "PRINT REPORT" icon.
> > >
> > > Am I dreaming ? or what document says really doesn't match what the software
> > > does ? or is this a limitation on Windows XP ?
> > >
> > > Thanks for any help.

Best Practices Analyzer

Hello,

I found in marketing materials, than Best Practices Analyzer is included in installation of SQL 2005. Is it right ? I could not found it.

Any ideas ?

You could get it from link

http://www.microsoft.com/downloads/details.aspx?displayla%20ng=en&familyid=B352EB1F-D3CA-44EE-893E-9E07339C1F22&displaylang=en

|||But it is for SQL2000 server. I need analyzer for SQL2005 .|||

I'm a program manager heading up the next version of Best Practices Analyzer for SQL Server 2005. We are pretty early in the development cycle right now... we'll probably ship second half of this year. Check out this blog post for more information: http://blogs.msdn.com/sqlrem/archive/2006/04/06/570292.aspx.

Thanks,

Paul A. Mestemaker II
Program Manager
Microsoft Corporation
SQL Server Relational Engine Manageability Team

Best Practices Analyzer

Before hand, I Apologize if I am posting this on a wrong group.
I have downloaded and installed "SQL Server 2000 Best Practices Analyzer" from
http://www.microsoft.com/downloads/details.aspx?FamilyID=B352EB1F-D3CA-44EE-893E-9E07339C1F22&displaylang=en
on to my Windows XP machine where I have "SQL Server 2000 Personal addition"
is installed. The installation went fine. I created a report by connecting to
a server. Now, I want to print the report but I can't.
The document "MSBPA_User_Guide.doc" that comes with it says that I should be
able to print report by clicking on the "print report" icon on "Compliance
Reports" page but THERE IS NO "PRINT REPORT" icon.
Am I dreaming ? or what document says really doesn't match what the software
does ? or is this a limitation on Windows XP ?
Thanks for any help.
Hi DXC:
you should have just four choices on the report form:
[Remove Report], [Copy Report], [Previous Report] and [Next Report].
To print a report you should use the [Copy] option and then paste it ona a
Word document or on any other editor you like.
This action let you generate a document containig the reèportsummary. to
Print the details you should copy any of them (or just the details you are
interested for) one at a time.
"DXC" wrote:

> Before hand, I Apologize if I am posting this on a wrong group.
> I have downloaded and installed "SQL Server 2000 Best Practices Analyzer" from
> http://www.microsoft.com/downloads/details.aspx?FamilyID=B352EB1F-D3CA-44EE-893E-9E07339C1F22&displaylang=en
> on to my Windows XP machine where I have "SQL Server 2000 Personal addition"
> is installed. The installation went fine. I created a report by connecting to
> a server. Now, I want to print the report but I can't.
> The document "MSBPA_User_Guide.doc" that comes with it says that I should be
> able to print report by clicking on the "print report" icon on "Compliance
> Reports" page but THERE IS NO "PRINT REPORT" icon.
> Am I dreaming ? or what document says really doesn't match what the software
> does ? or is this a limitation on Windows XP ?
> Thanks for any help.
|||Thanks Gilberto.........I wanted to print details also but If I have to
print one by one then I will not print.........Is it any better if I use
the "SQL Server Reporting Services" ?
Thanks again.
"Gilberto Zampatti" wrote:
[vbcol=seagreen]
> Hi DXC:
> you should have just four choices on the report form:
> [Remove Report], [Copy Report], [Previous Report] and [Next Report].
> To print a report you should use the [Copy] option and then paste it ona a
> Word document or on any other editor you like.
> This action let you generate a document containig the reèportsummary. to
> Print the details you should copy any of them (or just the details you are
> interested for) one at a time.
> "DXC" wrote:
|||To use Reporting services you need to save the report details in a compliant
data source: anyway you have to peek each detail you are interested to.
Surely you can obtain a much better result in terms of presentation and
usability.
"DXC" wrote:
[vbcol=seagreen]
> Thanks Gilberto.........I wanted to print details also but If I have to
> print one by one then I will not print.........Is it any better if I use
> the "SQL Server Reporting Services" ?
> Thanks again.
> "Gilberto Zampatti" wrote:
sql

Best Practices Analyzer

Before hand, I Apologize if I am posting this on a wrong group.
I have downloaded and installed "SQL Server 2000 Best Practices Analyzer" fr
om
http://www.microsoft.com/downloads/...&displaylang=en
on to my Windows XP machine where I have "SQL Server 2000 Personal addition"
is installed. The installation went fine. I created a report by connecting t
o
a server. Now, I want to print the report but I can't.
The document "MSBPA_User_Guide.doc" that comes with it says that I should be
able to print report by clicking on the "print report" icon on "Compliance
Reports" page but THERE IS NO "PRINT REPORT" icon.
Am I dreaming ? or what document says really doesn't match what the software
does ? or is this a limitation on Windows XP ?
Thanks for any help.Hi DXC:
you should have just four choices on the report form:
[Remove Report], [Copy Report], [Previous Report] and [Next
Report].
To print a report you should use the [Copy] option and then paste it ona
a
Word document or on any other editor you like.
This action let you generate a document containig the reèportsummary. to
Print the details you should copy any of them (or just the details you are
interested for) one at a time.
"DXC" wrote:

> Before hand, I Apologize if I am posting this on a wrong group.
> I have downloaded and installed "SQL Server 2000 Best Practices Analyzer"
from
> http://www.microsoft.com/downloads/...&displaylang=en
> on to my Windows XP machine where I have "SQL Server 2000 Personal additio
n"
> is installed. The installation went fine. I created a report by connecting
to
> a server. Now, I want to print the report but I can't.
> The document "MSBPA_User_Guide.doc" that comes with it says that I should
be
> able to print report by clicking on the "print report" icon on "Compliance
> Reports" page but THERE IS NO "PRINT REPORT" icon.
> Am I dreaming ? or what document says really doesn't match what the softwa
re
> does ? or is this a limitation on Windows XP ?
> Thanks for any help.|||Thanks Gilberto.........I wanted to print details also but If I have to
print one by one then I will not print.........Is it any better if I use
the "SQL Server Reporting Services" ?
Thanks again.
"Gilberto Zampatti" wrote:
[vbcol=seagreen]
> Hi DXC:
> you should have just four choices on the report form:
> [Remove Report], [Copy Report], [Previous Report] and [Nex
t Report].
> To print a report you should use the [Copy] option and then paste it o
na a
> Word document or on any other editor you like.
> This action let you generate a document containig the reèportsummary. to
> Print the details you should copy any of them (or just the details you are
> interested for) one at a time.
> "DXC" wrote:
>|||To use Reporting services you need to save the report details in a compliant
data source: anyway you have to peek each detail you are interested to.
Surely you can obtain a much better result in terms of presentation and
usability.
"DXC" wrote:
[vbcol=seagreen]
> Thanks Gilberto.........I wanted to print details also but If I have to
> print one by one then I will not print.........Is it any better if I us
e
> the "SQL Server Reporting Services" ?
> Thanks again.
> "Gilberto Zampatti" wrote:
>