Membership Management - problem reading users from SQL 2005

[Pieter S]

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

 

[PeterKellner]

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.

Pieter,

The website config program uses your web.config so if that tool works,
so should your app. Very strange. I'd suggest downloading my
ObjectDataSource and trying it. It completely incapsulates Membership
and Roles (in code of course). If that works, you will see examples
of how to call the API working.

Good Luck,

Here is a link to the post with the MSDN article and code:
http://peterkellner.net/?p=24
Peter Kellner
http://peterkellner.net