Aspnet_regsql.exe (Unable to use SQL Server because…)

My solution was running the following command which I put together using the documentation on this site (http://msdn.microsoft.com/en-us/library/ms229862.aspx).

aspnet_regsql -d <databasename> -ssadd -sstype c -U <username>