Article 290 links to another article: Why Don't I See a Security Tab on the Properties dialog for My Files and Folders in Windows XP? Why?

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

Imar,
I was able to do above steps/instructions you gave me. Still I'm getting same error.

Also, I notice when I close Visual Studio and come back again, aspnetdb.mdf and wroxunited.mdf are not connected anymore. So I have to connect them again.

I don't know what I missed.

Are you still getting the same error about the "user instance login flag not being supported on this version of SQL Server"?

The error message seems to suggest you're having problems with the Profile features that also uses a database. Did you reconfigure settings for Profile in web.config as well?

If that's not the case, then I don't know why you get this error....

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

Yes, that's what I said on my previous post.

What do you mean "reconfigure settings"?

Yeah, I know you said that. However, a lot can change between posts and I don't feel like hunting a problem that doesn't exist anymore... ;)

Profiles in ASP.NET 2 by default use a local SQL Server Express database called aspnetdb.mdf. This database is generated automatically in App_Data if it isn't there.

However, it's possible to redirect the Profile feature to a different database using the <providers> setting under the <profile> element in web.config. If you have that element, take a look at the connectionString name attribute. Does it point to your database?

And for what accounts did you configure security for the App_Data folder?

If the element isn't there. move the aspnetdb.mdf away from App_Data and rerun the site that generates this error. Do you get a new database in App_Data?

You may also want to try clearing the entire c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temp orary ASP.NET Files\ folder and then recompile the application. Maybe you're looking at old stuff.

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

First of all. I want to thank for your help and patience. The reason I asked you before if we can do this offline was because I'm running out of patience. I already lost one weekend productivity. I'm thinking leaving this behind and move forward to something else. But I cannot go on if I have something unfinished work. I don't have peace.

I will try again your suggestion. I'm thinking may be this is a VS bug.

Yeah, I see your point. Unfortunately, I don't have the time to fully guide you through this off-line. I can try to help you here, and that's all I can do. Sorry. I think you can call Microsoft and pay for incident support.

I doubt it's a VS bug. The thing with SQL Server Express is exactly as someone else on this forum recently said: it's meant to work out of the box without any problems. 9 out of 10 times, it does. However, since it's a black box, it's really hard to diagnose what is going on when things *don't* work as expected.

Here's one more thing you can try:

1. Choose File | New Web site to create an entirely new web site

2. On Default.aspx, drag a Login control

3. Hit F5 to view the page in the browser.

4. Login with a fake name and password

Do you get a nice message saying you can't log in? And do you have a database in App_Data called asnnetdb.mdf? If so, SQL and your machine are setup fine and something else is messed up....

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
While typing this post, I was listening to: Justic Is Might by Sonic Youth (Track 7 from the album: Bad Moon Rising) What's This?

Imar,

I followed above posting.

1. I got the same error "user instance login".

2. There's no aspnetdb.mdf in app_data.

This is very weird

I tried aspnet_regsql.exe. It doesn't create the aspnetdb.mdf

In that case, I don't think you have a valid instance of SQL Server Express installed and / or up and running.

I would look into that first...

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.