Chap 16 - Sign Up for Your New Account, pg 584, #10

jkoyle · October 3rd, 2011, 04:32 PM

Imar, I have an issue with the SignUp.aspx properties. When I open it up in my browser, I get the yellow screen of death (Login failed for user 'Gateway_64\Jack'). I know how to correct this, I just don't know where to fix it.

I'm trying to find the Data-source property so I can change it to PlanetWrox.mdf.

I just can't find the correct place to make the change. I've looked through all my Connection Settings with no luck.

You usually have excellent suggestions. Can you point me in the correct direction?

Thanks,
Jack Koyle

Imar · October 3rd, 2011, 05:32 PM

Sounds like a problem with the Membership services? Check out Appendix B to see how to override the settings for Membership, Roles and Profile.

Are you not using a SqlExpress installation?

Imar

jkoyle · October 3rd, 2011, 06:34 PM

Thanks, I am using SqlExpress, my login/connection instance should be Gateway_64\SqlExpress

I'll check out Appendix B and let you know

Thanks
Jack Koyle

Imar · October 3rd, 2011, 06:52 PM

If you are using SQL Express, then you shouldn't be getting this error. Does your other data access against sql express work fine?

Imar

jkoyle · October 3rd, 2011, 08:13 PM

Yes, Imar. All the other connections work fine. It's just SignUp.aspx that's not working correctly.

jkoyle · October 4th, 2011, 02:27 PM

Imar,

I've managed to change the following error message..........

Server Error in '/Site2' Application.

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Named Pipes Provider, error: 0 - No process is on the other end of the pipe.)

Do I fix this pipe issue using the SQL Server Management Studio Tool? I've seen something about pipes before, but I've looked thru the security area in the Object Explorer and can't find anything about pipes.

Any suggestions?

Thanks,

jack Koyle

Imar · October 4th, 2011, 03:25 PM

Can you show me the code for your web.config? And are you really sure this is an instance of SQL Server Epress, and not a regular installation of SQL Server just *called* SQL Express? How did you install it? And what do you get when you execute

select @@version

in a query window against SQL Server?

Imar

jkoyle · October 4th, 2011, 04:49 PM

I'm attaching my web.config file and I will send you a screen dump of select @@version to your email since I don't know how to attach anything to this message.

I've installed Microsoft SQL Server 2008 R2 with all applicable updates.

Code:

<?xml version="1.0"?>
<!--
  For more information on how to configure your ASP.NET application, please visit
  http://go.microsoft.com/fwlink/?LinkId=169433
  -->
<configuration>
  <connectionStrings>
    <add name="PlanetWroxConnectionString1" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\PlanetWrox.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>
    <add name="PlanetWroxEntities" connectionString="metadata=res://*/App_Code.PlanetWrox.csdl|res://*/App_Code.PlanetWrox.ssdl|res://*/App_Code.PlanetWrox.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\PlanetWrox.mdf;Integrated Security=True;User Instance=True;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient"/>
  </connectionStrings>
  <system.web>
    <roleManager enabled="true" />
    <membership>
      <providers>
        <clear />
        <add
          name="AspNetSqlMembershipProvider"
          type="System.Web.Security.SqlMembershipProvider, System.Web, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
          connectionStringName="LocalSqlServer"
          enablePasswordRetrieval="false"
          enablePasswordReset="true"
          requiresQuestionAndAnswer="false"
          applicationName="/"
          requiresUniqueEmail="false"
          passwordFormat="Hashed"
          maxInvalidPasswordAttempts="5"
          minRequiredPasswordLength="6"
          minRequiredNonalphanumericCharacters="1"
          passwordAttemptWindow="10"
          passwordStrengthRegularExpression=""
      />
      </providers>
    </membership>
    <authentication mode="Forms" />
    <pages theme="Monochrome">
      <controls>
        <add tagPrefix="Wrox" tagName="Banner" src="~/Controls/Banner.ascx"/>
      </controls>
    </pages>
    <compilation debug="false" strict="false" explicit="true" targetFramework="4.0">
      <assemblies>
        <add assembly="System.Security, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
        <add assembly="System.Data.Entity, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" />
        <add assembly="System.Data.Entity.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" />
      </assemblies>
      <buildProviders>
        <add extension=".edmx" type="System.Data.Entity.Design.AspNet.EntityDesignerBuildProvider"/>
      </buildProviders>
    </compilation>
  </system.web>
  <system.net>
    <mailSettings>
      <smtp deliveryMethod="Network" from="Jack Koyle &lt;[email protected]&gt;">
        <network enableSsl="true" userName="[email protected]"
                 password="zogm2009" host="smtp.gmail.com" />
      </smtp>
    </mailSettings>
  </system.net>
  <location path="Management">
    <system.web>
      <authorization>
        <allow roles="Managers" />
        <deny users="*" />
      </authorization>
    </system.web>
  </location>
</configuration>

jkoyle · October 5th, 2011, 08:45 AM

Imar,

This is a local machine. Gateway_64 is just the name of the PC that is made by Gateway. I have several Gateway machines, but this is the only 64 bit machine that I own. That's why I named it Gateway_64

Here is the result of the execution of select @@version. I connected to .\SqlExpress before executing the command.

Microsoft SQL Server 2008 (SP2) - 10.0.4000.0 (X64) Sep 16 2010 19:43:16 Copyright (c) 1988-2008 Microsoft Corporation Express Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

If you prefer a complete screen dump, let me know.

I hope this information helps.

Jack Koyle

Imar · October 5th, 2011, 09:28 AM

Then I really don't understand why it doesn't work. Can you try this:

1. Choose File | New Website

2. Drag a Login control onto Default.aspx

3. Request Default.apsx in your browser and try to log in. It doesn't matter you don't have any user accounts created.

Does that work? Does it crash, or do you get a message saying that your login attempt failed?

Imar