I was using the built in .met membership to develop and have now moved to the live server where I am now using a full version of sql server as opposed to express so my membership stopped working.
I have moved the aspnet.mdf to a different location and attached to sql server.
I have then changed my connection string to the following. I can log in via sql server and run selects etc against the membership database but am getting:
Cannot open database "aspnetdb" requested by the login
when trying to use the membership via the database...
Anyone see what I am doing wrong?
<add name="ApplicationServices" connectionString="data source=myserver;persist security info=True;initial catalog=aspnetdb;user id=myuser;password=mypassword;" providerName="System.Data.SqlClient" />