how to set Sql Authentication Programatically[Answered] RSS

• • Reply
  narasappa

  Member

  582 Points

  494 Posts

  how to set Sql Authentication Programatically

  Apr 25, 2012 01:23 AM|narasappa|LINK

  hi all

  when i run my C R it is asking authentiacation for every Run.. how can  i over  this problem ..

  THANKU

  Narasappa C J
  ravi.jadiyannavar@gmail.com
  Pls Mark This Post As Answer If it Helps U..
  
• • Reply
  Vipindas

  Contributor

  4392 Points

  933 Posts

  Re: how to set Sql Authentication Programatically

  Apr 25, 2012 03:26 AM|Vipindas|LINK

  Write this code in the event you find appropriate

  protected void Page_Load(object sender, EventArgs e)
  {
      ReportDocument crystalReport = new ReportDocument();
      crystalReport.Load(Server.MapPath("CrystalReport.rpt"));
      crystalReport.SetDatabaseLogon("username", "password", @"server\SQLEXPRESS", "TestDB");
      CrystalReportViewer1.ReportSource = crystalReport;
  }

  Hope this helps...

• • Reply
  narasappa

  Member

  582 Points

  494 Posts

  Re: how to set Sql Authentication Programatically

  Apr 25, 2012 07:48 AM|narasappa|LINK

  Thanku Very much

  Narasappa C J
  ravi.jadiyannavar@gmail.com
  Pls Mark This Post As Answer If it Helps U..