Membership Management - problem reading users from SQL 2005

Hello,

I've configured SQL server 2005 as my back-end data store via
aspnet_regsql.exe. I presume it was succesvol. Creating users en roles
programmatically is no problem. When I start the Web Site Administration
Tool I can see the created users and roles. But when I want to show them
by code I get an empty result.

...
... Roles.GetAllRoles()
...
... membership.GetAllUsers()

The roleManager is enabled in web.config.

<roleManager enabled="true" defaultProvider="AspNetSqlRoleProvider">
<providers>
<clear />
<add connectionStringName="LocalSqlServer"
applicationName="/"
name="AspNetSqlRoleProvider"
type="System.Web.Security.SqlRoleProvider,System.Web, Version=2.0.0.0,
Culture=neutral,PublicKeyToken=b03f5f7f11d50a3a" />
</providers>
</roleManager>

My membership provider:

<membership defaultProvider="AspNetSqlMembershipProvider">
<providers>
<clear />
<add name="AspNetSqlMembershipProvider"
connectionStringName="LocalSqlServer" applicationName="/"
requiresQuestionAndAnswer="true"
type="System.Web.Security.SqlMembershipProvider,
System.Web,Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b03f5f7f11d50a3a" />
</providers>
</membership>

My connectionstrings:

<connectionStrings>
<remove name="LocalSqlServer" />
<add name="LocalSqlServer" connectionString="data source=NET\NET;Initial
Catalog=Tekstbank;User ID=adminTekstbank;Password=*****"
providerName="System.Data.SqlClient" />
<add name="TekstbankConnectionString" connectionString="Data
Source=NET\NET;Initial Catalog=Tekstbank;User
ID=adminTekstbank;Password=*****"
providerName="System.Data.SqlClient" />
</connectionStrings>

Can someone give me advice about this problem?

Friendly greetings,
Pieter

*** Sent via Developersdex http://www.developersdex.com ***
.

Relevant Pages