Sep 04, 2010
Thanks for the advice. I tried what you mentioned but it does not seem to be working. Let me give you the environment I am working on.
Stand alone laptop with Windows 7 (ultimate ediition).
SQL server 2008 developer edition
Sql serverr 2008 R2 Express edition (removed now)
Sql server 2005 Express edition with SP2
Visual studio 2010 ultimate edition
I made a small change in WCF application app config for localsqlserver to point SQL server 2008 developer edition (where i have aspnetdb). So now atleast the login part is working. But failing at GetCustomers in Model.cs with the error message 'The underlying provider failed to open'. There is a image of error attached with this post.
I tried to attach Action.mdf and aspnetdb.mdf to both the sql server instances and it failed.
Basically I am trying to point at the databases in SQL Server Developer Edition instead of attaching at runtime.
Can you give me some suggesstions where to make changes in the config files?
Sep 06, 2010
In the documentation, specifically the Patterns in Action 4.0 pdf on page 15 and up you'll find the necessary instructions on how to use SQL Server, rather than SQL Express.
Hope this helps.
Sep 27, 2010
I got same proplem today but got it fixed pretty fast. I just renamed C:\Documents and Settings\xxxxxx\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS folder and restarted SQL servers service.