473,378 Members | 1,369 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,378 software developers and data experts.

How to Manager the ASP.NET Web Site Administration Tool

Hello,

I am a somewhat experienced VS 2005 user who is trying to us the
ASP.NET Web Site Administration Tool for the first time. I have
experimented with it on my local IIS and it seems to be an excellent
tool for security administration. However, I have some long term
questions.

Where does the W.S.A.T. store its information? In my local SQL Server
2000, I can see a database called "aspnetdb" - however none of the
tables contain any data (despite the fact that I have created a couple
of users & roles). Is it storing them in the local instance of SQL
Server 2005 Express that was installed with VS 2005? If so, I suppose
I need to install that "SQL Server 2005 Management Studio Express
Edition", correct?

This leads me to my next question. While I don't really "care" right
now where the data is stored, I WILL care when I move my completed
application to the real SQL Server 2000 that my company uses. How
would I make the switch so that my ASP.NET application looks in a
location on another server? I have seen some articles discussing this
issue, and they all deal with modifying a .config file to use a
different connection string. Am I on the right track?

Obviously, I am a newbie when it comes to this stuff, so I would
greatly appreciate any guidance that anyone could offer me.
Thank you in advance,

Jan 24 '07 #1
8 1991

Check the .config files after you run the tool.

Type in a role like "PeanutBuddy" and do a search for that unique string.
I'm going from memory, but I think you'll find it in a xml or config file.
...

Personally, I wouldn't use the tool. I think its more for RAPID deployment.

Take a crack at a Custom Membership Provider or Custom Role Provider.


"Kirk" <lo****@hotmail.comwrote in message
news:11*********************@l53g2000cwa.googlegro ups.com...
Hello,

I am a somewhat experienced VS 2005 user who is trying to us the
ASP.NET Web Site Administration Tool for the first time. I have
experimented with it on my local IIS and it seems to be an excellent
tool for security administration. However, I have some long term
questions.

Where does the W.S.A.T. store its information? In my local SQL Server
2000, I can see a database called "aspnetdb" - however none of the
tables contain any data (despite the fact that I have created a couple
of users & roles). Is it storing them in the local instance of SQL
Server 2005 Express that was installed with VS 2005? If so, I suppose
I need to install that "SQL Server 2005 Management Studio Express
Edition", correct?

This leads me to my next question. While I don't really "care" right
now where the data is stored, I WILL care when I move my completed
application to the real SQL Server 2000 that my company uses. How
would I make the switch so that my ASP.NET application looks in a
location on another server? I have seen some articles discussing this
issue, and they all deal with modifying a .config file to use a
different connection string. Am I on the right track?

Obviously, I am a newbie when it comes to this stuff, so I would
greatly appreciate any guidance that anyone could offer me.
Thank you in advance,

Jan 24 '07 #2
I guess I should have dug a little deeper before posting. I found this
article, which was very helpful:

http://aspnet.4guysfromrolla.com/articles/121405-1.aspx

It details how to use the ASP.NET SQL Server Registration Tool to copy
[create] the required schema to the database of your choosing.

I changed my Web.config file to look at this [local SQL 2000]
connection by using this:

<connectionStrings>
<add name="MyDB" connectionString="Provider=SQLOLEDB.1; Integrated
Security=SSPI; Initial Catalog=aspnetdb; Data Source=(local)" />
</connectionStrings>

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

<membership>
<providers>
<add connectionStringName="MyDB"
name="CustomizedMembershipProvider"
type="System.Web.Security.SqlMembershipProvider" />
</providers>
</membership>

which seems to work EXCEPT I still can't see any data in the aspnetdb
tables (even though I have created multiple users & roles). From what
I now know, the Web Site Administration Tool was using a database it
automatically created in SQL Server 2005 Express, but I thiink I have
made everything "switch" to my local SQL 2000 server. Can anyone tell
me why I still cannot see this information in my local server?

Thank you in advance for any replies!

Jan 24 '07 #3

Did you try the search for unique name thing? and come up empty?

Try that first. and report back.


"Kirk" <lo****@hotmail.comwrote in message
news:11**********************@l53g2000cwa.googlegr oups.com...
I guess I should have dug a little deeper before posting. I found this
article, which was very helpful:

http://aspnet.4guysfromrolla.com/articles/121405-1.aspx

It details how to use the ASP.NET SQL Server Registration Tool to copy
[create] the required schema to the database of your choosing.

I changed my Web.config file to look at this [local SQL 2000]
connection by using this:

<connectionStrings>
<add name="MyDB" connectionString="Provider=SQLOLEDB.1; Integrated
Security=SSPI; Initial Catalog=aspnetdb; Data Source=(local)" />
</connectionStrings>

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

<membership>
<providers>
<add connectionStringName="MyDB"
name="CustomizedMembershipProvider"
type="System.Web.Security.SqlMembershipProvider" />
</providers>
</membership>

which seems to work EXCEPT I still can't see any data in the aspnetdb
tables (even though I have created multiple users & roles). From what
I now know, the Web Site Administration Tool was using a database it
automatically created in SQL Server 2005 Express, but I thiink I have
made everything "switch" to my local SQL 2000 server. Can anyone tell
me why I still cannot see this information in my local server?

Thank you in advance for any replies!

Jan 24 '07 #4
Hi, Kirk.

Scott Guthrie has instructions on how to do what you want to do
( run Membership on your my local SQL 2000 server ) , here :

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

Review his instructions, and see if you're missing anything.


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/
===================================
"Kirk" <lo****@hotmail.comwrote in message
news:11**********************@l53g2000cwa.googlegr oups.com...
>I guess I should have dug a little deeper before posting. I found this
article, which was very helpful:

http://aspnet.4guysfromrolla.com/articles/121405-1.aspx

It details how to use the ASP.NET SQL Server Registration Tool to copy
[create] the required schema to the database of your choosing.

I changed my Web.config file to look at this [local SQL 2000]
connection by using this:

<connectionStrings>
<add name="MyDB" connectionString="Provider=SQLOLEDB.1; Integrated
Security=SSPI; Initial Catalog=aspnetdb; Data Source=(local)" />
</connectionStrings>

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

<membership>
<providers>
<add connectionStringName="MyDB"
name="CustomizedMembershipProvider"
type="System.Web.Security.SqlMembershipProvider" />
</providers>
</membership>

which seems to work EXCEPT I still can't see any data in the aspnetdb
tables (even though I have created multiple users & roles). From what
I now know, the Web Site Administration Tool was using a database it
automatically created in SQL Server 2005 Express, but I thiink I have
made everything "switch" to my local SQL 2000 server. Can anyone tell
me why I still cannot see this information in my local server?

Thank you in advance for any replies!

Jan 24 '07 #5
OK, this is getting more convoluted by the minute. I tried this:

1) I added some obscurely-named role (via the ASP.NET configuration
tool) and tried to find it without success. I searched through all the
files on my computer. Any guesses where I should be looking?
2) I read & reread Scott Guthrie's article to no avail. Using his
guidlines, I changed the web.config to read:

<connectionStrings>
<remove name="LocalSqlServer" />
<add name="LocalSqlServer"
connectionString="Provider=SQLOLEDB.1; Integrated Security=SSPI;
Initial Catalog=aspnetdb; Data Source=MYLOCALCOMPUTER"
providerName="System.Data.SqlClient" />
</connectionStrings>

....which seemed to work (the web pages of my site don't display SQL
errors when displayed). But when I fire up the ASP.NET Web Site
Adiministration Tool and go to the security tab, this error message is
displayed:

"There is a problem with your selected data store. This can be caused
by an invalid server name or credentials, or by insufficient
permission. It can also be caused by the role manager feature not being
enabled. Click the button below to be redirected to a page where you
can choose a new data store.

The following message may help in diagnosing the problem: An error
occurred while attempting to initialize a
System.Data.SqlClient.SqlConnection object. The value that was provided
for the connection string may be wrong, or it may contain an invalid
syntax. Parameter name: connectionString "

WT? I realize that I am new at this, but for something that is
supposed to be so simple to implement, this is getting ridiculous.
Sorry to vent - I am just getting a little frustrated.

To try something new, I created a brand new Web application in VS 2005
(just in case I had mucked something up in my previous attempts). This
ended up with the same results as above. Also, if I go to the
"Providers" tab in ASP.NET's WSAT, it shows a "Could not establish a
connection to the database" error when I click "test".

Thank you very much for your suggestions (& patience), but I am not
sure what to try next. I would appreciate any further comments.

Jan 24 '07 #6
Because you don't know any better and nobody has the character to tell you
the WAT is currently am incomplete and buggy piece of crap. Use it with 2.0
and it writes into the web.config file disabling Intellisense. It can only
be used on a development machine so its really useless for the time being.
Better to find a 3rd party solution if you need support for now.

<%= Clinton Gallagher
NET csgallagher AT metromilwaukee.com
URL http://clintongallagher.metromilwaukee.com/
MAP http://wikimapia.org/#y=43038073&x=-...8&z=17&l=0&m=h

"Kirk" <lo****@hotmail.comwrote in message
news:11*********************@l53g2000cwa.googlegro ups.com...
Hello,

I am a somewhat experienced VS 2005 user who is trying to us the
ASP.NET Web Site Administration Tool for the first time. I have
experimented with it on my local IIS and it seems to be an excellent
tool for security administration. However, I have some long term
questions.

Where does the W.S.A.T. store its information? In my local SQL Server
2000, I can see a database called "aspnetdb" - however none of the
tables contain any data (despite the fact that I have created a couple
of users & roles). Is it storing them in the local instance of SQL
Server 2005 Express that was installed with VS 2005? If so, I suppose
I need to install that "SQL Server 2005 Management Studio Express
Edition", correct?

This leads me to my next question. While I don't really "care" right
now where the data is stored, I WILL care when I move my completed
application to the real SQL Server 2000 that my company uses. How
would I make the switch so that my ASP.NET application looks in a
location on another server? I have seen some articles discussing this
issue, and they all deal with modifying a .config file to use a
different connection string. Am I on the right track?

Obviously, I am a newbie when it comes to this stuff, so I would
greatly appreciate any guidance that anyone could offer me.
Thank you in advance,

Jan 24 '07 #7
Clinton,

Thanks for your input. You are right about one thing - I don't know
any better right now, because I don't know what my other alternatives
are. Can you or somebody point me in the right direction of a 3rd
party solution that is out there? Quite frankly, I would not know
where to begin.

Thank you.

On Jan 24, 5:30 pm, "clintonG"
<csgallag...@REMOVETHISTEXTmetromilwaukee.comwrote :
Because you don't know any better and nobody has the character to tell you
the WAT is currently am incomplete and buggy piece of crap. Use it with 2.0
and it writes into the web.config file disabling Intellisense. It can only
be used on a development machine so its really useless for the time being.
Better to find a 3rd party solution if you need support for now.

<%= Clinton Gallagher
NET csgallagher AT metromilwaukee.com
URLhttp://clintongallagher.metromilwaukee.com/
MAPhttp://wikimapia.org/#y=43038073&x=-88043838&z=17&l=0&m=h

"Kirk" <lok...@hotmail.comwrote in messagenews:11*********************@l53g2000cwa.go oglegroups.com...
Hello,
I am a somewhat experienced VS 2005 user who is trying to us the
ASP.NET Web Site Administration Tool for the first time. I have
experimented with it on my local IIS and it seems to be an excellent
tool for security administration. However, I have some long term
questions.
Where does the W.S.A.T. store its information? In my local SQL Server
2000, I can see a database called "aspnetdb" - however none of the
tables contain any data (despite the fact that I have created a couple
of users & roles). Is it storing them in the local instance of SQL
Server 2005 Express that was installed with VS 2005? If so, I suppose
I need to install that "SQL Server 2005 Management Studio Express
Edition", correct?
This leads me to my next question. While I don't really "care" right
now where the data is stored, I WILL care when I move my completed
application to the real SQL Server 2000 that my company uses. How
would I make the switch so that my ASP.NET application looks in a
location on another server? I have seen some articles discussing this
issue, and they all deal with modifying a .config file to use a
different connection string. Am I on the right track?
Obviously, I am a newbie when it comes to this stuff, so I would
greatly appreciate any guidance that anyone could offer me.
Thank you in advance,- Hide quoted text -- Show quoted text -
Jan 25 '07 #8
I'm using a free control [1] that is doing okay considering. Peter Keller
[2,3] has done some work in this context.

<%= Clinton Gallagher
NET csgallagher AT metromilwaukee.com
URL http://clintongallagher.metromilwaukee.com/
MAP http://wikimapia.org/#y=43038073&x=-...8&z=17&l=0&m=h

[1]
http://www.qualitydata.com/products/...e/summary.aspx
[2] http://msdn2.microsoft.com/en-us/library/aa478958.aspx
[3] http://msdn2.microsoft.com/en-us/library/aa478947.aspx

"Kirk" <lo****@hotmail.comwrote in message
news:11**********************@v33g2000cwv.googlegr oups.com...
Clinton,

Thanks for your input. You are right about one thing - I don't know
any better right now, because I don't know what my other alternatives
are. Can you or somebody point me in the right direction of a 3rd
party solution that is out there? Quite frankly, I would not know
where to begin.

Thank you.

On Jan 24, 5:30 pm, "clintonG"
<csgallag...@REMOVETHISTEXTmetromilwaukee.comwrote :
>Because you don't know any better and nobody has the character to tell
you
the WAT is currently am incomplete and buggy piece of crap. Use it with
2.0
and it writes into the web.config file disabling Intellisense. It can
only
be used on a development machine so its really useless for the time
being.
Better to find a 3rd party solution if you need support for now.

<%= Clinton Gallagher
NET csgallagher AT metromilwaukee.com
URLhttp://clintongallagher.metromilwaukee.com/
MAPhttp://wikimapia.org/#y=43038073&x=-88043838&z=17&l=0&m=h

"Kirk" <lok...@hotmail.comwrote in
messagenews:11*********************@l53g2000cwa.g ooglegroups.com...
Hello,
I am a somewhat experienced VS 2005 user who is trying to us the
ASP.NET Web Site Administration Tool for the first time. I have
experimented with it on my local IIS and it seems to be an excellent
tool for security administration. However, I have some long term
questions.
Where does the W.S.A.T. store its information? In my local SQL Server
2000, I can see a database called "aspnetdb" - however none of the
tables contain any data (despite the fact that I have created a couple
of users & roles). Is it storing them in the local instance of SQL
Server 2005 Express that was installed with VS 2005? If so, I suppose
I need to install that "SQL Server 2005 Management Studio Express
Edition", correct?
This leads me to my next question. While I don't really "care" right
now where the data is stored, I WILL care when I move my completed
application to the real SQL Server 2000 that my company uses. How
would I make the switch so that my ASP.NET application looks in a
location on another server? I have seen some articles discussing this
issue, and they all deal with modifying a .config file to use a
different connection string. Am I on the right track?
Obviously, I am a newbie when it comes to this stuff, so I would
greatly appreciate any guidance that anyone could offer me.
Thank you in advance,- Hide quoted text -- Show quoted text -

Jan 25 '07 #9

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: RickatGoIn | last post by:
We are currently using the security features included with latest .NET 2.0 Framework (v2.0.50215), including the Web Site Administration Tool. The only problem we have encountered thus far is...
1
by: RCS | last post by:
All, When I create a website locally, I have that little Administration tool (the little icon in the Solution Explorer - or under Website | Web Site Administration) - but when I connect to a 2.0...
2
by: John | last post by:
Hi Web site administration tool is great. How can I provide this functionality for the end user? I need the end user Admin to be able to list users and then change roles for any of the users or...
16
by: jblankenburg | last post by:
I am trying to deploy a simple web application to my client's production server, but it's not clear to me how MS planned on having the Security users managed without Studio. Certainly someone...
6
by: cmay | last post by:
I am finding this hard to believe... Is there really no way to access the Web Site Administration Tool when a site is deployed? I know I can open it on my local computer running VS.Net, but...
0
by: Ian Pitt | last post by:
I am unable to add users using the Web Site Administration Tool. I can create/delete roles, but when I try to add a user I get an exception. I posted the error below: An error was encountered....
0
by: GreggTB | last post by:
I have written two custom providers for our Oracle 9i database...a Membershp provider and a Role provider. I've been testing these over the last few days and they seem to be working well. However,...
3
by: =?Utf-8?B?Um9nZXIgTWFydGlu?= | last post by:
When using the Web Site Administration Tool, I get the following error when trying to delete a user in a web application I configured to use membership, roles, and profiles: "An error was...
1
by: ZZ_Scarab | last post by:
Hi, <I posted this on the microsoft.public.dotnet.framework.aspnet.security newsgroup but before I got a reply this newsgroup has become unavailable!! So I'm posting it here again. Sorry for the...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.