How to configure ASP.NET MVC to use a SQL Server database in AppHarbor
TweetIn this tutorial about how to deploy ASP.NET MVC applications to AppHarbor is to update the ASP.NET MVC web.config file, commit the change and push the Git repository to AppHarbor.
Modify the connection string in the ASP.NET MVC web.config to use the AppHarbor database created in last tutorial.
<connectionStrings>
<add name="MusicStoreEntities"
connectionString="Server=db003.appharbor.net;Database=db1814;User ID=db1814;Password=<yourpassword>"
providerName="System.Data.SqlClient" />
</connectionStrings>
In the directory containing your ASP.NET MVC solution, right click and start Git Bash, or start Git Bash and navigate to the directory.
Execute the following commands to commit the updated web.config file in the git repository and push to AppHarbor
git add MvcMusicStore/web.config git commit –m "Now using AppHarbor SQL Server" git push appharbor master
Once the appliation has been built you should have a working ASP.NET MVC Music store running in AppHarbor.

