Re: How to Manager the ASP.NET Web Site Administration Tool

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!

.

Relevant Pages

  • Re: How to Manager the ASP.NET Web Site Administration Tool
    ... Review his instructions, and see if you're missing anything. ... It details how to use the ASP.NET SQL Server Registration Tool to copy ... I changed my Web.config file to look at this [local SQL 2000] ...
    (microsoft.public.dotnet.framework.aspnet)
  • VSnet.ide cannot see local SQL db, but Enterprise Manager can
    ... I have inexplicably lost my SQL Server connection to my local SQL Server ... How could it be that Enterprise Manager can still see and manipulate the SQL ...
    (microsoft.public.vsnet.ide)
  • Re: How to Manager the ASP.NET Web Site Administration Tool
    ... It details how to use the ASP.NET SQL Server Registration Tool to copy ... I changed my Web.config file to look at this [local SQL 2000] ... connection by using this: ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Use of Linked tables via ODBC to SQL server over wi-fi
    ... across anything other than a LAN is not a good idea, but if the backend is a SQL Server, are there the same issues if the FE is via linked tables using ODBC and the connection is unstable - assuming of course that the system is coded so that all updates are passed back to the server? ... ADO and XML - although from what I can see, there would be a lot more development effort in this solution ... use a local SQL Express or MSDE with replication as local BE ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Data Providers not listed in Visual Studio
    ... Are you saying that you don't see the Access or Oracle providers? ... What is in the drop-down list shown in the Create Connection dialog? ... Hitchhiker’s Guide to Visual Studio and SQL Server ... All 3 are SQL Server, ...
    (microsoft.public.dotnet.framework.adonet)