ASP.NET Configuration Tool

[Jonathan Wood]

Okay, I've been through this a couple of times now but it's still not coming
together.

I have an existing Website that I need to add ASP.NET membership
functionality to. So, after manually messing around with the Web.Config file
for a while, I finally got the ASP.NET Configuration Tool to stop
complaining about being able to connect to my data source.

But when I attempt to access the security tab, I get the error "Could not
find stored procedure 'dbo.aspnet_CheckSchemaVersion'."

I understand the reason for this error, but I thought the ASP.NET
Configuration Tool would initialize the database automatically. I know
there's a command-line utility for this but I'm sure I didn't need it
before.

Why isn't the ASP.NET Configuration Tool able to initialize membership in a
database. And, for that matter, why do I need to know how to manually find
and edit the connection strings every time I create a project. Does
Microsoft not consider this something the IDE should be making a little bit
more intuitive?

Thanks for any advice.

Jonathan

[sloan]

My personal opinion is that ...that tool is for hobbyists.
The biggest grudge is that it only works locally, and apparently sucks at
that as well.

http://weblogs.asp.net/scottgu/archi...25/423703.aspx

And I would "code up" a few pages. MSDN has 90% of the code done for you,
with adding users and such.

Writing my own backdoor pages (with security of course) saved me more time
than jerking around with that tool.

...

My opinion is one of a billion, so take it with a grain of salt.

Good luck.

"Jonathan Wood" <jw***@softcircuits.comwrote in message
news:uP**************@TK2MSFTNGP02.phx.gbl...

Okay, I've been through this a couple of times now but it's still not
coming together.

I have an existing Website that I need to add ASP.NET membership
functionality to. So, after manually messing around with the Web.Config
file for a while, I finally got the ASP.NET Configuration Tool to stop
complaining about being able to connect to my data source.

But when I attempt to access the security tab, I get the error "Could not
find stored procedure 'dbo.aspnet_CheckSchemaVersion'."

I understand the reason for this error, but I thought the ASP.NET
Configuration Tool would initialize the database automatically. I know
there's a command-line utility for this but I'm sure I didn't need it
before.

Why isn't the ASP.NET Configuration Tool able to initialize membership in
a database. And, for that matter, why do I need to know how to manually
find and edit the connection strings every time I create a project. Does
Microsoft not consider this something the IDE should be making a little
bit more intuitive?

Thanks for any advice.

Jonathan

[Jonathan Wood]

Well, it would be a lot of work to create all the tables, stored procedures,
etc. associated with ASP.NET membership. And, as I mentioned, I didn't have
to do that before as there is something that can generate them
automatically. So my opinions regarding the membership data objects is a
separate issue on using this tool in general.

As far as regular settings, which is what you seem to be mostly referring
to, my problem there is that VS now dumps tons of stuff in there. How could
I possibly be expected to remember what each of these settings does,
especially when I'm trying to learn C#, SQL, CSS, ASP.NET, HTML, Web
services, etc., etc? For these, it seems like some type of tool is
necessary.

BTW, I haven't tried it but was under the impression that the configuration
tool works not just for a local database. I'd be curious why you say it
doesn't handle that. Doesn't it just need the right connection string?

Thanks.

--
Jonathan Wood
SoftCircuits Programming
http://www.softcircuits.com

"sloan" <sl***@ipass.netwrote in message
news:eP**************@TK2MSFTNGP03.phx.gbl...

>
My personal opinion is that ...that tool is for hobbyists.
The biggest grudge is that it only works locally, and apparently sucks at
that as well.

http://weblogs.asp.net/scottgu/archi...25/423703.aspx

And I would "code up" a few pages. MSDN has 90% of the code done for you,
with adding users and such.

Writing my own backdoor pages (with security of course) saved me more time
than jerking around with that tool.

..

My opinion is one of a billion, so take it with a grain of salt.

Good luck.

"Jonathan Wood" <jw***@softcircuits.comwrote in message
news:uP**************@TK2MSFTNGP02.phx.gbl...

>Okay, I've been through this a couple of times now but it's still not
coming together.

I have an existing Website that I need to add ASP.NET membership
functionality to. So, after manually messing around with the Web.Config
file for a while, I finally got the ASP.NET Configuration Tool to stop
complaining about being able to connect to my data source.

But when I attempt to access the security tab, I get the error "Could not
find stored procedure 'dbo.aspnet_CheckSchemaVersion'."

I understand the reason for this error, but I thought the ASP.NET
Configuration Tool would initialize the database automatically. I know
there's a command-line utility for this but I'm sure I didn't need it
before.

Why isn't the ASP.NET Configuration Tool able to initialize membership in
a database. And, for that matter, why do I need to know how to manually
find and edit the connection strings every time I create a project. Does
Microsoft not consider this something the IDE should be making a little
bit more intuitive?

Thanks for any advice.

Jonathan

[sloan]

Did you follow the link I provided?

It shows how to setup a db on any server with a wizard.

"Jonathan Wood" <jw***@softcircuits.comwrote in message
news:eJ**************@TK2MSFTNGP03.phx.gbl...

Well, it would be a lot of work to create all the tables, stored
procedures, etc. associated with ASP.NET membership. And, as I mentioned,
I didn't have to do that before as there is something that can generate
them automatically. So my opinions regarding the membership data objects
is a separate issue on using this tool in general.

As far as regular settings, which is what you seem to be mostly referring
to, my problem there is that VS now dumps tons of stuff in there. How
could I possibly be expected to remember what each of these settings does,
especially when I'm trying to learn C#, SQL, CSS, ASP.NET, HTML, Web
services, etc., etc? For these, it seems like some type of tool is
necessary.

BTW, I haven't tried it but was under the impression that the
configuration tool works not just for a local database. I'd be curious why
you say it doesn't handle that. Doesn't it just need the right connection
string?

Thanks.

--
Jonathan Wood
SoftCircuits Programming
http://www.softcircuits.com

"sloan" <sl***@ipass.netwrote in message
news:eP**************@TK2MSFTNGP03.phx.gbl...

>>
My personal opinion is that ...that tool is for hobbyists.
The biggest grudge is that it only works locally, and apparently sucks at
that as well.

http://weblogs.asp.net/scottgu/archi...25/423703.aspx

And I would "code up" a few pages. MSDN has 90% of the code done for
you, with adding users and such.

Writing my own backdoor pages (with security of course) saved me more
time than jerking around with that tool.

..

My opinion is one of a billion, so take it with a grain of salt.

Good luck.

"Jonathan Wood" <jw***@softcircuits.comwrote in message
news:uP**************@TK2MSFTNGP02.phx.gbl...

>>Okay, I've been through this a couple of times now but it's still not
coming together.

I have an existing Website that I need to add ASP.NET membership
functionality to. So, after manually messing around with the Web.Config
file for a while, I finally got the ASP.NET Configuration Tool to stop
complaining about being able to connect to my data source.

But when I attempt to access the security tab, I get the error "Could
not find stored procedure 'dbo.aspnet_CheckSchemaVersion'."

I understand the reason for this error, but I thought the ASP.NET
Configuration Tool would initialize the database automatically. I know
there's a command-line utility for this but I'm sure I didn't need it
before.

Why isn't the ASP.NET Configuration Tool able to initialize membership
in a database. And, for that matter, why do I need to know how to
manually find and edit the connection strings every time I create a
project. Does Microsoft not consider this something the IDE should be
making a little bit more intuitive?

Thanks for any advice.

Jonathan

[Jonathan Wood]

Juan,

re:
!For one thing, he says where this utility is located, under the
framework 2.0
!subdirectories, where I found it. But there is no such utility under
the 3.0
!or 3.5 subdirectories.

That's because there's no need for them there.
Both the 3.0 and 3.5 framework address the 2.0 CLR.

I don't know what this means. If I don't have the 2.0 framework installed,
and I don't have this utilitiy, then how am I supposed to initialize my
membership database?

Jonathan

[Juan T. Llibre]

re:
!I don't know what this means.

You should know what it means.

re:
!If I don't have the 2.0 framework installed, and I don't have this utilitiy,
!then how am I supposed to initialize my membership database?

If you install the 3.0 or the 3.5 framework, that setup will install the 2.0 framework.
The basic fact is that the post-2.0 frameworks: 2.0, 3.0 and 3.5, all rely on the 2.0 CLR.

You initialize your membership database in the same way for 2.0, 3.0 and 3.5.


Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
======================================
"Jonathan Wood" <jw***@softcircuits.comwrote in message news:em**************@TK2MSFTNGP04.phx.gbl...

Juan,

>re:
!For one thing, he says where this utility is located, under the framework 2.0
!subdirectories, where I found it. But there is no such utility under the 3.0
!or 3.5 subdirectories.

That's because there's no need for them there.
Both the 3.0 and 3.5 framework address the 2.0 CLR.

I don't know what this means. If I don't have the 2.0 framework installed, and I don't have this utilitiy, then how am
I supposed to initialize my membership database?

Jonathan

[sloan]

Unlike the jump from 1.1 to 2.0...

3.0 and 3.5 are more like "add-ons" to 2.0.

.............

The 2.0 one is the one you need.

"Jonathan Wood" <jw***@softcircuits.comwrote in message
news:em**************@TK2MSFTNGP04.phx.gbl...

Juan,

>re:
!For one thing, he says where this utility is located, under the
framework 2.0
!subdirectories, where I found it. But there is no such utility under
the 3.0
!or 3.5 subdirectories.

That's because there's no need for them there.
Both the 3.0 and 3.5 framework address the 2.0 CLR.

I don't know what this means. If I don't have the 2.0 framework installed,
and I don't have this utilitiy, then how am I supposed to initialize my
membership database?

Jonathan