This section contains the following topic

Configuring Precise to run without System Administrator privileges

This section is only relevant for instances of SQL Server 2005 and higher.

When installing Precise for SQL Server, in a Precise version prior to version 8.0, you are asked to use a login account that has System Administrator privileges. Although it is strongly recommended to run Precise for SQL Server with a System Administrator user, in Precise version 8.0 and higher, it is also possible to use a less powerful login account.

In any case there are a few privileges that you need to grant to that login account:

  • The privilege to alter a trace.
  • The privilege to view any definition.
  • The privilege to control the server.

Take into consideration, that when you run Precise for SQL Server with a login account that is not System Administrator, you will miss the following functionality:

  • DBCC TRACEON. This may increase the number of sessions that have a NULL batch handle and therefore increase the amount of Text N/A batches.
    Workaround: You can add DBCC TRACEON 2861 in the starting parameter of the SQL Server instance (-T 2861).
  • DBCC INPUTBUFFER (if needed by the internal collector logic). This may limit the ability the retrieve the statement/batch text when the system encounters some known bugs in SQL Server.
  • Metrics for not responding transactions. You will get an error in Alerts.
  • Show statistics and Show config views enabled in index/table entities in the Objects tab. They will stop working.
  • Recommendations. This may limit to get recommendation for objects and statements.

For more information, see Start and Use the Database Engine Tuning Advisor on the MSDN website.


IDERA |  Products | Purchase | Support |  Community |  Resources |  About Us  | Legal
  • No labels