Creating a new user for SQL Server authentication and grant the necessary permissions.
Updated Sep 9, 2024sql-serverApplies to 10.0, 9.2Not yet checked for Applicare 10.0
Check this against your version
This article was last updated on Sep 9, 2024, before Applicare 10.0 was released (Jun 19, 2026), and has not been re-checked for Applicare 10.0. Confirm the steps in your environment or contact Support.
1. Grant the db_datareader role to all the databases, including the master database.
2. Grant the following permissions: alter trace, view server state, view database state and alter any event session.
Syntax:
use master;
grant alter trace to <new_user>;
grant view server state to <new_user>;
grant view database state to <new_user>;
grant alter any event session to <new_user>;
Replace <new_user> with the username of the newly created user.
e.g. If the new user name is appms, use that in place of <new user>
use master;
grant alter trace to appms;
grant view server state to appms;
grant view database state to appms;
grant alter any event session to appms;
Was this article helpful?
Votes, comments and follows are kept by Zendesk, so they need a Help Center account. These buttons open this article there.
