jshahan (7/18/2013)
I thought if you were working on the same box that had the database engine, you could always use local.
The box can host more than one instance of the engine, and therefore any instances must be referred to by name. Only the default instance allows you to connect using (local).
You can run SQL Server Configuration Manager to see installed instances.
