sql databases 1

[kss444]

I have VS 2008 and sql server developers 2005.
When I installed VS I did not install sql express.

If I install sql express 2005 after the fact, does anyone know of any complications this would cause.

I am playing with web parts and they use personalization and the page is wanting to access the roles, membership table that gets created with the asp.net configuration tool.

I could just create the table with the sql I have then create a provider in my web.config. But just wanted to do the lazy thing, since I am just playing around.

Ordinary Programmer

 

[jbenson001]

If I install sql express 2005 after the fact, does anyone know of any complications this would cause.
[/quoute]
There is no issue in doing this.

I would just create the tables you need for the webparts in whatever DB you will be using, with a custom provider, because at some point you will want to customize their standard table schema.

 

[kss444]

Yea, I went with the custom provider. Although it took me awhile to get it working. I needed to add the <WebPart> tag to my config file.

<webParts>
<personalization defaultProvider="SqlMembershipProvider">
<providers>

<clear />
<add connectionStringName="aspnetdb"
name="SqlMembershipProvider" type="System.Web.UI.WebControls.WebParts.SqlPersonalizationProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
</providers>

</personalization>

</webParts>

It's great when books on the subject don't mention this at all.

Ordinary Programmer

 

[jbenson001]

you'll be able to dig up the help you need if you use Google. It is definately my greatest soruce of help.