Login Issue when copied to webserver

Question

User253527838 posted

Hello,

I cannot login to the Time Tracker Starter kit when I copy the application to the Webserver. I am not receiving an error message. When you try to login, it appears as if the page refreshes. I am having the same issue with the personal web site starter kit. I have read through the post but I cannot seem to find my issue. Here is the web.config file.

 Thanks,

<?xml version="1.0"?><?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>

<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0"><o:p></o:p>

      <connectionStrings><o:p></o:p>

            <add name="aspnet_staterKits_TimeTracker"

                 connectionString= "Data Source=.\SQLExpress;

                                    Integrated Security=True;

                                    AttachDBFilename=|DataDirectory|TimeTracker.mdf;

                                    User Instance=true" /><o:p></o:p>

            <remove name="LocalSqlServer"/><o:p></o:p>

            <add name="LocalSqlServer" c

                 onnectionString="Data Source=.\SQLExpress;

                                  Integrated Security=True;

                                  AttachDBFilename=|DataDirectory|TimeTracker.mdf;

                                  User Instance=true" /><o:p></o:p>

      </connectionStrings><o:p></o:p>

      <system.web><o:p></o:p>

            <siteMap defaultProvider="AspNetXmlSiteMapProvider" enabled="true"><o:p></o:p>

                  <providers><o:p></o:p>

                        <clear /><o:p></o:p>

                        <add name="AspNetXmlSiteMapProvider"<o:p></o:p>

                             type="System.Web.XmlSiteMapProvider,

                                   System.Web,

                                   Version=2.0.3600.0,

                                   Culture=neutral,

                                   PublicKeyToken=b03f5f7f11d50a3a"<o:p></o:p>

                              siteMapFile="web.sitemap"<o:p></o:p>

                              securityTrimmingEnabled="true"  /><o:p></o:p>

                  </providers><o:p></o:p>

            </siteMap><o:p></o:p>

            <authentication mode="Forms"><o:p></o:p>

                  <forms loginUrl="~/TimeTracker/login.aspx"/><o:p></o:p>

            </authentication><o:p></o:p>

            <compilation debug="false" /><o:p></o:p>

            <customErrors mode="Off"/><o:p></o:p>

            <machineKey decryptionKey="AutoGenerate,IsolateApps"/><o:p></o:p>

            <roleManager enabled="true" /><o:p></o:p>

    </system.web><o:p></o:p>

</configuration><o:p></o:p>

 

Answer 1

User-1853252149 posted

You need to configure the membership database on the web server.  How you do that depends on what your web server supports (SQL Express, SQL 2000, SQL 2005, etc.)

Jeff

Answer 2

User253527838 posted

The web server is running Windows 2003 Server and has both SQL Server 2000 and SQL Server 2005 Express Edition installed. How do I configure the membership database?

 Thank.

Answer 3

User253527838 posted

Ok,

I am still confused.When developing inside of VS 2005 Express everything works fine (obviously). So I went to the web server, and ran aspnet_regsql tool and configured a SQL Server 2000 database named temp. All of the table and sp's were correctly build inside the the database. I then altered my web.config file as follows:

<?xml version="1.0"?><?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>

<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0"><o:p></o:p>

  <connectionStrings><o:p></o:p>

    <clear /><o:p></o:p>

    <remove name="LocalSqlServer" /><o:p></o:p>

    <add name="LocalSqlServer"

        connectionString="Data Source=CH5W2AS03\WIZDATAMANAGER;Initial Catalog=temp;Persist Security Info=True;User ID=XXXXX;Password=XXXXX"<o:p></o:p>

        providerName="System.Data.SqlClient" /><o:p></o:p>

    <add name="Personal"

        connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Personal.mdf"<o:p></o:p>

        providerName="System.Data.SqlClient" /><o:p></o:p>

  </connectionStrings><o:p></o:p>

  <system.web><o:p></o:p>

    <identity impersonate="false" /><o:p></o:p>

    <pages styleSheetTheme="White"/><o:p></o:p>

    <customErrors mode="Off"/><o:p></o:p>

    <compilation debug="true" /><o:p></o:p>

    <authentication mode="Forms"><o:p></o:p>

    <forms loginUrl="Default.aspx" protection="Validation" timeout="300" /><o:p></o:p>

  </authentication><o:p></o:p>

  <authorization><o:p></o:p>

    <allow users="*"/><o:p></o:p>

  </authorization><o:p></o:p>

  <globalization requestEncoding="utf-8" responseEncoding="utf-8"/><o:p></o:p>

  <roleManager enabled="true"/><o:p></o:p>

  <siteMap defaultProvider="XmlSiteMapProvider" enabled="true"><o:p></o:p>

    <providers><o:p></o:p>

      <add name="XmlSiteMapProvider"<o:p></o:p>

           description="SiteMap provider which reads in .sitemap XML files."<o:p></o:p>

           type="System.Web.XmlSiteMapProvider, System.Web, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"<o:p></o:p>

           siteMapFile="web.sitemap"<o:p></o:p>

           securityTrimmingEnabled="true"<o:p></o:p>

      /><o:p></o:p>

    </providers><o:p></o:p>

  </siteMap><o:p></o:p>

</system.web><o:p></o:p>

<location path="Admin"><o:p></o:p>

  <system.web><o:p></o:p>

    <authorization><o:p></o:p>

      <allow roles="Administrators"/><o:p></o:p>

      <deny users="*"/><o:p></o:p>

    </authorization><o:p></o:p>

  </system.web><o:p></o:p>

</location><o:p></o:p>

</configuration>

 

Again, when I run the application in VS Studio Express 2005, everything works fine. When I go the intranet site and try to login, nothing happens. It appears that the page just refreshes. I have tried building 3 different starter kits, and I am have the same issue will all of them. I cannot login. <o:p></o:p>

<o:p> </o:p>

I do not know what else I need to configure. Any thoughts? Thanks.<o:p></o:p>

 

Answer 4

User555306248 posted

For me it is working fine...

Answer 5

User555306248 posted

Try to use utility aspnet_regsql

Check whether there is any entry in DB for users

Try to create new user using wizard and then try with that username..