Women in Technology

Hear us Roar

  Building Web Parts, Part 1
Subject:   Apparently this demo requires SQL Server Express 2005
Date:   2005-05-26 21:28:34
From:   lwm
Response to: Apparently this demo requires SQL Server Express 2005

Hi Mark:
By default, web parts uses the SQL 2005 Express provider for data storage. To use SQL Server 2000, you need to do some work:

1. Use the aspnet_regsql.exe tool located in
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50215\ to prepare SQL Server 2000. Essentially it will add the aspnetdb database.

2. In Web.config, add the following:

<add name="myconnstring"
connectionString="Data Source=your_server_name;Initial Catalog=aspnetdb;Integrated Security=True"
providerName="System.Data.SqlClient" />


<add name="SqlPersonalizationProvider"
applicationName="/" />
<deny users="*" verbs="enterSharedScope" />
<allow users="*" verbs="modifyState" />

That should work fine for you.

Hope it helps.
BTW, Firefox doesn't seem to work too well with Web parts.


Full Threads Oldest First

Showing messages 1 through 3 of 3.

  • Apparently this demo requires SQL Server Express 2005
    2007-04-19 22:17:30  shhhh [View]

    when i use this code in web.config,it gives following error:
    Parser Error Message: The provider 'SqlPersonalizationProvider' specified for the defaultProvider does not exist in the providers collection.

    Source Error:

    Line 129:
    Line 130: <webParts>
    Line 131: <personalization defaultProvider="SqlPersonalizationProvider">
    Line 132: <providers>
    Line 133: <clear/>

  • Firefox and AJAX capabilities for WebParts
    2006-07-23 22:55:48  dipg [View]

    Found this usercontrol on www.smartjungle.com which provides a WebParts control to get AJAX capabilities and complete Firefox compatibility with no extra code.

  • Apparently this demo requires SQL Server Express 2005
    2006-01-21 14:08:59  thompson1022 [View]

    I have sql 2005 and was experiencing the same issue. This solution worked for me. Thank you very much.