Orchard fails to build after switching to Sql Server

Topics: Customizing Orchard, Installing Orchard, Troubleshooting
Aug 6, 2013 at 3:25 PM
Edited Aug 6, 2013 at 4:07 PM
I originally set Orchard to use a Compact Sql Database but now I want to use a Sql Server hosted on my local machine for testing purposes before I migrate to an externally hosted database.

Orchard is failing to build though with this Settings.txt file:

Name: Default
DataProvider: SqlServer
DataConnectionString: Data Source=localhost:1433\Name;Initial Catalog=ProjectTrackingSiteTemporary;User Id=project-tracking-admin; Password=*******;

based on the information provided in this SO topic

EDIT: Solved, changed the attempt to connect on default Sql port to (local) instead and it worked. Not sure why 1433 gave it issues.