SQL Express Mixed Mode Authentication
January 2nd, 2008 | 
Author: 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.
Other Related Items:
Microsoft Visual Studio 2008 Professional Academic EditionVSTUDIO PRO 2008 AE DVD
Fable: The Lost ChaptersBased on the best-selling award-winning Xbox title Fable, Fable: The Lost Chapters is now fully optimized for the Windows platform complete with expan... Read More >
Fiskars Squeeze Punch, Large - CircleFISKARS-Squeeze Punch Large-Limited Edition. Fiskars Flipped everything over so you do not have to. Now you can easily see when the paper is lined u... Read More >
Related Post
Posted in 
Tags: 
