Re: Error Message When Trying to Use Login Wizard

KevinK3344 — Sun, 18 Dec 2005 23:56:20 GMT

By default asp.net 2.0 looks in the machine.config file for the connection string: LocalSQLServer. I would just override this by placing your own like so:

<add name="LocalSqlServer" connectionString=<your connection string> providerName="System.Data.SqlClient"/>

</connectionStrings>

Re: Error Message When Trying to Use Login Wizard

sschack — Fri, 16 Dec 2005 21:04:30 GMT

It might be that the default personalization provider is being used (a WebPartManager uses personalization providers for persistence) - and that is what is still looking for the SSE database. Just as you did with <membership>, redefine the personalization provider under the <webParts><personalization> element to use your new connection string.

Go Jets!

Error Message When Trying to Use Login Wizard

boyd5 — Thu, 15 Dec 2005 16:07:46 GMT

Hi,

I'm trying to test out the new security features of asp.net 2.0. I've used the aspnet_regsql utility to attach the sql information to the application that I'm using to test this out. The aspnet tables have been created in my sql server 2000 database which is on a different machine.

My config file looks like this:

<?xml version="1.0"?>

<add name="Main.ConnectionString"

connectionString="data source=BARNEY-DEV\DEV;initial catalog=irisCit3;password=JetsSuck03;persist security info=True;user id=sa;workstation id=SMITHERS;packet size=4096"

providerName="System.Data.SqlClient"/>

</connectionStrings>

<system.web>

<forms

name="SqlAuthCookie"

timeout="10" />

</authentication>

<add

name="SqlProvider"

type="System.Web.Security.SqlMembershipProvider"

connectionStringName="Main.ConnectionString"

applicationName="AdamTest"

enablePasswordRetrieval="false"

enablePasswordReset="true"

requiresQuestionAndAnswer="true"

requiresUniqueEmail="true"

passwordFormat="Hashed" />

</providers>

</membership>

</system.web>

</appSettings>

<system.net>

</smtp>

</mailSettings>

</system.net>

</configuration>

I've dropped a webparts manager onto my page, and then I added the Login Wizard control. I get this error when I run the app in debug mode:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

I'm not trying to connect to sql server 2005 and I do not have sql server express edition installed, I'm trying to connect to a remote instance of sql server on my network. I've tried various things to make this work... but to no avail. Can anyone help me with this?

If you need any more information I can post it for you.