ask for remote server login credentials in ssrs report

Thanks for your response, Sir.

 

There is no problem with database credentials. When I want to run my ssrs report, It asks for report server credentials, not for database server credentials.

My reports are on other server and database is on another server.

 

Thanks in advance.

Hi Ankit Shukla,

 

When you are opening a report, it asks for login id and password of server. You don't want to share server's login credentials with client.

 

One of the way is to do setting of "Data Source Properties" like as following:

 

 

 

https://www.sqlshack.com/create-sql-server-reporting-services-ssrs-report/

 

Hope, this will help you!