If you happen to get the following sql error:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005 or above, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections..
You are not alone. There are a lot of solutions out on the web, the best i can find is this:
However, the error i am getting is actually because i have installed the full version of SQL without the SQL Express. However, my sql command was actually calling
sqlcmd -S localhost \sqlexpress -E -b –d databaseName -i sqlScriptPath
instead you need to call
sqlcmd -S localhost -E -b –d databaseName -i sqlScriptPath