I finally got the site to come up on my hosting machine. But when I type the user name and password that I created in the asp.net configuration, it will not accept. If I go back to the visual web devel. I can log in with no problem. If I try to create a
new user it tells me that the database is in read only mode. How can I change the database and how can I get it to see the user I have already created. I have check that the mdf connection from the host site points to it mdf file but still no success.
Regards
Jeremy
If this has helped Please: Don't forget to click "Mark as Answer" on the post that helped you.
That way future readers will know which post solved your issue.
None
0 Points
9 Posts
MDF Issue with login
Jul 19, 2008 11:28 PM|ayado|LINK
I finally got the site to come up on my hosting machine. But when I type the user name and password that I created in the asp.net configuration, it will not accept. If I go back to the visual web devel. I can log in with no problem. If I try to create a new user it tells me that the database is in read only mode. How can I change the database and how can I get it to see the user I have already created. I have check that the mdf connection from the host site points to it mdf file but still no success.
Contributor
5190 Points
1469 Posts
Re: MDF Issue with login
Jul 20, 2008 11:17 AM|jeremyh|LINK
Most hosting companies will not allow you to run sql express database from the app_data folder you need to move the database to the hosted sql server.
You will find the steps here http://weblogs.asp.net/scottgu/archive/2006/12/22/recipe-deploying-a-sql-database-to-a-remote-hosting-environment-part-1.aspx
Also you will need to up date your web.config connectionstring to point to the hosts sql server and set the applicationname, more info about that here
http://weblogs.asp.net/scottgu/archive/2006/04/22/Always-set-the-_2200_applicationName_2200_-property-when-configuring-ASP.NET-2.0-Membership-and-other-Providers.aspx
Hope it helps
Jeremy
If this has helped Please: Don't forget to click "Mark as Answer" on the post that helped you.
That way future readers will know which post solved your issue.