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"?>
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
<connectionStrings>
<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>
<authentication mode="Forms">
<forms
name="SqlAuthCookie"
timeout="10" />
</authentication>
<compilation debug="true"/>
<membership defaultProvider="SqlProvider" userIsOnlineTimeWindow="15">
<providers>
<clear />
<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>
<add key="Main.ConnectionString" value="data source=BARNEY-DEV\DEV;initial catalog=irisCit3;password=JetsSuck03;persist security info=True;user id=sa;workstation id=IIRX3;packet size=4096"/>
<add key="iirxerrorcheck.ConnectionString" value="Password=JetsSuck03;data source=BARNEY-DEV\DEV;initial catalog=iirx-errocheck;persist security info=False;user id=sa;workstation id=SMITHERS;packet size=4096"/>
</appSettings>
<system.net>
<mailSettings>
<smtp from="irissys@iirx.net">
<network host="mail.iirx.net" password="shawn222" userName="irissys@iirx.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.