Server Error in '/Classifieds' Application.

---

Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

Source Error:

Line 7:  	{
Line 8:  
Line 9:  		if (!Roles.RoleExists("Administrators")) Roles.CreateRole("Administrators");
Line 10: 		if (!Roles.RoleExists("Guests")) Roles.CreateRole("Guests");
Line 11: 

[SqlException (0x80131904): Timeout expired.  The tim

Is there something not clear about this ?

Basically, it says - there was a data base query, but the sql server has not been able to process it within the default timeout (30 seconds) if you have not modified it. 

Thanks,


Yani Dzhurov

Here is some more background.

As you will see, I have been picking through this step by step.  There should be some simply 1, 2, 3, step documentation to avoid these issues.  For that matter, I have yet to set this up on a public facing server, so I need to be able to replicate the implementation and resolve any issues, just so I can use this.

 Here is where I started.

 http://forums.asp.net/thread/1572388.aspx

 then the error I posted recently is the latest episode.

 I simply want this thing to work as described.

OK, I see now.

See where it does point your connection string to?

Search for it in the web.config file, connectionStrings section. 

Thanks,


Yani Dzhurov

What should the string be?

Also, I've been so disappointed in the implementation, that now I fear I have forgotten the admin password.  I don't recall changing anything and now I can't seem to find it.

it would be more useful if you paste the whole connectionString section.

"LocalSqlServer' does not talk to me at all. 

Thanks,


Yani Dzhurov

<?xml version="1.0"?>
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
 <location path="Admin">
  <system.web>
   <authorization>
    <allow roles="Administrators"/>
    <deny users="*"/>
   </authorization>
  </system.web>
 </location>
 <location path="PostAd.aspx">
  <system.web>
   <authorization>
    <deny users="?"/>
   </authorization>
  </system.web>
 </location>
 <location path="EditPhotos.aspx">
  <system.web>
   <authorization>
    <deny users="?"/>
   </authorization>
  </system.web>
 </location>
 <location path="MyAds.aspx">
  <system.web>
   <authorization>
    <deny users="?"/>
   </authorization>
  </system.web>
 </location>
 <location path="MyProfile.aspx">
  <system.web>
   <authorization>
    <deny users="?"/>
   </authorization>
  </system.web>
 </location>
 <system.web>
  <customErrors defaultRedirect="Error.aspx" mode="RemoteOnly"/>
  <pages styleSheetTheme="Blue"/>
  <authentication mode="Forms"/>
  <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="/" requiresUniqueEmail="true" passwordFormat="Hashed" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="7" minRequiredNonalphanumericCharacters="1" passwordAttemptWindow="10" passwordStrengthRegularExpression=""/>
   </providers>
  </membership>
  <profile enabled="true">
   <properties>
    <add name="FirstName" type="System.String"/>
    <add name="LastName" type="System.String"/>
    <add name="MemberId" defaultValue="0" type="System.Int32"/>
    <group name="Core"/>
   </properties>
  </profile>
  <roleManager enabled="true"/>
  <siteMap defaultProvider="RoleEnabled_AspNetXmlSiteMapProvider" enabled="true">
   <providers>
    <clear/>
    <add name="RoleEnabled_AspNetXmlSiteMapProvider" type="System.Web.XmlSiteMapProvider, System.Web, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" siteMapFile="web.sitemap" securityTrimmingEnabled="true"/>
   </providers>
  </siteMap>
  <compilation debug="true"/></system.web>
 <connectionStrings>
  <add name="classifiedsConnection" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\classifiedsdb.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>
 </connectionStrings>
 <system.net>
  <mailSettings>
   <smtp from="[email protected]">
    <network host="intranetsmtp.yourdomain.com" password="" userName="" />
   </smtp>
  </mailSettings>
 </system.net>
</configuration>

I'll try help you as best I can but you need to provide more info. What have you done so far. Have you applied the sql script to your database? Have you set up access to the database for the windows accounts? Have you configure a user(admin) account through Visual web developer?

1-create a directory on the drives root, and copy the classfields project to it.

2- In IIS created a new website, and point its home directory to the directory of the Classfields.

3- Create a new application pool, its not advised to use any common application pool for this site

4-In the APP_DATA directory of clasfields there are some *.sql files to be found, double click each one of them, and execute it in the SQL server managment studio, they will add tables and stuff to the MAIN system database. just for some extra development help, attach the 2 databases with the extension *.MDF to the SQL server, to do that go to the summry windows and click on the mouses right button, and then choose attach, then click ADD and then navigate to he databases in the APP_data directory.

5-C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727 this directory is just for a default estimate, but it will be dependant on which drive or cluster you have installed your OS on. search for a file in this directory called ASPNET_REGSQL.exe double click this file, a wizard will open, click next choose configure SQL server for application service and then click next, write down your SQL server name, (incase you dont know the server name, open the SQL server managment studio, and you will find it there easily on the topmost window on the left side under Database Engine) choose the MASTER database follow the wizard untill its over.

go back to IIS server manager, open the WEB SITES category go to the website you created for the classfields application, right click the websites name and choose properties, go to the ASP.NET tab, choose 2.050727, and then click on edit configuration, a popup window will open, click on LOCALSQLSERVER and click EDIT paste this string in the connection paramters

Server=YOUR SERVER NAME;Database=WhateverYouNamedIt;Trusted_Connection=True;

(this is for "windows authentication only"........Trusted_Connection=True;)

paste the same string in Classfield connection. click apply and then ok,

and you are done.