SQL Express Mixed Mode Authentication

So, I’m getting ready to do some data binding demos and I realized that when I installed visual studio, I forgot to install SQL Server Express first so that I could control the install.

You see, when you install visual studio, it installs SQL Server Express for you.  But, it installs it using Windows Authentication by default.  In fact, if you’ve installed Visual Studio already, you already know that it doesn’t even give you the option of installing for mixed mode.

If you’ve searched the web, you’ll see all kinds of hacks telling you how to get around this issue.  But, they all end up having you create a new sa user (sa1 for example) instead of giving sa a SQL password.  Dumb!

Here’s the right way to install SQL Server Express.

Related Post

Leave a Reply

Comment Policy:

  • You must verify your comment by responding to the automated email that is sent to your email address. Unverified comments will never show.Leave a good comment that adds to the conversation and I'll leave your link in.
  • Leave me pure spam and I'll delete it.
  • Leave a general comment and I'll remove the link but keep the comment.

Notify me of followup comments via e-mail