running queries against msdb and Reportserver repository.

Heisenberg 261 Reputation points
2023-04-26T20:06:25.91+00:00

hi Folks,

One of our application developer wants to run queries against msdb and reportserver database using linked server. is it advisable to run query against msdb and reportserver databases using linked server? can someone give me cons of doing this?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,122 questions
0 comments No comments
{count} votes

Accepted answer
  1. Erland Sommarskog 104.2K Reputation points MVP
    2023-04-26T20:43:27.1066667+00:00

    I can't really see any issues if you set up the linked server with self-mapping. That is, to be able run these queries, he needs to have permissions in msdb and the ReportServer database when he logs in directly. Using a linked server with self-mapping.

    If the developer does not have permission and hope that you will set up a linked server with login-mapping - just say no.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful