SQL Server

Introduction

At times, Windows Authentication in Microsoft SQL Server is not enough. One of the requirements is in ASP.Net as described in the FAQ here. This article descibes how to setup mixed mode authentication, also known as SQL Authentication, in Microsoft SQL Server 2000, 2005 and 2005 Express Edition.

Now of course, the need does not arise if the care is taken during installation of SQL Server 2000 and 2005. But for SQL Server 2005, it becomes mandatory. We explore all versions anyway.