SSRS 2016- Custom form authentication and related configuration in SSDT Visual studio 2019

Sudhakar Chavan 6 Reputation points
2021-02-18T09:02:08.857+00:00

Hi All,
Greetings of the day!

In our project, we are migrating ssrs 2008 reports to ssrs 2016 env.
Technical Environment details -
SQL Server 2016, SSRS 2016
SSDT - Visual Studio 2019
Datawarehouse - Oracle 11g
SSRS authentication - Custo Form.

In this, we have implemented custom form authentication to connect to SSRS report services.
In SSDT we have provided userid /password of one of the user who has system admin access.

Now to work on the RDL file, we open it in visual studio 2019 - SSDT, and build it.

But when we try to deploy the report from visual studio it says userid password is not valid.

The datasource user id and password provided is of data warehouse which is different than the SSRS users or database.

So in this scenario what userid and password required to be provided?

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,849 questions
0 comments No comments
{count} vote

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 34,581 Reputation points
    2021-02-19T02:16:12.767+00:00

    Hi @Sudhakar Chavan

    Do you mean that when you deploy the reports to the report server, it asked for the userid and password?

    If yes, the user id and password should be the account which have the permission to deploy reports to the server.

    Permission is determined through role-based security that is defined by your report server administrator. Publishing operations are typically granted through the Publisher role.

    1. Open the Report Manager in browser, click the Properties tab in the home page.
    2. Click New Role Assignment button, add current login account with Publisher Role.

    role-definitions-predefined-roles

    Also make sure that the Target server url is correct as shown.

    69862-screenshot-2021-02-19-101321.jpg

    Details for your reference: publishing-reports-to-a-report-server

    If I misunderstand your issue, please incorrect me and screenshot is welcome for more analysis.

    Regards,

    Zoe


    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October

    0 comments No comments