this happened because I had an instance of SS 2008 installed on my machine and then I installed visual studio express with ss express. I needed to set the properties of the instance to allow both windows and sql server authentication.