Access to SQL

Question

Access to SQL

Janet Taglianetti 0

How can we request access for someone in our company to SQL Server Reporting Services?

Lakshmi Narayana Garikapati 1,225 Reputation points Microsoft External Staff Moderator

2026-03-23T10:26:19.5166667+00:00

Hi Janet Taglianetti,

This is the general process most organizations follow for granting SSRS access. Typically, you’d raise a request with IT or the DBA team, provide your account details and the level of access needed, and they’ll assign the appropriate role in the SSRS portal

Thanks,

Lakshmi.
Lakshmi Narayana Garikapati 1,225 Reputation points Microsoft External Staff Moderator

2026-03-26T11:38:32.28+00:00

Janet Taglianetti,

Following up to confirm if the earlier responses addressed your query. If not, please share your questions and we’ll assist further

Thanks,

Lakshmi.
Lakshmi Narayana Garikapati 1,225 Reputation points Microsoft External Staff Moderator

2026-04-09T09:06:00.5333333+00:00

Hi Janet Taglianetti,

Following up to confirm if the earlier responses addressed your query. If not, please share your questions and we’ll assist further

Thanks,

Lakshmi.

2 answers

Your answer

Lakshmi Narayana Garikapati 1,225 Reputation points Microsoft External Staff Moderator

2026-03-23T10:26:19.5166667+00:00

Hi Janet Taglianetti,

This is the general process most organizations follow for granting SSRS access. Typically, you’d raise a request with IT or the DBA team, provide your account details and the level of access needed, and they’ll assign the appropriate role in the SSRS portal

Thanks,

Lakshmi.
Lakshmi Narayana Garikapati 1,225 Reputation points Microsoft External Staff Moderator

2026-03-26T11:38:32.28+00:00

Janet Taglianetti,

Following up to confirm if the earlier responses addressed your query. If not, please share your questions and we’ll assist further

Thanks,

Lakshmi.
Lakshmi Narayana Garikapati 1,225 Reputation points Microsoft External Staff Moderator

2026-04-09T09:06:00.5333333+00:00

Hi Janet Taglianetti,

Following up to confirm if the earlier responses addressed your query. If not, please share your questions and we’ll assist further

Thanks,

Lakshmi.

Answer 1

Erland Sommarskog 133.6K MVP Volunteer Moderator

I may misunderstand the question, but my answer is that you talk to your IT department. Keep in mind that this a public forum, and no one here knows the exact policies in your company.

0 comments

Answer 2

Access to SQL Server Reporting Services (SSRS) is granted by assigning the user or group to appropriate SSRS roles. A member of the local Administrators group on the report server must perform these steps.

For a native mode SSRS deployment:

Open the SSRS web portal (Report Manager) on the report server.
In the upper-right corner, select the gear icon and choose Site settings.
Go to the Security page.
Select Add group or user.
In Group or user, enter the Windows account or group in the form: DOMAIN\UserName or DOMAIN\GroupName
Select the appropriate system role, typically:
- System User for standard access to the site, and/or
- System Administrator for administrative tasks.
Select OK.
To grant access to reports and folders, go back to the Home folder in the web portal and assign item-level roles (for example Browser, Report Builder, Publisher, Content Manager) to the same user or group. Role assignments on the Home folder are inherited by child folders and reports.

Internally, SSRS uses role-based authorization. Role assignments are stored in the report server database and can be managed via the web portal for user/group assignment and via SQL Server Management Studio if custom roles are needed.

If SSRS is integrated with SharePoint (up to SQL Server 2016 only), access is controlled through SharePoint permissions instead of the SSRS web portal. In that case, grant the user appropriate SharePoint permission levels (for example, those including View Items, Create Alert, or Manage Alerts depending on the scenario).

References:

Share via

Access to SQL

2 answers

Your answer