Post reply

Asking Username and Password to connect to SSRS 2008 machine

  • April 12, 2012 at 5:26 pm

    #254078

    Hi,

    I am using .Net 4.0 frame work, developed website (web browser) were I call SSRS Report by passing parameters. The Website and SSRS are on two different machines but same domain. While testing from another machine (say client) we could able to connect to Website and select few options from the Website we developed and prepare the URL mentioned below. Passing this URL to SSRS 2008 asking for credentials. Since I know the credentials I enter and got the report, if in real time if a client pass the URL it shouldn't ask for any credentials. IIS is running on Intergrated Windows Account "domain\iss_ssrs_account" and this same account is added as user in the machine (SSRS box) and same user is admin to DB.

    http://10.20.30.40/ReportServer_ABCDEF/Pages/ReportViewer.aspx?%2fExport%2fSearch&rs:Command=Render&ResultType=R&companyid=XYZ&city:isnull=true&countryName=USA

    Can anybody help me out, I already spend 2 days on this issue to fix.

    Thanks in advance,

    Sri.

  • April 12, 2012 at 11:30 pm

    #1473031

    Can't you configure the datasource to run with a fixed set of credentials instead of using Windows Authentication?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • April 13, 2012 at 2:35 am

    #1473090

    you should configure database password in your web application:

    some thing like that

    :

    ConnectionInfo connectionInfo = new ConnectionInfo();

    connectionInfo.ServerName = @"PEDSERVER\A";

    connectionInfo.DatabaseName = "ped";

    connectionInfo.UserID = "sa";

    connectionInfo.Password = "5083";

    crepDocument = new ReportDocument();

    string reportPath = Application.StartupPath + "\\" + "Reportcontract.rpt";

    crepdocument.Load(reportPath);

    crystalReportViewer1.ReportSource = crepDocument;

    ParameterFields parameterFields = crystalReportViewer1.ParameterFieldInfo;

    SetDBLogonForReport(connectionInfo);

    SetCurrentValuesForParameterField(parameterFields);

    ---------------------------------------------------
    baaaaaaaaaaaaaleh!!! (Ehs_Akb)

  • April 13, 2012 at 8:07 am

    #1473264

    Hi,

    The user is making asynchronize call to SSRS reports from webbrowser. And the call is just sending the parameters I mentioned to SSRS Reports, mean time the user can work on the web page until the results show up. There is no code inside .Net that is related to ReportViewer.

    http://10.20.30.40/ReportServer_ABCDEF/Pages/ReportViewer.aspx?%Export%&rs:Command=Render$contryname=usa&format=excel

    The report comes backs in Excel format.

    Thank you,

    Sri.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply