Sql Membership / Login works local but not on production server - ASP.NET Discussion Boards

It should be evident from the output you have. The Response object is filled with the necessary bits that tell the browser this is a webpage, such as the DOCTYPE, html, body. Response.Write(ipAddress) just adds to the stream it does nothing to replace it. What you need to do is, as I said before, use some of the other methods of the HttpResponse class, like ClearContent[^]

Also, again as I said before, this really should be implemented as a web service. Just because some other site is doing it as a webpage doesn't mean its the best way. Look at the URL and you will see it is using asp, a severly outdated technology.

I know the language. I've read a book. - _Madmatt

hi, i'm trying to access the SQL Report in asp.net reportviewer. i had successfully configured Sql Report service 2008 and the report manager is working fine. But when i try open the reports in asp.net page with reportviewer it shows "The request failed with HTTP status 401: Unauthorized". i'm passing the credentials parameter in config file and the reportserver Network credential class is also working fine. Can anybody help me please... i tired with googling...
Thanks in advance....

SamRST wrote:
i tired with googling

tired or tried?
You can save your time using that, even you don't need post this question if you have searched..... Use perfect keywords while searching in search engines.

Anyway I'll give you answer this time. Here in that page the OP solved the issue himself.
"The request failed with HTTP status 401: Unauthorized." - SQL Reporting Services[^]

thatraja

My Tip/Tricks
My Dad had a Heart Attack on this day so don't...

Thank you for the link. i had tried the same before, but still the message remains. i'm using the Sql report service 2008, VS2005 , windows xp professional. Any other options...

hi, thank you for all. i sorted out the issue. There are lots of problems related to this. if u created the Reports in 2005 and deployed in Report server 2008, you must have use Report viewer 8.0 or higher in your application.
And my issue was related to the credential. when i disable the report service credential class. the report starts to working fine.
Thanks for all.

Dear all,

I've got this warning in my webserver and my website it get slow down.
Message is: "A process serving application pool 'DefaultAppPool' exceeded time limits during shut down. The process id was '5948'."

What is the problem? how to fix it?

I need your helps.

Thanks,

Best regards,
Han

Take a look at this one.

Contention, poor performance, and deadlocks when you make Web service requests from ASP.NET applications[^]

thatraja

My Tip/Tricks
My Dad had a Heart Attack on this day so don't...

Hi All,

I have created a basic login site, right now just has a login and forgetpassword page.
The site works perfectly locally but on publishing when I navigate to forgotpassword page
after typing the username and click submit I get the following error "We were unable to access your information. Please try again. "
Also when I am trying to login I get the error"Invalid Username Or Password".

Why does it work locally and not on the production server?

Here is my web config file, I am unable to figure this out. Have done a lot of research and would appreciate your help.

<?xml version="1.0"?>
<configuration>
	<configSections>
		<sectionGroup name="system.web.extensions" type="System.Web.Configuration.SystemWebExtensionsSectionGroup, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35">
			<sectionGroup name="scripting" type="System.Web.Configuration.ScriptingSectionGroup, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35">
				<section name="scriptResourceHandler" type="System.Web.Configuration.ScriptingScriptResourceHandlerSection, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="false" allowDefinition="MachineToApplication"/>
				<sectionGroup name="webServices" type="System.Web.Configuration.ScriptingWebServicesSectionGroup, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35">
					<section name="jsonSerialization" type="System.Web.Configuration.ScriptingJsonSerializationSection, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="false" allowDefinition="Everywhere"/>
					<section name="profileService" type="System.Web.Configuration.ScriptingProfileServiceSection, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="false" allowDefinition="MachineToApplication"/>
					<section name="authenticationService" type="System.Web.Configuration.ScriptingAuthenticationServiceSection, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="false" allowDefinition="MachineToApplication"/>
				</sectionGroup>
			</sectionGroup>
		</sectionGroup>
	</configSections>
	
	<!-->Mail Setting-->
	<system.net>
		<mailSettings>
			
		</mailSettings>
	</system.net>
	
	<!--Databse Connection-->
	<connectionStrings>
		<add name="db" connectionString="Data Source=SQLOLEDB.1;Data Source=**.**.*.**;Initial Catalog=pdb;User ID=beta;Password=******"/>
    
		<!-- For Login-->
		<remove name="LocalSqlServer"/>
		<add name="LocalSqlServer" connectionString="Data Source=SQLOLEDB.1; Data Source=**.**.*.**; Initial Catalog=pdb;User ID=beta;Password=******"/>
	</connectionStrings>
	<system.web>
		<pages>
			<controls>
				<add tagPrefix="asp" namespace="System.Web.UI" assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
			</controls>
		</pages>
		<!--
          Set compilation debug="true" to insert debugging
          symbols into the compiled page. Because this
          affects performance, set this value to true only
          during development.
    -->
		<compilation debug="true">
			<assemblies>
				<add assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
				<add assembly="System.Design, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
				<add assembly="System.Web.Extensions.Design, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
				<add assembly="System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/></assemblies>
		</compilation>
		<httpHandlers>
			<remove verb="*" path="*.asmx"/>
			<add verb="*" path="*.asmx" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
			<add verb="*" path="*_AppService.axd" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
			<add verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" validate="false"/>
		</httpHandlers>
		<httpModules>
			<add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
		</httpModules>

    <membership>
      <providers>       
          <clear/>
          <add
              name="AspNetSqlMembershipProvider"
              type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
              connectionStringName="LocalSqlServer"
              enablePasswordRetrieval="false"
              enablePasswordReset="true"
              requiresQuestionAndAnswer="true"
              applicationName="pweb"
              requiresUniqueEmail="true"
              maxInvalidPasswordAttempts="5"
              minRequiredPasswordLength="5"
              minRequiredNonalphanumericCharacters="0"
              passwordAttemptWindow="10"
              
          />
       </providers>
    </membership>
		
		<!-- Role-->
		<roleManager enabled="true">
			<providers>
				<add name="SqlRoleManager" type="System.Web.Security.SqlRoleProvider" connectionStringName="LocalSqlServer" applicationName="pweb"/>
			</providers>
		</roleManager>
		
		<!-- Authentication-->
		<authentication mode="Forms">
			<forms loginUrl="login.aspx">
          
         </forms>
      
		</authentication>


	<system.web.extensions>
		<scripting>
			<webServices>
				<!-- Uncomment this line to customize maxJsonLength and add a custom converter -->
				<!--
      <jsonSerialization maxJsonLength="500">
        <converters>
          <add name="ConvertMe" type="Acme.SubAcme.ConvertMeTypeConverter"/>
        </converters>
      </jsonSerialization>
      -->
				<!-- Uncomment this line to enable the authentication service. Include requireSSL="true" if appropriate. -->
				<!--
        <authenticationService enabled="true" requireSSL = "true|false"/>
      -->
				<!-- Uncomment these lines to enable the profile service. To allow profile properties to be retrieved
           and modified in ASP.NET AJAX applications, you need to add each property name to the readAccessProperties and
           writeAccessProperties attributes. -->
				<!--
      <profileService enabled="true"
                      readAccessProperties="propertyname1,propertyname2"
                      writeAccessProperties="propertyname1,propertyname2" />
      -->
			</webServices>
			<!--
      <scriptResourceHandler enableCompression="true" enableCaching="true" />
      -->
		</scripting>
	</system.web.extensions>
	<system.webServer>
		<validation validateIntegratedModeConfiguration="false"/>
		<modules>
			<add name="ScriptModule" preCondition="integratedMode" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
		</modules>
		<handlers>
			<remove name="WebServiceHandlerFactory-Integrated"/>
			<add name="ScriptHandlerFactory" verb="*" path="*.asmx" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
			<add name="ScriptHandlerFactoryAppServices" verb="*" path="*_AppService.axd" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
			<add name="ScriptResource" preCondition="integratedMode" verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
		</handlers>
	</system.webServer>
</configuration>

Please help

I have some problems with a dropdownlist which is in a datalist. the dropdownlist is created statically and has only 4 items from 1 to 4, and it is in each row. when I get the dropdownlist selectedindex all of them just return the default value 0 even if user select another items!! Cry | :((

I use the following code to access the dropdownlist and the selectedindex

DropDownList drp= dstQuestions.Items[i].FindControl("DrpAnswer")as DropDownList ;
int answer = drp.SelectedIndex + 1;

(dstQuestions is the name of the DataList.)

answer always return 1 !! what is the problem?!

Does your dropdown list has enable Postback. By default its false with DropdownList. So all the you are getting index as 0 which is the first index.
Hope you got my point ! Thumbs Up | :thumbsup:

Cheers !
Abhijit Jana | My Blog | @Twitter | Daily .Net Tips

I want to draw a polygon using Graphic class on a webform, I use the following code but it doesn't show anything!!! D'Oh! | :doh:

protected void Page_Load(object sender, EventArgs e)
        {
            Bitmap objBitmap;
            Graphics objGraphics;

            objBitmap = new Bitmap(400, 440);
            objGraphics = Graphics.FromImage(objBitmap);
            objGraphics.Clear(Color.Blue); 
        }

even I delete all the HTML tag except

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="ImageResults.aspx.cs" Inherits="Yadgirandeh.WebForm5" %>;

I would be really grateful if anybody helps me.

You need to set the response type of the response, and then write the bitmap to the output stream of the response.

Something like (after your existing code)...

Response.ContentType = "image/jpeg";
Response.Clear();
Response.BufferOutput = true;
objBitmap.Save(Response.OutputStream, ImageFormat.Jpeg);
Response.Flush();

Assuming your other code is correct which I haven't really checked.

Dear All,

I have a serious problem with my website now, it is working very slow and i have to wait for 20 minutes for response.

I have a website using ASP.NET/C# connect to SQL SERVER 2008, webserver is IIS7 and .NET Framework v2.050727

Do you have any ideas?
I need your helps.

Thank you very much.

Best regards,
HY ChanHan

what have you done to isolate the problem? Is it the page rendering, the data access, or something else. How much ram? Is everything on a single machine? How much traffic? What is the network like? There are any number of things that could causing you problems, but with details we can't help

I know the language. I've read a book. - _Madmatt

I cannot find the problem at all now Frown | :(

RAM is 16GB.
my hosting server is Redundency (Clusters).

Network Architectures has:
1. Firewall
2. Switch
3. Check point
4. NAS (store photos)
5. SAN (database)

Please helps.

Best regards,
HY Chanhan

what about your code? How are you accessing the database? How is it being rendered? Please don't dump your entire application here either

I know the language. I've read a book. - _Madmatt

Codes is working fine, i have moved it to other machine and test my codes already it works fine as usual.

It just get slow performance this 30 days, before it works fine.

Well, if you are so convinced that neither the code nor the network or machine is the problem then I don't know what you expect any of us to do.

I know the language. I've read a book. - _Madmatt

Have you contacted you hosting company?
Maybe they have a problem, or your ISP is having difficulties.

------------------------------------

I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave

CCC Link[^]
Trolls[^]

hi all,

i have a webserver in which we host the web application
and a database server i.e sql server both server are different.

now my web page needs to interact with autocad application
but autocad is not installed in the webserver but it is installed in database server

i have a restriction to not to install the auto cad in web server but my web page should
interact with autocad application & generate the drawings in client system.

how can we solve this problem...

regards
vijay kumar

Hi,
I am mani. I have a problem in display the data in datagrid.
What i did is I am creating a form and in this form i created a 6 textboxes and one search button. whenever the user enter a text in textbox i retrieve the data from the database and displayed in the datagrid.
The problem is when the user again enter the text in text box the datagrid is filled with new data and last data will be lost. But i want that newly searching data should be displayed in datagrid including the last searching data.

This is my problem i sent last time to this portal. i got some answers. But using the DataTable i didnt get the answer. I write my code here. please tell me what is the wrong i did it in this.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
public partial class AdvanceSearch : System.Web.UI.Page
{
SqlConnection con;
SqlCommand cmd;
SqlDataAdapter adptr;
DataTable dt;
DataView dv;

protected void Page_Load(object sender, EventArgs e)
{
if (Session["mani"] == null)
{
dt = new DataTable();
Session["mani"] = dt;
}
else
{
dt = (DataTable)Session["mani"];
}
dv = new DataView(dt);
SearchResultGrid.DataSource = dv;
SearchResultGrid.DataBind();

}
protected void ButtonSearch_Click(object sender, EventArgs e)
{
con = new SqlConnection("Data Source=MVB;Initial Catalog=Communication; Integrated Security=True");
string select_query = "SELECT *FROM CommunicationDetails WHERE CommunicationId=@comid OR IssueType=@issue OR RegionName=@regname OR ApplicationName=@appname OR Descript=@Desc OR CommunicationDate=@comdate";
cmd = new SqlCommand(select_query, con);
cmd.Parameters.Add("@comid", TextBoxCommunicationID.Text);
cmd.Parameters.Add("@issue", TextIssueType.Text);
cmd.Parameters.Add("@regname", TextBoxRegionName.Text);
cmd.Parameters.Add("@appname", TextBoxApplicationName.Text);
cmd.Parameters.Add("@Desc", TextBoxDescription.Text);
cmd.Parameters.Add("@comdate", TextBoxDate.Text);

try
{
con.Open();
adptr = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adptr.Fill(ds);
dt = ds.Tables[0];
dv = new DataView(dt);
SearchResultGrid.DataSource = dv;
SearchResultGrid.DataBind();
con.Close()
}
catch(SqlException)
{
con.Close();
}
}
}

using this code i get the answer every time the user enter the data to search. but the last time the user searched data will be lost. i want that last time searching data including the present data.

regards,
Manikanta.

One possibility is that when you make a new query:
- save the last results in a datatable 1 (the currently binded datatable)
- execute a new query
- from the query save the results to datatable 2
- merge datatable 1 and 2 to datatable 3
- bind the datatable 3 to the grid

You can do this with two datatables also if you want. For information about Merge, see http://msdn.microsoft.com/en-us/library/fk68ew7b.aspx[^]

The need to optimize rises from a bad design.My articles[^]

hello sir,
I have a small problem how we can create chat application(video or audia) using asp 2.0. Actually i am working on Ecourt website i have a small requirment to chat face to face audio or video but i dont find any solution please help me.....

Avanish Kumar Rathour
faculty
(GL:- NIIT MORADABAD)
09456019010

have you tried skype? or google talk (I think they now have video too)?