I think this falls into the category of 'never ask a developer to do a server administrator's job'.
I'm a developer writing a couple of ASP.NET MVC 2 sites. I've attempted to use the ASP.NET Configuration Tool to create some user roles, but it keeps giving me an error stating that it can't find my data store, and that the AspNetSqlProvider cannot connect to the db. I have run aspnet_regsql, but that only created the tables necessary for user management. It did nothing to help my connection problem. From what I can see, my connection strings are okay.
As a test, I fired up some MVC tutorial apps in the debugger. Both displayed and saved my inputed data, so it seems like the database is working to some extent.
Following that, I decided to test if I could attach some .mdf files to the db via the Management Studio. I tried both an 'empty' file (folder structure intact, but no tables) and one that I've fleshed out for one of my projects. In both cases, the Management Studio claimed it couldn't find the files, despite both existing and me manually entering their paths.
All of this seems to point to a permissions issue. I'm just not sure on which side the problem resides - db or files - or how to fix it. Any help would be greatly appreciated.
Note: all of this is happening on my Win 7 laptop, with Visual Studio 2010 Professional.