After I have signed up with GoDaddy on the Windows Hosting plan, I've found out that there are actually alot of complaints and grumbles on the many limitations and poor technical support on GoDaddy.
Well, things that are cheap are of course comes at a price. Yes, GoDaddy's windows shared hosting is cheap, but there are workarounds.... so not to worry. Let's get started on the tips & tricks.
Tips & Tricks
Tip 1: SQL Express
If you're using windows shared hosting, you don't have access to the server to run the aspnet_regsql.exe against it. GoDaddy is very strict about what remote connections it allows to the live database. Also, be aware that GoDaddy doesn't support SQL Express (like those mdf database you normally saved it in /Apps_Data folder) - you'll be using its big brother SQL Server. But that's not a problem as the basic plan comes with 1 free SQL DB! (How cool is that?!)
Basically, follow these steps:
1. Create a new database using the GoDaddy control panel. Because you are sharing the database server with other databases, you'll only be allowed use a name that doesn't already exist. This should explain why you can't call it ASPNETDB - someone else has probably snapped that one up.
2. If you need to install the ASP.Net Security Schema - there's an option on the "Create Database" GoDaddy configuration page. Check the option when you're creating the database and all the tables and stored procedures will be installed in the database.
That's about it. Good luck.
Tip 2: Email settings
To setup email on BlogEngine.NET on Godaddy, configure the email settings as follows:
The SMTP relay server is relay-hosting.secureserver.net