Here are steps that will let you configure your godaddy MS sql server host.
you nee to Login http://www.godaddy.com/gdshop/default.asp
under Hosting and servers menu click on my hosing account then select your domain and open your control panel
Click on Data bases then click on SQL server ICON
Create Data base
If you are done with all above steps
click on action Edit/View
then click on Configuration Icon
you will see all connection string
Data Source=whsql-v22.prod.mesa1.secureserver.net; Initial Catalog=Revonline; User ID=Revonline; Password='your password';
use your password and put the above connection string into web.config file of asp.net web application.
upload this web.config along with your web application
To execute your schema click on Open Manager
Use your Credentials used for SQL database
copy your schema paste it in the browser
then click execute to load your db schema on godaddy MS sql server host.
This way you can configure your asp.net web application hosted on godaddy server to use MS sql server provided by
godaddy hoting provider.