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.
If you're new here, you may want to subscribe to my RSS feed. Thanks for visiting!
