Last post Feb 01, 2008 02:12 AM by quincarroll
Nov 13, 2007 02:19 PM|jchappell|LINK
Trying to implement this in SQL Server 2005. Not the express version. I changed the web.config connection string but I am still getting the error message about trying to create the databsae in Express. I have deleted the mdf file and I ahve created the
database on my local server using the .sql files in the project.
Has anyone been able to get this done?
Nov 13, 2007 03:14 PM|ashmetry|LINK
Yes i did that in www.love2trade.com. You can merge the 2 DBs like alot of people did, but the trick is for the membership DB is to keep the name
LocalSqlServer (don't rename it!), but add <clear/> before you you specify your connection string to override the default database location which is why the mdf file keeps re-creating...
If you havent done so already you will also need to configure your sql server database for memebrship you can use the tool C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regsql.exe
Feb 01, 2008 02:12 AM|quincarroll|LINK
This worked very well for me.
Thank you for the help.