Hello to All,

it is more or less only a SSRS Problem, but maybe someone can help me:
I've created a Report with subreport in SSRS. The data source of the subreport is not an LN data source. I've entered there all Parameters also the credentials for connecting to the external data source.
But on runtime in the LN Environment (Infor Mingle) I have to insert the credentials again. Is there any Special Setting?
Remark; for this subreport I don't use the jca_uri and jca_ticket Parameters cause it is no LN data source.

Best Regards
Bernd

can you go to your SS Management Studio and access the database using your input credentials? have you tried "windows authentication"? how about "no credentials"? run a simple t-sql script and see how it goes.

Hi Benito,

thanks for your hints. If tried both:
"no credentials" and "windows authentication" => result: subreport not executable.
Also I've checked the direct Access by Management Studio: with the credentials I have to use the Connection and execution of the T-SQL-Select works fine.

Best Regards
Bernd

i also assume that when you open your non-baan data source the input credentials are always there (cached). i never had problems with opening an external database. hopefully someone else can give their 2 cents here.

This might need some trouble shooting as the causes for this vary. I would suggest to try the following bunch of links (Starting from downwards) -

Link 1 (http://stackoverflow.com/questions/3403136/sql-server-reporting-services-2008-r2-always-show-for-login-prompt)
Link 2 (http://stackoverflow.com/questions/12166202/reporting-services-ssrs-prompts-with-username-password)
Link 3 (http://forums.asp.net/t/1497792.aspx?stop+prompting+credentials+while+opening+report+manager+in+SSRS+2008)
Link 4 (https://ask.sqlservercentral.com/questions/101721/ssrs-asks-for-credentials-when-entering-report-man.html)
Link 5 (http://www.experts-exchange.com/questions/27829253/Why-credentials-prompts-when-accessing-to-SQL-Reporting-Services-URL.html)
Link 6 (http://serverfault.com/questions/72917/get-login-prompt-for-sql-reporting-services-deployment)
Link 7 (https://social.msdn.microsoft.com/Forums/sqlserver/en-US/23c5daa0-3232-4e8c-89c9-4526960c9d14/ssrs-2008-credentials-login-prompt?forum=sqlreportingservices)
Link 8 (http://blogs.msdn.com/b/psssql/archive/2011/04/18/why-am-i-getting-prompted-for-credentials.aspx)
Link 9 (http://www.techbrothersit.com/2013/11/ssrs-ssrs-prompts-for-credentials-again.html)
Link 10 (http://www.nullskull.com/q/10406824/ssrs-report-prompting-for-login-credentials.aspx)
Link 11 (https://sqlorcl.wordpress.com/2012/05/03/reporting-services-generates-blank-screen-after-prompting-for-credentials-three-times/)
Link 12 (https://community.dynamics.com/ax/f/33/t/69255)
Link 13 (https://social.msdn.microsoft.com/Forums/en-US/569708ca-46a9-4b27-9fd0-f5ba929c2c9c/ssrs-pop-up-in-new-window-report-ask-for-credentials?forum=sqlreportingservices)

Also, post your solution if solved. :)

On BIDS side, you might try rebuilding the report as well and make sure the security configurations for both are similar.

Hi Bhushan,

thanks for your help. I've checked the links and tried
- the Explorer Settings and
- the deactivation of the RSWindowsNegotiate-Parameter in the rsreportserver.config file.

But both Actions doesn't led to a result. There are still the credential Input fields also after restart the reporting Service.

I will dig deeper into the theme, and check the links again.

If you have an additional hint I would be appreciate.

Best Regards
Bernd

i'm curious what happens if you run the subreport by itself. i assume it shows you a couple of fields for parameter inputs from your main report and if filled everything works fine. if this is the case, then the subreport takes the credentials correctly through windows-to-sql-server logic. i am wondering if this is a ming.le flaw where it passes the baan login as parameter for the user login in a non-baan database. the problem is, unlike SSIS, SSRS doesn't offer a lot of login options. SSIS is picky on credentials too but since it has more options, the problem can be solved rather logically. having said that, i'm still hoping you can solve this with simple (complex?) windows settings.

Hi Benito,

thanks for (also mental) Support. I've tried to run the subreport out of the Report wep pages. Here it works without entering credentials.
Here in this Report web pages I also have to insert the credentials in advance and save them. That works fine.
But when I call the Report again out of the Ming.le Environment I still Need the credentials for the subreport.

Maybe I will check when I Change the subreport in the Report builder Environment which behaviour I will get afterwards. But that is a Job for tomorrow.

Best Regards
Bernd

Hello to All again,

I made several tests and found the following behaviour:

Master Report (Infor LN, DataBase1 on LN-Server): Windows-Authentication

Subreport A: (DataBase2 on Server2) Login with credentials for the SQL-Database as SA-User or separate Read-Only-User: Here I have to enter the credentials during runtime.

Subreport B: (DataBase3 on Server3) Login with credentials for the SQL-Database as SA-User: no additional Input of the credentials for the data base user is necessary.

For both Subreports I use the credentials of their SQL Server Data Base (SQL Server Authentication). So I belive the Problem have to depend either on Data Base Settings or Server Settings. Could that be possible?
Does the Data Base user Need a Special privilege or role to get connected with saved credentials?
Or is there a Privileg which enforces a prompt for the credentials?

Best Regards
Bernd

what i would suggest is to copy the user settings from server3, compare it with server2. also i recommend not to use the user "sa". good luck.

Final Solution!

Hello Bhushan, Hello Benito, and all others,
finally I found the solution after running few days in the wrong direction :-(

The solution is very simple after identification :-)
I've inserted the credential during creation of the subreport in the Report Designer from MS Visual Studio (SSRS / BIDS). After creating, saving and creation of a build I've uploaded the designed subreport to the "SQL Server Reporting Services" page. From here Infor-LN accesses the reports with the "MS_SSRS1" device.
But after the upload of the subreport the credentials was lost. So I have to insert the credentials again inside this "Reporting Service" Management page (see attached screenshots).
Now my subreports will called without reinserting the credentials.

I hope this explanation is helpful and thanks for your help and Support.

Best Regards
Bernd

So, it was indeed a security issue. Glad you made it work. Thanks for sharing the solution!

i'm glad it worked for you too. i am confused why it worked before if the subreport was ran by itself. that test told me that the credentials for that datasource were setup properly. oh well...as what they say here, as long as it works ;)