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,

.

Relevant Pages

  • Re: ASPNETDB Problem - Unable to connect to SQL Server database
    ... I get the error message: "Unable to connect to SQL Server ... I then created the ASPNETDB database with the ASPNET_REGSQL ... I tried the Web Site Administration Tool and got the same error. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Web Site Administration Tool
    ... When I run the ASP.NET Web Site Administration Tool, ... "Could not establish a connection to the database. ... There is a database (in SQL Server 2005, ...
    (microsoft.public.vstudio.general)
  • Re: How to Manager the ASP.NET Web Site Administration Tool
    ... ASP.NET Web Site Administration Tool for the first time. ... I need to install that "SQL Server 2005 Management Studio Express ... While I don't really "care" right ...
    (microsoft.public.dotnet.framework.aspnet)
  • Web site Administration Tool Error
    ... I am unable to add users using the Web Site Administration Tool. ... I get the same error when I click on "use the Security Setup Wizard to configure security step by step" link ... I can see the created Roles in SQL server 2005 ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Renumbering MS db ID?
    ... I'm not an Access user, but as far as the notion that 'there is no need to ... MS Access or MS SQL Server? ... There is no need to care what the ... > guarrantees that and it is the only purpose autonumber is used for. ...
    (microsoft.public.data.ado)