Need help configuring security and role management settings for website

[Philipp Lenz]

I'm completely new to ASP.Net 2.0 and I'm baffled about what to do to
get this to work.
FYI, I'm not new at this, I've used asp.net 1.1 for allmost 4 years
now.

I'm running a development machine running Team Foundation Server,
VS.net 2005 Team Suite and SQL Server 2005, all freshly installed and
working (all final, no betas).

I've built my first website and, having worked with sharepoint for
years, wanted to play with the new asp.net 2.0 webpart framework.

Okay, now I'm required to configure the role management and security
setup before this can work, so I start the configuration website where
I want to configure the sql server provider...with out success.

I learn that because I do not use SQL Server Express I have to
configure the database myself.
I start the aspnet_regsql tool and it creates an aspnet databse in my
local sql server 2005.
Okay, now I try, once again, to configure the provider, no luck (no
connection could be established)

So now I learn that I have to configure the connection string myself,
which I do, i configure it to use the sql server on localhost using
integrated security with the aspnet db as the default catalog.

It STILL won't work, now it tells me something about shared memory,
sometimes it tells me that access for Server\Administ rator (the user
that I'm logged in as) could not be established (?? how can this
be??).

Now I'm absolutely clueless what to do to get this to work, why is
this so hard and confusing?? Why can't the admin website ask me about
connection settings and accounts, why do I have to us command line
tools and why do I get cryptic error messages?

I would understand if the products I used where CTPS or Betas, but
they are ALL final.

Please help me with this!!

Philipp Lenz

[Oldman]

You need to configure your membership and role providers by adding settings
like the following to your web.config file:

<membership defaultProvider ="MySqlProvider " userIsOnlineTim eWindow="20"
hashAlgorithmTy pe="MD5">
<providers>
<add connectionStrin gName="MyConnSt ring"
enablePasswordR etrieval="false "
enablePasswordR eset="true" requiresQuestio nAndAnswer="tru e"
passwordFormat= "Hashed" applicationName ="MyApp"
name="MySqlProv ider"
type="System.We b.Security.SqlM embershipProvid er" />
</providers>
</membership>
<roleManager defaultProvider ="MySqlProvider "
enabled="true"
cacheRolesInCoo kie="true"
cookieName=".AS PROLES"
cookieTimeout=" 30"
cookiePath="/"
cookieRequireSS L="false"
cookieSlidingEx piration="true"
cookieProtectio n="All" >
<providers>
<add
name="MySqlProv ider"
type="System.We b.Security.SqlR oleProvider"
connectionStrin gName="MyConnSt r"
applicationName ="MyApp" />
</providers>
</roleManager>
"Philipp Lenz" wrote:

I'm completely new to ASP.Net 2.0 and I'm baffled about what to do to
get this to work.
FYI, I'm not new at this, I've used asp.net 1.1 for allmost 4 years
now.

I'm running a development machine running Team Foundation Server,
VS.net 2005 Team Suite and SQL Server 2005, all freshly installed and
working (all final, no betas).

I've built my first website and, having worked with sharepoint for
years, wanted to play with the new asp.net 2.0 webpart framework.

Okay, now I'm required to configure the role management and security
setup before this can work, so I start the configuration website where
I want to configure the sql server provider...with out success.

I learn that because I do not use SQL Server Express I have to
configure the database myself.
I start the aspnet_regsql tool and it creates an aspnet databse in my
local sql server 2005.
Okay, now I try, once again, to configure the provider, no luck (no
connection could be established)

So now I learn that I have to configure the connection string myself,
which I do, i configure it to use the sql server on localhost using
integrated security with the aspnet db as the default catalog.

It STILL won't work, now it tells me something about shared memory,
sometimes it tells me that access for Server\Administ rator (the user
that I'm logged in as) could not be established (?? how can this
be??).

Now I'm absolutely clueless what to do to get this to work, why is
this so hard and confusing?? Why can't the admin website ask me about
connection settings and accounts, why do I have to us command line
tools and why do I get cryptic error messages?

I would understand if the products I used where CTPS or Betas, but
they are ALL final.

Please help me with this!!

Philipp Lenz