sql server login failing for sa and other SS authentication

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.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.