Can't attach sql database

[Bakedgoods]

I've created a database inside my ASP.net project, the database is in the App_Data folder as exepcted.

I can't run the aspnet_regsql until I have attached it using SQL Server Management Studio, but when I try to attach the database it doesn't let me navigate through my folders properly.


The database is in C:\Users\Wardie\Documents\FirstProject\App_Data but SQL SMS only lets me navigate to the folder C:\Users\Wardie and no further for some reason, meaning I can't attach the database and can't use the aspnet_regsql service to create the membership tables.

Does anyone know how to fix this?

 

[~J~]

Is this SQL2005?

If it is, then I DID have this problem, but the recent SP has resolved it.

 

[Bakedgoods]

Yeah SQL Server Express 2005, i'll have a look for it then?

Can't see how that would fix it though when the problem seems to be in management studio?

 

[DJ XS]

This might be down to how you have setup your authentication for SQL2005?

Do you have it in windows or mixed mode.

In which case how are you logging in to MS?

 

[Bakedgoods]

It's on windows authentication, should I try changing it to SQL?