ASP.NET 2.0 Can't Connect To Aspnetdb On SQL Server 2000

Running ASP.NET 2.0 on a Windows SBS2000 with IIS5 and SQLServer 2000 on the same box.

Trying to use membership controls to authenticate.

Installed aspnetdb on the server using aspnet_regsql.exe

Ran an ASPX page with the asp:CreateUserWizard control.

The "create user" button returns the following error:

     A user instance was requested in the connection string but the server specified does not support this option

I appears that the connection string I am using is wrong.(See below for web.config entries)

I have tried:

"data source=RGMILLSITES;Integrated Security=True;database=aspnetdb;User Instance=True"
"data source=RGMILLSITES;Integrated Security=True;database=aspnetdb;User Instance=False"
"data source=RGMILLSITES;Integrated Security=True;database=aspnetdb"
"data source=RGMILLSITES;Integrated Security=True;Initial Catalog=aspnetdb;User Instance=False"
"data source=RGMILLSITES;Integrated Security=True;Initial Catalog=aspnetdb"

I have renamed LocalSqlServer to LocalSqlServerASPNETDB to ensure that a global configuration is not used.

I tried to rename the server in the connection string and got the same error
"data source=RGMILLSITES00;Integrated Security=True;Initial Catalog=aspnetdb"

I've checked the Machine.config and web.config in the
C:WINNTMicrosoft.NETFrameworkv2.0.50727CONFIG folder
Neither have the LocalSqlServerASPNETDB configuration listed.
 

So now I'm thinking there is a cashing isssue.
I've tried to restart the site and got the same result.


Any thoughts would be appreciated.

RobGMiller

 


The web.config file contains the following related skeema.

<connectionStrings>
  <add name="LocalSqlServerASPNETDB"
       connectionString="data source=RGMILLSITES;Integrated Security=True;Initial Catalog=aspnetdb;User Instance=False"
       ProviderName="System.Data.SqlClient" />
</connectionStrings>

<roleManager enabled="true" defaultProvider="CustomizedRoleProvider">
   <providers>
      <add name="CustomizedRoleProvider"
   type="System.Web.Security.SqlRoleProvider"
   connectionStringName="LocalSqlServerASPNETDB" />
   </providers>
</roleManager>

<membership defaultProvider="CustomizedProvider">
   <providers>
      <add name="CustomizedProvider"
    type="System.Web.Security.SqlMembershipProvider"
   connectionStringName="LocalSqlServerASPNETDB"
   applicationName="/"
          minRequiredPasswordLength="5"
   minRequiredNonalphanumericCharacters="0"/>
   </providers>
</membership>